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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

4 Different Headers - 1 Report

Status
Not open for further replies.

Toshilap

Technical User
Sep 28, 2005
135
US
Report have to have few pages where every page is a new set of data from the same table (source).
Every page has it's own header.

Page1. (Data source 'Table_Orders')
Header: SUBS Orders
Contains data like Select * where orders are 'SUBS'



Page2. (Data source 'Table_Orders')
Header: INVS Orders
Contains data like Select * where orders are 'INVS'

4 pages with different headers and dataset from the same table. Is this possible?
 
Hi,
One way:
Create a Group on Orders..
Set the GH to 'New Page Before'
Place the Text in the Group Header( or use a formula to create a custom Group name) and suppress the Page header...



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
OK, now I have GH txtbox - 'SUBS Orders'
and data fields all in GH?

How is it going to change to 'INVS Orders'?

I forgot to tell that 'SUBS Orders' and ' INVS Orders' are simply Data Entry Names I am typing into text boxes. It doesn't have any association with table fields.

So I am having 4 text boxes with different Header Names manually entered. Seems like I need 4 Groups but each has to start after previous ended.

Is it too confusing?
Imagine 4 pages with 4 different headers.
Data on those pages are from the same table in a different way. Thanks
 
Hi,
Create the Group on the {table_orders.orders} field ( that changes from
INVS to SUBS, etc based on the record returned, if I understand your selection criteria..)
By Grouping this way you do not need separate selection criteria..Just return the records and let Crystal sort them into the categories.

Use the Formula editor in the Change Group area to create a name by Concatenating the field's content with the text, like:

UpperCase({table_orders.orders}+ ' Orders'

This will change dynamically based on the value in the {table_orders.orders} field.
SUBS Orders
INV Orders
etc..





[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top