Drill through to a Hyperlinked field in a sub-report 2

[eo]

Hi,

CRxi r2 on BOExi r2

We use this quite a lot, and I have been asked to improve the navigation, but always thought it was not possible. I hope I was wrong!!

I have a report with an embedded sub reports. Values on both the container report, and the sub-reports have been formatted to act as hyperlink's to various report parts, report instances and external url's.

The report is published to enterprise (but this issue occurs both in enterprise and in the report designer, so I am hoping a solution to one would be a solution to the other).

The user expects to go to the hyperlink destination when they click on a particular value, and this is indeed the case when they click on container report values. But when they click on Sub-report values, it first drill's into just that sub0report, then they have to click on the value again. Is there a way to stop this from happening. I.e. when they click on the sub-report value, it acts as container values would. Not first gop into the sub-report. Not a two click process.

EO
Hertfordshire, England

 

[JohnOB]

It would likely work the way you want if you exported the report as a pdf, I don't use Enterprise but could you schedule it to export the report as a pdf, every so often, to save you having to do it manually?

"Stupid isn't not knowing the answer, it's not asking the question

 

[eo]

This wont work as we use a complex set of drill downs and drill through's that cannot be done from a PDF.

EO
Hertfordshire, England

 

[gatehouse]

There is a way which might work - just depends how complex your embedded sub-report is.
Instead of hyperlinking fields actually in the sub-report, you could try minimizing the size of the sub-report so that it runs but is not actually visible. In the sub-report, store the values of the fields you want to hyperlink on as Shared Variables. In the main report (in a section after the sub-report) create formulas to display the values of the Shaerd Variables which were set in the sub-report, and hyperlink on those. So - when you click on the hyperlink, you are not actually in the sub-report,so the link behaves 'properly'

 

[eo]

It just so happens that I followed this route earlier today, and it does indeed give me what I want. A star for you none-the-less


EO
Hertfordshire, England

 

[JohnOB]

Good to know this works, can I ask what the formula would look like if you wanted to reference a field in a subreport?

Thanks

"Stupid isn't not knowing the answer, it's not asking the question

 

[eo]

The subreport is embedded in the container report and is only meant to show a single value or percentage. Using shared variables, the container report formula shows the same value or percentage. This new field (and no longer the value or p[ercentage from the embedded subreport - which is now minimised so that it does not show on the report) now becomes the host of the hyperlink code (which in my case takes the user to the latest scheduled instance of an independant business objects report).

EO
Hertfordshire, England

 

[lbass]

Interesting solution.

-LB

 

[gatehouse]

I have to say that lbass's solution to 'hiding' the sub-reports (as found on another post) is far more elegant !

"Instead of hiding the subreports, format each subreport (format->subreport->subreport tab) to "suppress blank subreport}. Also suppress all sections WITHIN each subreport, and finally, you can go to the section expert->section sub is in and check "suppress blank section".

The shared variables will still process even though the subs no longer appear. Note that neither the section the subs are located in nor the subs themselves can be suppressed or hidden.