If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Change prompt via cross tab selection. Javascript?

Started by Dulanic, 24 Sep 2013 03:25:45 PM

Previous topic - Next topic

Dulanic

OK, I have searched and searched and I really am at a loss as to whether this can be done. Basically the goal is this... there is a crosstab on the top and then 2 prompts for the x/y values of the crosstab. Below is a list that shows the values. So example x is Brian y is 9/24 if the user clicks on the value that says there is say.. 6 items that Brian worked on 9/24 abd set those prompts to those values, it would show those 6 values without changing pages or reports by setting the prompts which would in turn change the optional filter.

So I know I can reference the table overall & the prompts via JS. However, I am not as familiar with table positioning etc. with JS. Is there a way to say the user clicked on say position 5,5 so set prompt 1 to row label for row 5 and prompt 2 to the column label for column 5? If that makes sense.....

Oh and  part of the reason I have to go about it like this is our admins setup things kind of odd and we can only use TSQL for queries so otherwise I'd have to use a drill through. Maybe there is a better option out there I'm completely missing though.