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

Cross-tab report needs TopN on columns

A user has presented me with an unusual request that I have not been able to find a solution for yet. I'm hoping one of you knows what it could be.

We are using Crystal Reports 2008.

I've recreated the issue using the eFashion database.

I can display the information he wants to see, if the cross-tab report contains the following values:

Rows = Outlet_Lookup.City

Columns = Article_Lookup.Article_Label

Summarized Fields = Sum_of_Shop_Facts.Quantity_Sold

The problem is he wants to see the TopN on the Columns...not the Rows. I have no problem creating a TopN on the Rows, but I can't seem to make it work on the Columns. I've switched the values on the Rows and Columns and then used the Pivot function to try to swap them, but it swaps everything else back, as well.

Does anyone know how to make this work? I'm stumped.

Thanks in advance for your help.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 24, 2010 at 06:58 PM

    hi Paula,

    this is unfortunately the limitation of cross-tabs. the group sort is vertical (on the rows only) and not horizontal.

    however, if you need to get this style of report, i have attached a sample "dynamic mock cross-tab" report that allows the sorting on the columns.

    the way it works:

    1) all product values are displayed in a subreport...this is overlayed onto the rest of the report below

    2) there is a group on the customer name

    3) the report is formatted in a Multi-Column format...therefore each group is a column

    4) a subreport runs for each customer and keeps track of which products they bought

    5) the above product purchase info is passed on to a second subreport which displays the info

    the reason why 4) & 5) are done is because customers do not purchase all products. we need to ensure that there is a line for each product regardless of what the customer purchased. this then emulates a cross-tab.

    this report has the columns sorted by sales, descending.

    this is a bit of work but if this style of report is a requirement, then this will do the job. sorry i don't have any instructions on how to recreate the report but there are some comments on the report that should help.


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Jamie Wiseman

      Hi Jamie,

      I saw the thread of discussion. Could you please help to send me the sample report of Cross-tab report needs TopN on columns (dynamic multi-column report).

      Please do the needful.

      Thanks & Regards,

      Rajesh Gudla

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.