Report from collecting Data from DB

[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

[Alex K.]

Hello,

Thank you for the sent sample. We need some time for check the issue.

[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.

[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.

[info@2next.it]

Thank you very much!

[Alex K.]

Hello

We are always glad to help you!

Thank you.

[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 3353 times

Set the option:

2.png (82.39 KiB) Viewed 3353 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 3353 times

Property wrong:

4.png (17.26 KiB) Viewed 3353 times

VERSION:

5.png (35.6 KiB) Viewed 3353 times

thanks
2NEXT STAFF

[Alex K.]

Hello,

Can you please send us a simple report with test data which reproduces the issue for analysis.

Thank you.

[info@2next.it]

Hello,
I send this example to support@stimulsoft.com with subject "RetrieveOnlyUsedData Test"

thanks
2next

[Andrew]

Thank you, we will reply to you by mail.

Have a nice weekend!