• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 312
  • Last Modified:

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,

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

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

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

  • 2
1 Solution
v_arshiniAuthor Commented:
Using Crystal Reports 8.5 How can I get Multiple Column Format
in Standard Report Expert
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

Don't know if it helped.  

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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now