ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Hyperlinking SQL Reports?

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
jamma Posted - 02/08/2007 : 17:16:42
Is it possible to hyperlink one field in a SQL report (e.g. UserID) which when clicked calls another report using the hyperlinked value as a parameter (or "filter" in RP terminology)?
1   L A T E S T    R E P L I E S    (Newest First)
admin Posted - 02/12/2007 : 03:34:30
Yes, this is possible using HTML injection method. In the view mode, right click on a SQL report with filters and select “Hyperlink”. This will give you something like this:

http://localhost/reportportal/Proxy.aspx?reportId=348&Field1=

When building another SQL report you can link to the first one by building the hyperlink in the SQL like so:

SELECT
'<a href= http://localhost/reportportal/Proxy.aspx?&reportId=246&Field1=2>'+c.ConnectionName+'</a>'
FROM Connection c

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page