0 Values in Database

[zusulik]

Hello everyone,

For automation purposes I need to make sure that exactly 6 rows appear in one CR report. For exmaple:

0 - Not Set 45
1 - Immediate 3
2 - Next 23
3 - Ship 18
4 - Time 92
5 - Unassigned 17

(where the first field is a group header and the second field is a sumary field)

Now, sometimes I will have a situation where '1-Immediate' will have zero entries (i.e. it will not be present in the initial query output). This causes CR to not dispay this group alltogather, and I get:


0 - Not Set 45
2 - Next 23
3 - Ship 18
4 - Time 92
5 - Unassigned 17

So, is there a way to make sure that all group names will show up?

Thank you

[jggtz]

You don't say the type of data source neither tables & field names ...
but the answer is to define a 'LEFT OUTER JOIN' from the detail data table ON the description table

[zusulik]

Yes, sorry about being unclear.

The source is an .XLS data file and there is no actual SQL query being sent (I don't know why I reffered to it in the first post).

I was wondering if it is possible to give CR a list of group names and make sure it prints them all every time?