Solved

FORMATTING CROSS TAB REPORT

Posted on 2013-01-28
7
418 Views
Last Modified: 2013-02-01
Hello,
I have a cross tab report.Please find attached the desin view of the cross tab.
I need to suppress the circled colums and display the report.
How can it be done.
Thanks for the ideas.
scrnshot.jpg.bmp
0
Comment
Question by:Star79
  • 4
  • 3
7 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 38829526
What version of Crystal?

mlmcc
0
 

Author Comment

by:Star79
ID: 38831084
Crystal version is 11.Thanks.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 38833722
Why do you need the row if you just want to suppress it?
You can make the rows very short and set it not grow.  You can set the fonts to the background color or use the display string to always display ""

mlmcc
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:Star79
ID: 38835788
Hello mlmcc,
Please find attached the current report.They need me to display only the summarized data row(bolded-direct charges and housestock rows) and suppress the other patient rows.
Can it be done on the cross tab.
Thanks.
screenshot.gif
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 38837930
I assume the bold rows are groups.

Build the cross tab without the detail lines.

The other way to do this would be a separate report that just shows the group headers or footers with the summarized values.

mlmcc
0
 

Author Comment

by:Star79
ID: 38839794
Hello mlmcc,
The bold rows are the summary of the groups.As Iam new to building crosstab reports can you please provide me detailed instructions on how to do it.
Thanks and appreciate.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 38842312
Just don't put the detail line in the cross tab.

mlmcc
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
How to increase the row limit in Jasper Server.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

746 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

17 Experts available now in Live!

Get 1:1 Help Now