About Crystal Reports 8.5

Hi Guys,

I'm in the midst of designing an Invoice Report. I've a requirement to display all the PO No. in the Group Header Section, but PO No's is in the Detail Section.

Eg: PO00123, PO09123, PO89745

I needs to display by comma seperated string. Is there any way to manipulate any detail column and concatenate along with the comma and display in the Group Header Section. I tried my level best to do this, but couldn't succeed.

Please help me.

Regards
YamihO
LVL 1
yamihoAsked:
Who is Participating?
 
Shay79Commented:
Yamiho

There is a way to do this using Crystal variables, but it will only show all the Po numbers in the Group Footer, and they would concatenated at run time. Would this help?
0
 
sr101880Commented:
What are you using for a data source?  Is there data fields in the detail section?
0
 
yamihoAuthor Commented:
I'm using ODBC and I do have all the fields in the detail section.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
sr101880Commented:
What are the tables and relations in the report?  
0
 
yamihoAuthor Commented:
I have the following tables:

InvoiceHeader
InvoiceDetail
DeliveryOrderHeader
DeliveryOrderDetail

In Delivery Order Header table i've a column called "PONo", that's where I need to manipulate. A single invoice can have multiple Delivery Order Headers, so that's what the customer is expecting, i mean to have comma seperated PO No.

Pls. Help.

Regards
0
 
sr101880Commented:
Sorry I haven't gotten back to you sooner.  I have been away from my office for the past couple of weeks.  I am working on your problem and will get back to you shortly.
0
 
yamihoAuthor Commented:
I've used shared variable and put in the group detail, so that it loops up and I concatenate on every loop and show at the report/group footer.

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.