Hello Experts,
How could I see the details of a sub-report inside a report? I do not want to click on the sub-report to view the results. I would like to append the results of the sub-report with the results of the main report. Appreciate any help.
We are using BOXI r2 SP4, Crystal XI, SQL server 2000.
its_vicky07 
(BOB member since 2007-09-02)
Hi Vicky,
Go to Format Sub-report and disable the “On-demand Subreport” This will display the sub-report contents in main report…
Muna 
(BOB member since 2008-08-05)
It is working.Thank you Naaz.
its_vicky07 (BOB member since 2007-09-02)
Cheers … 
Muna (BOB member since 2008-08-05)
Hi Naaz,
Thank you for your quick help and support. Is there a way where we could display the results of the main report 1st and then the results of the sub-report. I tried putting it in a different detailed section but did not work as expected.
Also I am experiencing one more issue (Database Vendor Code 4060) in another crystal report (no sub-reports, only one report). I am trying to use two different databases thru 2 different and distinct ODBC connections. The report works in Crystal designer. But fails when I run the report using infoview. Appreciate any help.
We have BOXIr2 SP4, Crystal XI and SQL server 2000.
its_vicky07 (BOB member since 2007-09-02)
To print sub-report after the main report, try to place the sub-report in the section that comes after the fields in main report… I am not sure, in which section you have your main report fields…
for Database Vendor Code 4060 - can you tell me the txt msg your are getting for this error.
Muna (BOB member since 2008-08-05)
Please find below the full message.
Failed to open the connection. C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\reportserver.reportjobserver~tmp1be4599cdc5a361b.rpt Details: [Database Vendor Code: 4060 ]
its_vicky07 (BOB member since 2007-09-02)
Try this,
open the report in crystal.
Go to database expert - >set database location -> create new connection and update the existing connection…
update all the database connections including the one in sub-report.
Muna (BOB member since 2008-08-05)
Sorry…I think I confused you. This issue is with a different report where we do not have any sub-reports but I am trying to use 2 different databases with 2 different ODBC connections. When I run the report thru crystal designer it works fine but when I run/schedule the same report thru Infoview I am getting the above said error message.
its_vicky07 (BOB member since 2007-09-02)
Do you have the odbc connection created in the server??
Muna (BOB member since 2008-08-05)
Yes. I did and confirmed they are working as expected.
its_vicky07 (BOB member since 2007-09-02)
did you update the login information in CMC?? if not, open the report object in CMC, go to database properties and then update the database connection details. then try to run/schedule the report from infoview…
i hope the report will work then
Muna (BOB member since 2008-08-05)
I made the necessary changes. In database properties I can see 2 distinct connections. I selected individual connection (separately) and updated the database log in information. Still it is not working.
its_vicky07 (BOB member since 2007-09-02)
Usually, when you have odbc connection created in server and the db properties are updated, then the report will work fine.
Muna (BOB member since 2008-08-05)
Try to update the connection in crystal reports using Set Datasource location. and then publish it to reposity and try.
Muna (BOB member since 2008-08-05)