when you join the main to the sub it looks for the value to link to, if your main report is blank your sub will be as well.

The main report pulls in the corporate company along with issues attached to the corp company.  The sub report pulls in child companies (Company.parent_company_Id = company.company_Id) for example.

* IF the main report which is keyed off the company does not contain any issues, it will not return the sub report, even though issues do exist at the sub report level...

I have tried passing the company_ID, acronym (Which is a text based field).  I have tried every combination of joins for company.company_id = issue.company_id) but nothing seems to jive.

If the main report does infact contain issues for the parent "main report" then the subreport will pull.  Very confused...Any ideas?


Edited by DWT78 - 10 Nov 2008 at 10:45am

Hi Sharona,

Thanks for your suggestions.

I did not have the null values checked in v10.  I checked both options:
- Convert Database NULL values to default
- Convert other NULL values to default

I checkmarked both options, re-ran the report, but it only scrambled the data further, adding empty Support Tickets to the the Issue level.

I removed the check for "Convert Database NULL values to default" keeping "Convert other NULL values to default" and the report seems to be back to square1 where report still doesn't show subreports openm issue data when main report (Corp Company) is void of open Issues.

I am using left outer joins on all relationships, but for my amusement, I have tried all the joins

I am starting to wonder if Crystal doesn't like joining a table onto itself, but I don't see any logic as to why it would have difficulties with this.  Very puzzled..


Edited by DWT78 - 11 Nov 2008 at 12:32pm