Trouble displaying Data

[janchan]

I have a STATE table which has 7 states. My main ACCOUNTING table joins to the STATE table to get the state name. I group by the STATE field in the ACCOUNTING table so that i have a report for each STATE on different pages. I display the name of the state in the page header so that the user knows which STATE's report they are viewing. The problem is, when there is no data in the report, The STATE does not display anything. It is a NULL. I know this is how it would work, but i want to know if there is a way that i can still display the STATE name even though there are no records in the report.

I tried Left JOIN but still does not work.

The only way i found out was to use a SubReport for the Details and the Main Report will have the Header alone.

We have already completed around 200 reports after which the team wants to change the requirements. It is very tedious to change the reports to have sub-reports right now as we are going live very soon.

Any help would be appreciated. Thanks.

 

[synapsevampire]

You might use the State table as the main table and left outer join to the other table providing that you don't put any filtering criteria on the other table.

-k

 

[janchan]

I do have a lot of record selection from the ACCOUNTING table. this is the reason why there is a chance that there are no records. Is there a way if there is filteration? thanks.