Page 2 of 2
Re: Report from collecting Data from DB
Posted: Tue May 31, 2016 4:08 pm
by info@2next.it
Hello,
here you are...
this sample use ReconnectOnEachRow option...
I have a table product that has 2 relation on same table category, and I would like to know how is a right way to build report... in the first case, in report with same datasource I try to use only one object, but i don't know how filter subcategory.... In second case in report with different datasource you can see the correctly report but if I have more same relations I have to create more queries...
Is it possible use the first method...?
thanks
Re: Report from collecting Data from DB
Posted: Wed Jun 01, 2016 1:25 pm
by Alex K.
Hello,
Thank you for the sent sample. We need some time for check the issue.
Re: Report from collecting Data from DB
Posted: Fri Jun 03, 2016 10:30 am
by Alex K.
Hello,
Sorry for the delay with response.
In this case, you need to use the additional code in the AfterPrint (on the main databand and in the footer for first detail band) events and set the ConnectOnStart property to false for the SubCategorySet data source.
Please check the modified report in the attachment. But we recommend using the second way with two different data sources.
Thank you.
Re: Report from collecting Data from DB
Posted: Tue Jun 07, 2016 1:46 pm
by Alex K.
Hello,
The issue with RetrieveOnlyUsedData and relations was fixed.
The fix will be available in the next prerelease build which will be available in this week.
Thank you.
Re: Report from collecting Data from DB
Posted: Tue Jun 07, 2016 1:56 pm
by info@2next.it
Thank you very much!
Re: Report from collecting Data from DB
Posted: Wed Jun 08, 2016 5:41 am
by Alex K.
Hello
We are always glad to help you!
Thank you.
Re: Report from collecting Data from DB
Posted: Thu Jun 30, 2016 2:28 pm
by info@2next.it
Hello,
we have tested Retray only Used Data Options but doesn't work perfectly...
here you are example....
right preview without options:
- 1.png (90.89 KiB) Viewed 3715 times
Set the option:
- 2.png (82.39 KiB) Viewed 3715 times
Preview with error on Unity of Measure (NR, KG..) missing!!! (Take attentions that other properties are shown correctly like as {DocumentoDettaglioSet.DistintaFase.Distinta.Articolo.Descrizione})
- 3.png (95.47 KiB) Viewed 3715 times
Property wrong:
- 4.png (17.26 KiB) Viewed 3715 times
VERSION:
- 5.png (35.6 KiB) Viewed 3715 times
thanks
2NEXT STAFF
Re: Report from collecting Data from DB
Posted: Fri Jul 01, 2016 11:06 am
by Alex K.
Hello,
Can you please send us a simple report with test data which reproduces the issue for analysis.
Thank you.
Re: Report from collecting Data from DB
Posted: Fri Jul 01, 2016 1:58 pm
by info@2next.it
Hello,
I send this example to
support@stimulsoft.com with subject "RetrieveOnlyUsedData Test"
thanks
2next
Re: Report from collecting Data from DB
Posted: Sat Jul 02, 2016 3:16 am
by Andrew
Thank you, we will reply to you by mail.
Have a nice weekend!