Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Showing multiple records in Report Header

Status
Not open for further replies.

mwake

Programmer
Feb 12, 2004
151
US
I'm using Crystal Reports 2008 and my data source is an Oracle 11 db. I have a product family table with unique id's(1,2,3,4, etc), which links to a product table. There can be multiple products within each product family. So lets assume there are 2 products in Product Family 1. If you drop the product_name field into the details section, 2 product names appear. If you drag the same field into the Report Header section, only the first product appears. How do I get both products to appear in the report header section??
 
You could add a crosstab to the report header where you add the product name as the row or column field and then add it again as the summary (maximum), and then suppress either the label field or the summary field and remove the grid.

Alternatively, you could add a subreport to the report header that uses the name field in the detail field or which groups on the name field.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top