Passing Parameters to a hyperlink from within a Crosstab

[katepassaro]

 Hello - 

I'm not sure if this is possible, I am hoping it is. 

I would like the value inside of a crosstab to be a hyperlink that passes the row and column headings as parameters to a detailed report. I have built the hyperlink to the report without parameters, but when I attempt to add in the parameters for the row heading, it says the field isn't found. Is this a limitation of crosstabs? 

[mundrameenaxi]

Hi Katepassaro,

were you able to do the hyperlink?

[jasperjones999]

maybe not default functionality but why not create a column in your data for the report which contains the parameter tail for your hyperlink;

eg: client - city - salestotal - hyperlinkTail

John Doe - washington - 123.44 - JohnDoe&CrossTabColumn (this bit will be appended to the hyperlink prefix for reports on your server)

I've had time to test this theory but have done similar on other tools.