Every time I add a sub-report to a report, do the linking, etc all works fine as long as I execute the report in CR XI Designer. However when I execute report using the embedded CR viewer I am prompted for an extra parameter which is the linking field between main report and sub-report.  

 

To add to the mess, once this happens I go to report designer and do 'verify database' and am prompted with 'database is up to date', followed by 'database table xxx cannot be found. Proceed to remove this table from the report?' Y/N

and does so for all tables in the sub-report. It seems like main report does not recognise sub-report tables...

 

Tried on different workstations running CR XI designer and happens the same in all of them.

 

It only started to happen recently and there is no way to go around it... tried to re-import sub-report, delete/re-add sub-report all to no avail.

 

Any suggestions much appreciated.

 

Thank you,

Luis

 

 

Thank you for you suggestion. Tried that but ended up with same result.

 

It seems Crystal is seeing the database from the main report as different from the database in the sub-report. Strange thing is that it works fine when running within Designer but asks for Pm-xxx parameter when running it using the embedded viewer which is what the users use.

 

I'm running it against an Informix database, not sure if it has something to do with the database driver but again haven't changed that side of things... May try to log the issue with SAP and see what happens...