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

 

Passing values from prompt page to active report variables via black arts

Started by Ogram, 03 Apr 2014 01:42:34 AM

Previous topic - Next topic

Ogram

I hope I'm wrong here but I assume there is no easy way to pass a value from a prompt page to an active report variable without user input? What I'm looking for is to have multiple report views that use the same base report but use different parameter values (and target recipients) and have the active report variables being set by the prompts in the report view.

I can easily set a singular value to an active report variable element (a data button bar for example) but the problem is I need to activate the said element to pass the value to a variable. I achieved the first part by having a prompt page on the active report where you can set the parameter for e.g. a store. In the actual report I have a data button bar which uses the said element as the data item. With proper filters a single store gets passed on to the button bar but doesn't actually pass to the related variable until the button is activated.

Now the problem is, how can I automatically activate that button (or any other suitable element that requires user action)? Can I simulate a mouseclick using HTML/JS to activate the element? The element could be hidden/masked so the recipient would see anything odd when running the report. Any other workarounds?

Regards,
Jussi