Solved

How do you suppress info from cross-tab?

Posted on 2007-12-06
10
1,884 Views
Last Modified: 2008-02-01
I have a cross-tab with a row for qty sold by plant, a sub-row for qty sold by tax code and colunms for years.  I need to suppress rows with qty <50,000.  As this is a summary of the qty field, how do I do this in a cross-tab?  The report is for an important operations meeting tomorrow morning.
0
Comment
Question by:Tlair
  • 5
  • 4
10 Comments
 
LVL 17

Expert Comment

by:MIKE
Comment Utility
I don't believe you can suppress by ROW using a crosstab.

You may be able to create a MANUAL CROSSTAB....and suppress using normal sections in Crystal.

MikeV
0
 

Author Comment

by:Tlair
Comment Utility
So, under "New Formula" for the Summarized Fields section, there's no way to write a formula for a sum of qty is <50000 that would, in essence, suppress all data in a row if the total is not >50000?
0
 
LVL 17

Expert Comment

by:MIKE
Comment Utility
Not that I'm  aware of ...maybe some of the other experts will chime in on it,...but again,...as far as I know.... you cannot do this in the CROSSTAB itself......I've accomplished this by creating a MANUAL CROSSTAB..which is basically building a report..that will LOOK AND ACT like a crosstab...but you will have more flexibility regarding these types of fromatting issues. Crosstabs in most software programs (including Crystal) are somewhat limited because they are basically designed to display SUMMARY data quickly.

But if you are wanting to create advanced customization....then you'll have to revert back to the MAIN Report and build/format there..

MIkeV
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 100 total points
Comment Utility
Can you do the filter through the select expert or write a new report that filters out the data you don't want and use it as a subreport?

mlmcc
0
 

Author Comment

by:Tlair
Comment Utility
The select expert doesn't work for the field needing the filter.  It works for the sum of qty for customers, but not the sum of qty by location (which is a subtotal).

I have sum of qty for (in incremental order):
1) customer
2) tax code
3) plant
4) grand summary in the footer

It is item #2 above that needs to be filtered out if <50000 in the cross-tab.
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

 
LVL 17

Expert Comment

by:MIKE
Comment Utility
You may also be able to create a SQL Function..that can be used to limit your crosstab....but thinking about mlmcc's comment...you may be able to create the function...then...use the function in the SELECT EXPERT....

I think....
MikeV
0
 

Author Comment

by:Tlair
Comment Utility
Creating SQL functions isn't an option in CR8.5, is it?  I'll either need to contact my IS dept for a query designer program or wait a month of two until we upgrade to CR10 or XI.  

As for using the function in the select expert, that'll affect the main report.  I would need to separate the cross-tab into its own report to achieve my filter.

Thanks for the assistance.
0
 
LVL 17

Accepted Solution

by:
MIKE earned 400 total points
Comment Utility
Wait for upgrade to XI......you'll love it.

You may be correct about the select expert...but again...you may be able to create the function so that it will only add an IDENTIFIER....."TEXT" to the data row....basically stating that this row is in a group that will EXCEED   $50,000. Then use that TEXT ID...to suppress it from your reporting...

Just thinking out load here.....probably more than one way to accomplish your goal...

MIkeV
0
 

Author Comment

by:Tlair
Comment Utility
I created a text field for an identifier.  The select expert doesn't allow a filter on this field, either.  Is that what you meant?
0
 

Author Comment

by:Tlair
Comment Utility
I'll wait for the upgrade to complete this task.  Thanks.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

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. …
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

728 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

11 Experts available now in Live!

Get 1:1 Help Now