Skip to Content
0

How to use "Another Report Object" in hyperlink in crystal reports 2016

Oct 26, 2017 at 09:38 AM

376

avatar image

Hello , My requirement is when i click on a field in main report it should link to sub report using the option called Hyperlink -- type "Another Report Element". Not sure what i have to enter in Data Context field.

If anyone worked on this or any document you have can you please pass it on ?

Thanks

Paturi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Ido Millet Oct 26, 2017 at 01:12 PM
0

One option is to do this via on-demand subreports. But on-demand subreport cannot contain their own subreports.

If you need a solution without On-Demand subreports, there are ways to accomplish this but you need to clarify your deployment scenario:
a) local/remote desktop processing?
or
b) web server deployment?

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Oct 27, 2017 at 01:32 PM
0

Hi Paturi,

You cannot use a subreport as a 'Data Context Element'.

Could you please elaborate on what you're trying to achieve?

-Abhilash

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Hello Abhilash,

Can i send the details with screenshots in mail ? if you could share email id?

Thanks

0

Or else if you could send ur id to ppchowdary@gmail.com ...that would be great..

0

I am not using a subreport as a data context element my requirement is.. i have created a main report when i click on one filed in the main report the details it should open in the sub report. so in the main report whatever the field i have to click i have to make hyperlink on that field. When i rt click on that field in Format options >> Advanced>> Hyperlink>> Another report element>> Element name, Report URI, Data Context. In data context how i have to write syntax. Normally the syntax we write is "/" + {Table.Field} + "/" + {Table.Field}. https://help.sap.com/doc/dfc124becfa845ffa91b1e717b20e3ec/2016%20SP3/en-US/47723fe36e041014910aba7db0e91070.html

0

Hi Paturi,

Instead of trying to use a 'hyperlink', use a Subreport.

1. Replace the field you wish to click on with this Subreport.

2. Right-click this Subreport > Format Field > Subreport tab > Check 'On-Demand' Subreport.

3. Click the formula button beside 'Subreport Caption'. In the formula editor, use the field you removed in Step 1.

4. Right-click the Subreport > Change Subreport Links > Link fields from the Subreport and Main Report so that the Subreport shows data relative to the Main Report row.

This will show up the field value and the subreport will appear as a hyperlink.

-Abhilash

0
avatar image
Former Member Oct 27, 2017 at 03:13 PM
0
Share
10 |10000 characters needed characters left characters exceeded