troubleshooting Question

Crystal Report - Cross Tab problem

Avatar of RichardH1976
RichardH1976 asked on
Crystal Reports
2 Comments1 Solution445 ViewsLast Modified:
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
Kurt Reinhardt
Sr. Business Intelligence Consultant/Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros