Hyperlink to file

[mnasuto]

Hi,

I have 2 crystal reports:

1-List of companies for example
Comp_id, Company
29, Microsoft
40, Segate
...............

2- Company Details base on Comp_id. This report have subreports.

I need to run 1st report, then from companies list clis on Company to see details.
I have to use hyperlink as my 2nd report contain subreports.

I created hyperlink on comp_id field.
When I run report in Crystal, then clic on hyperlink
2nd report is oppening in design view- is not displaying details for chosen company.

On hyperlink tab I am using formula:
"file:///R:/Reports/Programme/Lead_sheet.rpt?prompt0={sp_Companies;1.Comp_ID}"

Please help if you can
Best,
Marta

 

[IdoMillet]

I don't believe you can do this in Crystal.

The option to link to another Crystal Report actually creates an On-Demand subreport. This is no good in your case because the subreport can't contain a subreport (noty to mention that you can't pass a dynamic parameter).

You decided to use the option of invoking any executable.
In that case, the executable associated with the file gets opened and, as expected, Crystal simply opens the file into design mode.

My DataLink Viewer provides the functionality you are trying to achieve:

http://www.milletsoftware.com/DataLink_Viewer.htm

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com