Crystal Report - Restrict Number of Columns in CrossTab

Posted on 2006-06-01
Medium Priority
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

harisrashid earned 300 total points
ID: 16831367

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 101

Expert Comment

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


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

571 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