Concatenating DataBand Field Data

Stimulsoft Reports.NET discussion
ACordero
Posts: 25
Joined: Mon Sep 20, 2010 1:03 pm
Location: Valencia, CA

Concatenating DataBand Field Data

Post by 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
Attachments
invoice2.png
invoice2.png (122.1 KiB) Viewed 3920 times
invoice1.png
invoice1.png (94.6 KiB) Viewed 3920 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Concatenating DataBand Field Data

Post by HighAley »

Hello.

You could try to use next function:

Code: Select all

{Func.EngineHelper.JoinColumnContent(DatatableName, "ColumnName", ", ")}
Thank you.
ACordero
Posts: 25
Joined: Mon Sep 20, 2010 1:03 pm
Location: Valencia, CA

Re: Concatenating DataBand Field Data

Post by 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.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Concatenating DataBand Field Data

Post by 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
Posts: 25
Joined: Mon Sep 20, 2010 1:03 pm
Location: Valencia, CA

Re: Concatenating DataBand Field Data

Post by 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.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Concatenating DataBand Field Data

Post by Alex K. »

Hello,

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

Thank you.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Concatenating DataBand Field Data

Post by 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
Posts: 25
Joined: Mon Sep 20, 2010 1:03 pm
Location: Valencia, CA

Re: Concatenating DataBand Field Data

Post by 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,
Attachments
StimulsoftExport.mrt
(46.66 KiB) Downloaded 271 times
11-18-2013 7-20-56 AM.png
11-18-2013 7-20-56 AM.png (27.88 KiB) Viewed 3869 times
LMA-11-18-2013 7-21-45 AM.xml
(405.69 KiB) Downloaded 290 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Concatenating DataBand Field Data

Post by Alex K. »

Hello,

Please check the modified report in the attachment.

Thank you.
Attachments
StimulsoftExport2.mrt
(48.92 KiB) Downloaded 300 times
ACordero
Posts: 25
Joined: Mon Sep 20, 2010 1:03 pm
Location: Valencia, CA

Re: Concatenating DataBand Field Data

Post by 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!
Post Reply