Display all fields even if no data

[sprog]

Hi
I have written a crosstab report which needs to show all types of payments per pay period.

It is working okay, but because I export it to excel and from their copy the info into another report, I need the lines to stay the same.
So how do I get it to print a payment which has no info in it?
eg:
I need all of the following payments to show, but if for instance, no double time was paid, this payment type is dropped out of my return. I need it to remain in there, even if there is no matching data.

Ordinary Hours
Time 1/2
Double Time

Crosstab shows period end dates across the top, Payment types down the left hand side and the number of hours paid in the middle.
Any help much appreciated.
Thanks
Julie

 

[synapsevampire]

You'll need to create data with zero values for those missing.

One method is to create another table which has the following vsalues:

Ordinary Hours
Time 1/2
Double Time

Then select it as my main table,and left outer join itto your data.

-k

 

[sprog]

Thanks very much for your help. However, I don't know how to do "Left Outer Join". I've checked the Crystal Help, and it tells you what the function does, but not how to set it up.

Is it simple enough for you to tell me?

Thanks
Julie

 

[Madawc]

Click on a link from Database Expert. Choose 'Link Options', which lets you choose.

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