ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Hyperlinking SQL Reports?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jamma

18 Posts

Posted - 02/08/2007 :  17:16:42  Show Profile  Reply with Quote
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)?

admin

1645 Posts

Posted - 02/12/2007 :  03:34:30  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page