Crystal Report - Restrict Number of Columns in CrossTab

Posted on 2006-06-01
Last Modified: 2008-01-09
I am making a CrossTab Report using Crystal Report 11.
The problem starts when data increases in CrossTab report.
It works fine when number of rows increase but don't work fine when number of columns grow. I want to restrict number of colums in my report( Currently it is dynamically growing with the data).

Question by:tahir_666
    LVL 10

    Accepted Solution


    you need to restructure your query to return a restricted number of columns. or create a table instead of cross tab.

    In situations where the columns increase it is more useful to use matrix report with drill down. By having drill down user can click on aggregated columns to expand the column list. (this is possible if you have data structured to support drill down and hierarchies).


    LVL 100

    Expert Comment

    I don't think you can change/control the number of columns except by restricting the data as suggested above.


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now