Hi, I am trying to get a header Text created for the groups in the cross tab report like below. Customer Invno 12/2013 1/2014 2/2014 Total The text highlighted in bold above comes from cross tab report of we want column totals by month for the two groups Customer and Invoice no. I want to get the header :Customer and Invno on each page. It comes blank for all pages. Some one in another forum suggested the following. Still i am getting the text field on the first page only and not on all pages. Below is what was suggested. Can some one clarify what i am doing wrong. Issue: When designing a cross-tab in Crystal Reports (CR) version 10, by default there is a blank rectangle above the row headings where the column headings are specified. How can you add a text label at the top of the rows in a cross-tab that spans multiple pages? Resolution: To add a text label at the top of the rows in a cross-tab that spans multiple pages you must create a "fake" report header and insert the cross-tab and text label into it. 1. Create a formula for an empty group: WhileReadingRecords; "" 2. Insert a group based on this formula. This will be used instead of the report header and must be the only group for the entire report or your label will not be aligned properly. 3. Add the text object that you wish to display as your label for the cross-tab to the group header. 4. Right-click the text object, then click 'Format Text'. 5. On the Common tab, click 'Repeat On Horizontal Pages'. 6. On the 'Report' menu, click 'Section Expert'. 7. Click Group Header 1 and then click 'Underlay following sections'. 8. Place the cross-tab in the group header and adjust the alignment of the text object as needed to display your label in the correct place. I am on ver 12 with crystal reports. Hem reddy
|