Data Grouping Inquiry

[Skexxies]

I have a report that currently groups data in a databand.
Within this databand, I need a new field that ammalgamates any unique value found in a sub-databand, grouped still by the parent databand. But the requirement is to not print each unique element on its own row, but a single row comma separated.

So, for a given DocketItem (docketitemid 1128)
I have 3 Units (UnitLoadUniqueNumber 48156, 46698, and 46699)
In this case, for each UnitLoadUniqueNumber the value of UnitTransactionJobNumber is 1238 for all 3.

So for my DocketItem Databand, I need a row that prints: 1238
without duplicating any of the data.

IF any of those UnitLoadUniqueNumber's had a different value, (say 1288 for example), then that row in my DocketItem databand should print 1238, 1288

I also need to not inject a bunch of extraneous empty space, as it will inflate the resulting PDF and cause extra pages of the Docket to print, when not necessary.

I've attached my MRT,

Docket_UNITLOADTEST.mrt

(1.1 MiB) Downloaded 119 times

my XSD,

Docket_UNITLOADTEST.xsd

(13.78 KiB) Downloaded 123 times

and a sample data output that our document generator service sends to Stimulsoft.

PreviewData_Docket_UNITLOADTEST.xml

(32.41 KiB) Downloaded 113 times

MOST of the template is working fine, I just need this new data element to function properly.

Currently I have attempted implementing a subReport, which I can get to print only the unique UnitTransactionJobNumbers, but it's doing so with a new row for each unique number, and also injects all that extraneous white space, which I've yet been unsuccessful in removing.

Any guidance or assistance would be most appreciated.

Thank you.

[Lech Kulikowski]

Hello,

Try to use the Cross-Data bands.

Thank you.

[Skexxies]

Hello,

Try to use the Cross-Data bands.

Thank you.

Hi and Thanks,

I did find the Cross-Data band element, but maybe I'm just too slow to figure out how to implement them right. When I tried to put that into my higher-level databand it forced the height of the cross-data band to the the full length of the page. I regularly have issues with additional data elements causing reports to bloat with white space, and haven't ever seemed to figure out how to prevent that from happening.

Do you have a screenshot or steps on how I would implement a Cross-Data band without that happening?

[Skexxies]

Just to update this, and thank you to anyone who read this and attempted to assist me.

I was able to progress and get cross data and gross group headers to get all the data to print in line, not add extraneous white space between my group and data bands, and successfully hide duplicate values.

What I am trouble by is, if the number of unique values for a given docketItem exceeds the width of the area defined for the subreport, the additional items are printed on a "sub report page 2", outside of the contained databand on the first page of the docket. I have set the field to "wrap text" and "can grow" all true, but still if there are too many unique values, it keeps printing the additional ones on a new page.

Any tips on how I might get extra values within the cross Group Header element to wrap to a second line?

[Lech Kulikowski]

Hello,

Please check the sample report.

Thank you.