Call up report from another report

[franklepkowski]

Hello,

I am developing a report that I would like to be able to select an item on the report and pull up another "detail" report. Has anyone done anything like this? I am curious what options exist to do it.

Frank

[pturmel]

This topic might work for you (linking to other Perspective pages with details, via report or otherwise):

PDF report linking

You completely nerd-sniped me with this topic - I definitely shouldn’t have spent as much time on this as I did. But, this is actually possible with the existing reporting module. We’ll definitely have to see about adding this capability in a better way. Basically, the workaround I came up with relies on the fact that objects in reporting can be copied to the clipboard and show up as XML representations of the underlying Java object. So, to use this (extremely janky) workaround: 0. Paste the s…

Kind of an old post, so might have bit rotted. @PGriffith will likely chime in...

[pturmel]

Actually, further down in that topic is this bit of good news:

PDF report linking

Good news! In 8.1.19 this will finally be directly possible: Plus some fixed bugs with link generation that this workaround would never have helped with

I don't recall ever seeing that.

[franklepkowski]

Thanks Phil. I am looking to have this function from within the Perspective Session. We do not have plans to export reports to PDF. I see two options here.

1. Instead of using a report, use a table to display SQL data for report and add double click to table to call up detail popup. This would require some scripting and views, but I feel would be a relatively small amount of effort.
   2.Utilize a nested query in the report and an additional table. Caveat here is that I would like a way to "hide" it on the report.

Frank