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

Custom header in crosstab

Status
Not open for further replies.

DeltaMira

Technical User
May 3, 2004
13
0
0
BG
Anyone know how can I put repeating text for the rows' headers?

Here is what I want to get from it but I cannot figure out how to put the text fields to appear on each row


01/01/2007
----------------------------------------------------------
[Product] - custom text "Stock" | 125
- custom text "Sales" | 100
- custom text "Production" | 1000
---------------------------------------------------------

[Totals] - custom text "Stock" | 125
- custom text "Sales" | 100
- custom text "Production" | 1000
 
Depends upon your version. If you have CR XI, you can go to the customize style tab->summarized fields->show labels.

-LB
 
nope, lbass.. I dont have such option. In the earlier versions its not possible?
 
In the future, please identify your version--you should ALWAYS provide that. Anyway, create a formula:

whilereadingrecords;
"Stock"+chr(13)+"Sales"+chr(13)+"Production"

Add this as your second row field in the crosstab, and adjust the width until it displays correctly.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top