Display blank line if there is no data

[rhmb]

Hello

I am writing a crystal report to show manufacturing times based on machine numbers.
I would export this into an excel spreadsheet that is already existing that does some more calculations, so it needs to look the same each time.
However, if for example there has been no manufacture on a certain machine then the machine does not show up on the report at all.
I would like it to display the machine numbers even if there is no data available for that machine. Is that possible?
eg:
Machine Time
line 1 10
line 2 15
line 3 24
line 5 19

Machine Time
line 1 10
line 2 15
line 3 24
line 4 0 (I dont mind if it is a 0 or is just blank)
line 5 19

 

[Madawc]

Depends on your data. If you had a table for 'machine' and another for 'time', then group the data by 'machine' and do a left-outer link to 'Time'.

Note that this won't work if you also test for 'Time', unless you do an IsNull test first.

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. In this case, it probably makes no difference.


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