How can I add fields to display data at the end of Crosstab

[Former Member]

I am using the Crosstab in my crystal report to display the data for the selected Date Range Parameters Values. I have placed the Date field in the Column portion of the Crosstab and person name in the rows portions and revenue in the summarized fields portion. Based on the Date range selected the Crosstab dynamically spans horizontally into multiple pages. Till here its fine.

Now I need to another 3 fields(Remarks, Aircode, Facility) to be added after the last date of the Crosstab Data.

Means at the end after the crosstab has shown the data for all the dates, then I need to add 3 other fields. I have added these fields in the Rows portion of the crosstab, but they will be shown on the left side not at the end.

I need like this

Person     1/1/08   1/2/08    1/3/08   Remarks   Aircode Facility
Jack        1000    2000      3000     abcderf      SCG   data1
Ram	    5000    4500      2600     dfndslf       ANG   data2

Can anyone please help me.

Appreciated & Thanks in advance

-Kumar

[Former Member · Accepted solution]

Try creating three formulas like

@Remarks--> remarks database field

@AirCode--> aircode database field

@Facility-->facility data base field

Place all the three in summary and select Maximum in summary option. Move them up using up arrow in summary to change the position in crosstab.

Regards,

Raghavendra

[Former Member]

If you're always going to have Remarks, Aircode, and Facility (static) why not add another simple crosstab to the left of the original crosstab then have your original crosstab (depending on date range) grow to the right.

Otherwise you'll have the original crosstab growing over your Remarks, Aircode, and Facility.

Only other option would be a mock crosstab but that would require a static number of columns (periods of time in your case) and I don't think that'd be an option in your case as you seem to have a different time span each time you run the report.