[b]0 Value Groups not showing despite Left Join [/b]

[Nassy]

Hi,

I have a table called Applicant Details where each row contains the ID of each Applicant, their Name, the Office the Applicant registered in and the Price Band the Applicant is looking for a property in (0-15000k, 151000-300000k,301000-500000k) eg:

1 Sarah Macauley 0 - 150000k Alton
2 June Smith 151000k- 300000k Farnham
3 Olivier Perrin 0 - 150000k Alton
4 Terry Williams 301000k - 500000k Guildford
5 Marco Smith 0 - 150000k Farnham

I then created a simple summary report in Crystal showing the numbers of Applicants in each Price Band for each Office.

[blue]What I am trying to achieve:[/blue]

I want to show a 0 count against Office/PriceBand groups even when there are no Applicants for that group. For example in the example data displayed above there are no Alton Applicants looking for Properties worth between 301000k - 500000k but instead of Crystal completely omitting this information from the report I would like to see a count of 0 there instead.

How I have tried to achieve this [COLOR=green yellow](but to no avail)[/color]

In order to get Crystal to show 0 values I have done the following:

[ul]
[li]Created a Table Price Ranges with all the Price
Range and Office combos
[/li]
[/ul] eg
0 - 150000k Alton
151000k - 300000k Alton
301000k - 500000k Alton
0 - 150000k Farnham
151000k - 300000k Farnham etc etc
[ul]
[li]Using the Data Expert done a Left Join between
Applicant Details and Price Ranges joining the two
tables by Price Range and Office
[/li]
[/ul]
[blue]What the problem is:[/blue]

I have been tearing my hair out because implementing the Left Join does not seem to make one iota of difference and I don't see why. I realise I must be doing something stupid but can't think what.

Any help would be very much appreciated at this stage as this time Crystal has me well and truly beaten.

Nassy

 

[Nassy]

It's okay - I fixed this issue - just me being an idiot.
In my report I had got the tables mixed up !! I have sorted out the linking and it now works fine. I am so annoyed with myself!