Error message CacheAllData

[Jennypi]

Hello,

Any news?

Thanks!

[HighAley]

Hello.

Unfortunately, it's impossible to fix this issue.

Please, use next code in Click button of the button:

Code: Select all

Categories.ConnectOnStart = true;
Products.ConnectOnStart = true;

And next code in the Begin Render event of the

Code: Select all

Categories.ConnectOnStart = false;
Products.ConnectOnStart = false;

After adding this code your report will work right.

Thank you.

[Jennypi]

Hi,

Which databands should I add this code for?
The ones that are ConnectOnStart properties to false?

[HighAley]

Hello.

Yes, you should add such code for data sources where the ConnectOnStart property is set to false.

Thank you.

[Jennypi]

OK, and I need to add this code only if I have a relation in between those datasources?
Because it seems that when there is no relation, it is working OK, even if ConnectOnStart property is set to false.

Thank you.

[Jan]

Hello,

Yes, you are right. You need use CacheAllData property only if you have relations in different data sources. In this case, report engine merges all data sources in one ado.net and required relation can be created in the result.

Thank you.

[Jennypi]

Hello,

Can you explain the origin of this bug?
It looks strange to me, as my reports used to work with a previous version of Stimulsoft.
It is quite problematic for me: I need to modify all my reports containing a relation between 2 non-ConnectOnStart datasources. It's a lot of work, as I have hundreds of reports!
Are you sure that you cannot fix it?

Oh and I think you forgot one word Did you mean "And next code in the Begin Render event of the report"? Page? DataBand?

And next code in the Begin Render event of the

Code: Select all

Categories.ConnectOnStart = false;
Products.ConnectOnStart = false;

[HighAley]

Hello.

As we wrote before:
Unfortunately, it's impossible to fix this issue.

Thank you.

[Jennypi]

I think you forgot to answer my second question about the word you forgot.

[HighAley]

Hello.

Sorry, there should be report. The Begin Render event of the report.

Thank you.