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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sr101880Commented:
What are you using for a data source?  Is there data fields in the detail section?
yamihoAuthor Commented:
I'm using ODBC and I do have all the fields in the detail section.
sr101880Commented:
What are the tables and relations in the report?  
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

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
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.
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?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.