I am working in Crystal Reports XI. I have a main report that has 14 sub-reports. Some of the sub-reports are a quarter of a page some a couple of pages. The problem I am having is the on demand hyperlink disappears when I link my main report to my sub-report. I am just trying to pass the date parameter from the main to the sub. Has anyone had this problem before? In my main report I created a date time parameter and then inserted that into a formula and am passing that to the sub-report. I use the main report to run the Stored Procedure which builds tables that the other reports are built from.

To fix the problem I had I just created two dummy fields in my SP utilizing the start and end date parameters so each table had the correct start and end date generated by the main report. I would still like to know how to stop the above from happening when linking the sub-report to the main table

D Company replied to Tino on 14-Mar-12 10:26 PM

Hello,
At first it seems the parameter issue. ideally u should use same parameters in the main report as in the sub report .
follow these fixed thread
http://stackoverflow.com/questions/460494/crystal-will-disappear-when-previewing-a-subreport
also
http://social.msdn.microsoft.com/Forums/hu/vscrystalreports/thread/0addeabc-58e7-473b-a3ea-d489981b2c79
Step by Step process to add sub report
http://peoplesoftexperts.blogspot.in/2007/04/how-to-link-sub-report-to-main-crystal.html

I would request u to share database and field details if u face the same problem again.
Regards
D

D Company replied to Tino on 14-Mar-12 10:38 PM

Hello,

Sometimes back i have read some article which describe the same problem, and to avoid such things author suggested to have utf-8 format , and the command to do this is
CREATE DATABASE name ofurdb CHARACTER SET utf8 COLLATE utf8_bin

request u to check the proper syntax and the way to enable your db as utf-8 read msdn article
http://blogs.msdn.com/b/qingsongyao/archive/2009/04/10/sql-server-and-utf-8-encoding-1-true-or-false.aspx
give a try to this, and let me know if it does not work

Regards
D

Tino replied to D Company on 15-Mar-12 12:10 AM

Thanks so much. I really appreciate the information. I will give it a try tomorrow. I have to use Crystal Reports a lot now so I'm sure I will need this information in the future.