master detail report not working in version 2016.1

[dikan]

Hello,
i am transferring reports from version 2013.3 to 2016.1 (reports are working since 2010 without problems) and here is the problem:
master detail reports with 2 data sources which i don't connect on start but after clicking on button OK in form when i pass dates to sql in data sources and connect data sources (reports provides data in time period which user selects in form), gives me this error: "Parent Data Source is not located in DataSet and can't be used in relation. You can use property CacheAllData of report to cache this Data Source to one DataSet." So i did: in my report properties, under section 2.Main i have now Cache All Data set to true but i still get same error.
Help me please.
If i didn't explain my problem well enough i will upload screenshots and more detailed descriptions.

Thank you.

[Alex K.]

Hello,

Please check the last build 2016.1.16.
If the issue still present, please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

[dikan]

ok..still not working...this is how report looks like and here are original report in version 2013.3 and firebird database

[dikan]

and i can't upload database..it's 8.4 MB..is that a problem? how can i send you database?
thanks.

[Alex K.]

Hello,

Please upload it to the file sharing service, dropbox, googledrive etc.

Thank you.

[dikan]

https://drive.google.com/file/d/0B2kZBl ... sp=sharing

waiting to hear back from you thanks

[Alex K.]

Hello,

We couldn't connect to your database. "Connecting... Failed!"
Can you please clarify the login and password for this database.

Thank you.

[dikan]

sorry..it's standard firebird login:

username: SYSDBA
password: masterkey

[Alex K.]

Hello,

Please try to use the following code in the button Click event:

Code: Select all

BRLPR.ConnectOnStart = true;
BRLPR2.ConnectOnStart = true;
BRLPR.Connect();
BRLPR2.Connect();

Thank you.

[dikan]

It's working thank you.

But now i am curious how is it that this works, but when i was trying to connect data sources on start (in properties of data source i've changed 'connect on start' from false to true) i was getting error 'Unhandled exception has occured in your application. Cannot remove table BRLPR, because it referenced in ForeignKeyConstraint..remove the constraint first' ...it would never occur to me to put it in button event.

Thank you.