Other Issues - Crystal Reports: Subreport hyperlinks disappear upon linking

Asked By Tino on 14-Mar-12 04:50 PM
Hi All,

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.

Thanks for your help. Please let me know if you need anymore information


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.
Somesh Yadav replied to Tino on 16-Mar-12 01:43 AM
try this,
Private Sub ConfigureCrystalReports()

'setup db connection for report

myConnectionInfo.DatabaseName = ...

myConnectionInfo.UserID =...

myConnectionInfo.Password =...

myConnectionInfo.ServerName = ...

SetDBLogonForReport(myConnectionInfo)

If (Session("supplierRpt") Is Nothing) Then

supplierRpt = New ReportDocument()supplierRpt.Load(Server.MapPath("SupplierReport_Final.rpt"))

LoadDataSources()

supplierRpt.SetDataSource(dsOcc)

supplierRpt.Subreports(
"FailOcc").SetDataSource(dsOcc.Tables("FailOcc"))

supplierRpt.Subreports("IndexByFailure").SetDataSource(dsOcc.Tables("IndexFail"))

supplierRpt.Subreports("FailByRank").SetDataSource(dsOcc.Tables("IndexFail"))

supplierRpt.Subreports("FailureType").SetDataSource(dsOcc.Tables("FailureType"))

supplierRpt.Subreports("SupplierRank").SetDataSource(dsOcc.Tables("SupplierRank"))

supplierRpt.Subreports("ComRank").SetDataSource(dsOcc.Tables("ComRank"))

supplierRpt.Subreports("ResponseTime").SetDataSource(dsOcc.Tables("ResponseSummary"))supplierRpt.Subreports("ResponseSummary").SetDataSource(dsOcc.Tables("ResponseSum"))

SetParameters() 

ApplyParams()

Session(
"supplierRpt") = supplierRpt

Else

supplierRpt = CType(Session("supplierRpt"), ReportDocument)

End If

crv.ReportSource = supplierRpt

End Sub

Tino replied to Somesh Yadav on 16-Mar-12 03:02 AM
Hi Somesh,
Thank  you for responding to my question. Where would I put that code in the record select?