Concatenating DataBand Field Data

[ACordero]

Hi,

I'm currently working on a statement template which lists all of the unique invoices sent out (pulled in the DataBand). Is there any way I can put a field into the PageHeaderBand that could pull in all those unique invoice numbers? Right now, it only pulls one invoice number.

Thank you,
Ashley

[HighAley]

Hello.

You could try to use next function:

Code: Select all

{Func.EngineHelper.JoinColumnContent(DatatableName, "ColumnName", ", ")}

Thank you.

[ACordero]

Thank you Aleksey, that worked, however i am getting duplicate invoice numbers. Is there anyway to only get the distinct invoice numbers?

[Alex K.]

Hello,

Please try to add the additional datasource (Data from other DataSource) with grouping by invoice numbers and then show these grouping data.

Thank you.

[ACordero]

That worked, but now I'm encountering another issue. I currently have the GroupHeaderBand1 set to 'New Page Before' = True so that my unique report will generate per customer. Each customer has a unique set of invoice numbers, however, it is showing all of the invoice numbers in that top corner instead of just the ones for that customer. Is there a way to only show the invoice numbers from the customers on that page?

Thanks!

[Alex K.]

Hello,

Can you please send us your report with test data for analysis.

Thank you.

[HighAley]

Hello.

Maybe you could try to use Group Header band instead of the Page Header.
We will be able to help you if you send us your report with sample data to reproduce the issue.

Thank you.

[ACordero]

Aleksey, It looks like my attachments were not posted or removed for some reason? Here they are again. Also, I tried using the group header and it didn't work.

Thanks,

[Alex K.]

Hello,

Please check the modified report in the attachment.

Thank you.

[ACordero]

Thank you for your response. Unfortunately, that invoice # field is showing us as UNDEFINED COMPONENT and I receive the following errors when I try to preview:

Undefined component
Undefined 'Panel1' component is found in the report. The reporting tool cannot identify this component. Maybe this is a custom component. The report cannot be rendered!