Displaying all data in grouping

[ccnetwork]

Hello

I have a report which is grouped by officer and development type. Everything displays correctly, except if there are no development type against an officer, the development type does not display. For example using the below database information the only development type that would display for Off_Code 'CK' would be test5.

Table1:

Ref_ID Type Off_Code
1 1 AB
2 1 AB
3 4 AB
4 5 CK


Table2: The ID field in the below table is linked to the Type field in the above table.

ID Description
1 Test1
2 Test2
3 Test3
4 Test4
5 Test5
6 Test6


I want to display the following information on my report:

AB

Test1 2
Test2 0
Test3 0
Test4 1
Test5 0
Test6 0



CK

Test1 0
Test2 0
Test3 0
Test4 0
Test5 1
Test6 0


Thanks

 

[Madawc]

How are your records linked? If it is a standard (equal) join, then you get nothing when a table 1 record has no table 2 records. If you do a Left Outer link, then all table 1 records will be shown. (But only if you're not doing a selection for table 2).

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

I think there are two options. First, you could insert a crosstab in the report header or footer that uses test as the row field and Off_Code as the column. As long as the off_code had at least one test, and as long as all tests were represented at least one in the data, you would get the desired results, although in a horizontal display.

Otherwise, you could use running totals in the group footer for off_code, one for each test type, where you specify the testtype in the evaluate using a formula area. Reset on change of Off_code group. You would have to use text boxes to label the results.

-LB