on 01-13-2015 9:45 PM
Currently using Crystal Reports 9 and I have a dynamic cross tab that serves as a checklist.
For example - The cells are a count of the column field.
User | Test1 | Test2 | Test3 | Test4 | Field to be removed |
---|---|---|---|---|---|
User1 | 0 | 1 | 1 | 1 | 1 |
User2 | 1 | 0 | 0 | 1 | 1 |
User3 | 0 | 0 | 0 | 0 | 1 |
My issue here is that I need to remove the last field but keep the user on the list. If I do a selection filter or a group filter that filters out the last field, User3 will be eliminated because it will have no records of field Test1-4.
Any ideas?
Hi Antonio,
You can suppress columns using GridValue functions, however I don't think GridValue functions (available in CR 2008 or higher) work in CR 9.
If you wish to see all Rows, you should consider creating a 'look-up' table that has all values you see in the Crosstab's rows and Left Join this table to the existing table so there aren't any 'gaps' in data.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Antonio, if you wish to see how the GridValue function works, consider downloading SAP Crystal Reports 2013 eval from here:
http://www.sap.com/solutions/sapbusinessobjects/sme/freetrials/index.epx
CR 9 and CR 2013 are side by side compatible.
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow us on Twitter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.