Crystal Reports 8.5

Hi experts ,
1,tablename is Invoice
 this have field InvoiceID,Name,Type,Date
2,tableName is InvoiceDetails
this have field InvoiceID,
ProductID,Name,UnitPrice

My report should display
Product Details :Name  Unit Price in the same line.
I used Multiple Column Format using Mailing Label expert. How can I do the same using Standard report expert

Say
TableInvoice Contains
IncoiceID   Name      Type    Date
1               Products  xxx      23/11/2003
2                 Articles   xxx     23/11/2003

InvoiceDetails
Invoice ID   ProdcutID   ProductName UnitPrice
1               1                Beverages      $569
1               2                Contiments    $5889
1               3                Fruits             $52


My Print Out should look like
InvoiceID  : 1 (Invoice.InvoiceID)

Product:    1 Beverages,2 Contiments,3 Fruits

All these are should be the same line
How can I do it in Standard Exper format




v_arshiniAsked:
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.

v_arshiniAuthor Commented:
Using Crystal Reports 8.5 How can I get Multiple Column Format
in Standard Report Expert
0
mlmccCommented:
I don't think you can use Multiple Columns with the standad expert however you can setup the report then format the detail section with multiple columns.

An idea
1.  Group on the invoice id
     Put the details into the group footer.  Build a formula with each record by concatenating the informationinto a single line

The detail section is for use by a single record.  Therefore to do what you want you need to somehow group the records together

mlmcc
0

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
mlmccCommented:
Don't know if it helped.  

mlmcc
0
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
Programming

From novice to tech pro — start learning today.