Hyperlink issues when merging RPTs into 1 RPT

[Former Member]

Hi All,

Requirement:

We have a requirement such that we will have to combine 2 or more RPTs into 1 RPT such that the output of the combined RPT looks like output of the first individual RPT and then the output of second individual RPT.

Our ActionPlan:

We are planning to have the individual RPTs as subreports in the Detail section of the main RPT. There is a query in the main RPT which will return us rows equal to the number of reports to be merged in the main report. The main query returns a unique ExecutionId for each individual report and we are using a GroupExpert on this ExecutionId so that the multiple subreports, present in different DetailSection of the main RPT gets executed and we get the desired result.

We have different PageHeaders corresponding to individual RPTs. Also these PageHeaders have text controls which require a hyperlink to be done to the subreports.

Issues Faced:

1) Since the Group is on ExecutionId ,when we make a hyperlink(To another report object) from the PageHeader to the Details section subreport then it opens a new tab which is actually containing the entire data for that particular ExecutionId. Can I avoid the opening of the Hyperlink in the new tab?

2) The subreport can be clicked and viewed as a new tab in the Preview.This is a default behaviour of Crystal Reports. Can the opening of subreports in a new tab be avoided and they should not prompt for any Hand or something so that the user never clicks it?

Thanking you all in anticipation....

Regards.

Ajit.

[Former Member]

Hi All,

Thanks Stratos for the reply and my apologies for replying late to the thread (I went on a vacation and sorry for that).

My question was 'Can i disable the click of subreports when the report is previewed?'; Ur soution was that 'I should try to overlay the subreport with a transparent rectangle'. But the solution suggested does not serve the purpose. I have a subreport in the Detail section and then I inserted a Box in the Detail section such that the Box spreads over the subreport and also checked the property of Extend to Bottom of Section when printing. The Box now comes on top of the subreport in both Design and Preview. But the subreport is still clickable and no success there.

I am using Crystal reports 2008 version.

My first question relating to Hyperlink is still unanswered. I will explain it further to give you my exact requirement from the Designer perspective which would help us in clear understanding of the requirement.

The design of the report looks like

RH Index Page of the Merged report

PHa Report Title and the parameters of the report1

PHb Report Title and the parameters of the report2

GH1 Group1 on the ExecutionIDs (Always suppressed)

Details a SubReport containing the transactional data of Report1

Details b SubReport containing the transactional data of Report2

GF1a Subreport of AccountNames of Report1

GF1c Subreport of AccountNames of Report2

My 2 issues are :

1) I have to hyperlink a text object in PHa to the subreport present in GF1a. Since I cannot hyperlink a subreport directly, i tried using a dummy text object on top of subreport and then tried to hyperlink it to PHa, it opens as a new tab whereas I want it to navigate and hyperlink in the same report in the same tab like any other hyperlink to another report object.

2) Disable the click of subreport.

Incase i have written something incorrect then please do correct me and help me out.

Thanking all in anticipation.

Regards.

Ajit.

[former_member142702]

1) Which version of BO are you using?

2) Try to overlay the subreport with a transparent rectancle.

Regards,

Stratos