Hi All,
I have created a report with 2 to 3 lists in a single page and included page break based on one grouping column. My requirement is to deliver the report in Excel, so everytime i will test the report in Excel. 2 to 3 list is from single query and this query includes 2 query subjects (joins defined between them). Everytime i ran the report after including a column from second query subject i got a blank report. And i got a error message like below.
Then i browsed some resolution, i found the below links.
1) http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos-reportnet-l/excel-file-generation-in-cognos-sdk-1476584
2) http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos-reportnet-l/displaying-excel-report-1252168#
Then i found the issue is because of the second query subject, which has no matching rows with the first. I modified the join in FM to outer join between the 2 QS and tested the report. I can able to see the report now.
Thanks,
Soma
