Concatenating DataBand Field Data

[Alex K.]

Hello,

We created report in last version in which was some changes with panel component.
Please check the modified in your version report in the attachment.

Thank you.

[ACordero]

That worked! Can you please tell me what the relation is that you setup? I can't access the settings to it to see how you set it up.

Thanks!

[Alex K.]

Hello,

We create a master-detail construction, in this case the JoinColumnContent function calculate result for each detail (grouping) dataset.
- in datasource Invoice add the additional column Customer_Number
- add relation between QueryResults and Invoice tables
- place additional Panel with Band components on Header
- set MasterComponent and DataRelation property for band

Thank you.

[ACordero]

This worked; thank you. I'm running into another issue with getting the data to display in a different format.

My initial databand is showing me all of the debit amounts (charges to the customer) and i'm trying to get my credit amount field to display underneath it. I tried adding another databand directly underneath the existing one and putting my credit field in there, but it's duplicating the data. I then attempted to create a master databand, and setup some relations for it to group by the customer number, but that too isn't working. Can you please assist me with this? I want the debits in the first databand, and my credits for that same customer in the next databand. Attached is the revised MRT file, you can use the same XML data as before if needed.


Thank you

[Alex K.]

Hello

Can you please check the sent data. In datasource Credits you uses the "Invoice General Ledger Transaction Unique Row ID" column, but in xml it is empty.
Also please send us a sample or screenshot how it should look like.

Thank you.

[ACordero]

Sorry, I forgot about the added field! Attached is the updated XML and below is a screenshot of what we're trying to attain. You can see that it has the billed items first (Invoice Transaction Gross Amount) and then underneath them is the payment received (Invoice General Ledger Transaction Credit Amount).

[Alex K.]

Hello,

In this case you can use the DataBand component instead GroupHeader band.
- add the additional data source - CustomerNumber and place it instead Group band.
- for QueryResults and Credits bands set the MasterComponent property to CustomerNumber band.

Please check the modified report in the attachment.

Thank you.

[ACordero]

I noticed that the Undefined Component has resurfaced in that Invoice # section, but it does not work in my version (v4.0.30319). Do we need to upgrade our version in order to get this report to work? Also, the footer is no longer appearing, even after I added in an empty groupheader band.

Thank you

[HighAley]

Hello.

Here is a report template for your version.

StimulsoftExport112113_modified2.mrt

(46.83 KiB) Downloaded 328 times

Thank you.

[Alex K.]

Hello,

Sorry for the mistake. Please place the Footer component instead GroupHeader.

Thank you.