Subreport showing data in designer but not in BOE

building reports crystal reports
1

Hi,

I have two subreports in a main report and they both show the data fine when run in designer (Crystal 2008). But when i exported the same report to BOE and ran it from there, one of the sub reports is not showing data.

I tried to open the same report that is in BO using crystal 2008 again and both the subreport shows data again. Not sure what the problem is but it is really wierd. Any suggestions?

Thanks

bobiuser (BOB member since 2012-07-16)

2

Almost sounds like a DB issue. Have you confirmed that the data source on BOE is the same as your local data source (not just the same name, but pointing to the same place)?

kevlray :us: (BOB member since 2010-06-23)

3

Yes both datasources are the same. All the subreports are pointed to same data source but one of them is not showing any data while run from BOE.

bobiuser (BOB member since 2012-07-16)

4

OK I am able to resolve this issue. Apparently the generic id used in BO does not have access to the tables used in the sub report where as the id that I was using in the designer has access to those. Interestingly, it did not throw any error.

We are using SAP tables for this report. Thanks for all the responses.

bobiuser (BOB member since 2012-07-16)