Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 10:42 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 08:59 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.