on 11-27-2014 10:17 AM
Hi Experts,
I have create a crystal report on only one table. I have grouped one column and tried to run with prompt. Now I'm I'm unable to get the empty group names, something which is exactly like this which I have got from .
Groups only exist is there are details for the groups
lets say your groups are
A,B,C,D
and your data is
A,123
A,3456
B,555
D,2345
D,93484
then there is no Group C
so you are looking for
A
123
3456
B
555
C
<blank>
D
2345
93484
I've tried and failed to develop the report with the solution given in the above thread. Could someone help me in working in this issue.?
Thank a lot in advance...
Samrat Muddasani
Hi Samrat,
CR does not group on missing data, unfortunately.
Here's a workaround:
1) Create a look-up table in the database that has all the column values (A, B, C, D)
2) If you don't have access to the database to create tables, you can also create a lookup table in Excel and join it in the report to the existing table however, such a configuration will significantly slow down the report.
3) With a Lookup table that contains a column with all the values, you can Join it to the existing table (Left Outer Join) on the same column.
Now, in the report, wherever you use the column that has values A, B, D from the existing table change it to use the field from the Lookup table. This includes Groups, Record Selection formula etc.
A Left Join makes sure that all records are received by the report.
Another workaround is in the post here
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
9 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.