Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Change Hyperlink Parameter Name at Runtime
Change Hyperlink Parameter Name at Runtime [message #1637269] Thu, 26 February 2015 16:29 Go to next message
andy rush is currently offline andy rushFriend
Messages: 15
Registered: July 2014
Junior Member
I have a report wrapper that uses BIRT as the underlying technology. The wrapper (among other things) modifies queries so that that GROUP BY clause can be changed at runtime. E.G.:

SELECT foo, bar FROM t_foo GROUP BY foo

can be modified to

SELECT baz, bar from t_foo GROUP BY baz

if the user want to see the data grouped by quuz. This all works fine. There is a form control that allows the user the grouping desired. Now comes the tricky part, hyperlinking column foo to the underlying data for the grouping permutations.

The report is structured in a way that its query can be used to display both high-level aggregate data and the lower-level underlying support data - "foo" and "baz" are database categories that can be aggregated into the value displayed in column "bar"; as a result "bar" can be used as a self-referencing hyperlink but only if the parameter name of the group can be altered at runtime. For example if, when grouping by "foo" the generated querystring looks like:


but when grouping by baz the generated querystring should look like


Is this possible in BIRT or would i have to do a string replacement in the link text after the report has been generated?
Re: Change Hyperlink Parameter Name at Runtime [message #1652348 is a reply to message #1637269] Thu, 05 March 2015 21:06 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

So, the values you're displaying in the report are the hyperlinks created from your query? Is this correct? I'm not sure I'm understanding where this change needs to be made. If it's hyperlinks you're displaying in your report, it should be easy to do wit ha little scripting.


Developer Evangelist, Silanis
Previous Topic:Paste Format doesn't actually paste format
Next Topic:Deccumulation?
Goto Forum:

Current Time: Sun Jul 21 10:33:10 GMT 2024

Powered by FUDForum. Page generated in 0.03315 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top