Eclipse Community Forums: BIRT » Change Hyperlink Parameter Name at Runtime

Home » Archived » BIRT » Change Hyperlink Parameter Name at Runtime

Change Hyperlink Parameter Name at Runtime [message #1637269]

Thu, 26 February 2015 11:29

Eclipse User

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:

?foo=valueInFoo&myOtherVar=myOtherVal

but when grouping by baz the generated querystring should look like

?baz=valueInBaz&myOtherVar=myOtherVal

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 16:06

Eclipse User

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.

Previous Topic:	Paste Format doesn't actually paste format
Next Topic:	Deccumulation?

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Apr 25 05:33:37 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter