Crystal Report - Cross Tab problem

RichardH1976
RichardH1976 used Ask the Experts™
on
I am working on a crystal report showing sales numbers using a cross tab style.   The rows have gone in fine with a summary.  I am starting to the add the columns which I want grouping from a catagory in another table which is linked correctly (I hope).   I have used the following formula to see find the catgorie I require in the column
Mid ({SL014000.SL01017}, 22,2 ) = "01"  but when the report runs I get a true value and a fasle value.   The true value looks correct but my question is how do I get rid of the false colum.
Any help appreciated. Richard
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Sr. Business Intelligence Consultant/Architect
Commented:
The problem with your formula is that it's a boolean.  It's returning true when the mid = 01 and false when it doesn't.  If you simply want to take the value returned by the mid, change the formula to: Mid ({SL014000.SL01017}, 22,2 ) .  If you want to filter the overall data seen by the crosstab so it only pulls the "01" values, even though there are other values, then you'll need to do one of the following:

1)  Filter your main report so it only returns "01" data in the first place.
2)  Group by the mid value and put a crosstab in at the group level
3)  Move the crosstab into a subreport where it has it's own filters against "01" data even though the report has multiple mid values
4)  Create a manual crosstab based on formula fields

~Kurt

Author

Commented:
Move the crosstab into a subreport where it has it's own filters against "01" data even though the report has multiple mid values

This worked... thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial