Passing filters as parameters from one report to another while using hyperlinks.

[Guest]

Hi folks,

I am exploring a way to pass filters as a parameters from one dxp file to other dxp

I have two dxp files (reports say R1 and R2), In a report R1, I build a list table with following columns

EmpNo, EmpName, DeptNO, DeptName, ReportURL (ReportURL is a calculated column with hyperlink text which takes to Report R2 upon a click.)

The Report R2 also holds the information of EmpNo and DeptNo.

My goal is whenever user clicks the hyperlink from Report R1, corresponding EmpNo and DeptNO values has to be passed as filter parameter to Report R2 should open a report by applying filters dynamically.

As of now, I am able to open the report but notable to pass the filers as parameters to target report (R2)

Please assist me with step by step process to achieve the above case in Tibco Spotfire. Kindly provide the great level of details as possible as I am new to this tool.

Let me know if i missed any information in the post.

Looking forward for a response.

Thank you

[Kaaviya Nehe]

Does anyone having solution for this I also need help for this

[Shandilya Peddi]

Generally you can apply configuration block to apply filters when opening a report. So you can use the same approach and build the "ReportURL" column such that it has the url to report R2 plus the configuration block.

Below is the reference to configuration block,

https://community.spotfire.com/wiki/create-configuration-block-tibco-spotfire

[Kaaviya Nehe]

Thanks for the response, but its like static configuration right can it be dynamic

[Shandilya Peddi]

It would not be dynamic as it dependes on the other column values 

[Andrew Berridge]

A way to do this is to have a calculated column that constructs the configuration block and then show it in a table. If not the complete solution, it may inspire you to think of other ways to get this done.

Here is an example of a calculated column expression that constructs a configuration block:

"http://myspotfireserver.co.uk:8090/spotfire/wp/OpenAnalysisfile=/Demo/Analysis%20Files/Baseball/Baseball&configurationBlock=SetFilter(tableName=Baseball,columnName=Team,values=" & RXReplace([Team]," ","%20","g") & ");"Andrew Berridge (TIBCO Data Science)

View my book on Spotfire!