I am in the desgn phase of several new functionalities and i am getting
quite stuck. Can anyone point me in the right direction on the
following.

Can you have a cascading prompt on the same page as its dependant
prompts? If so how does this work? Does the entire screen refresh? Or
do just the prompts refresh?

If you setup a link to a report passing parameters to the new report;
can you also do any math on one of those parameters? (i.e. year - 1
for benchmarks)

Is there a way to suppress the "Select All" link? Or change
"Select All" to do the same thing "Deselect All" does?
(Suppress the "in statement" we have had previous problems with the
"in clause getting too large" what may the cause be?

Is there an easy way to add a footer to all reports? (Confidentiality
statement - it can be scrolled out of view)

Thanks for the help

Zach

See answers inline...


"zachrt" <ztussing (AT) gmail (DOT) com> wrote

Yes, the entire prompt page will refresh but the browser cache should take
care of any already chosen entries. You simply set the cascade source
property of the secondary prompt to be the first prompt.


In the expression editor, if you attempt to add a calculation one of the
tabs is parameters. You can use these in calcs if you wish.

I would start by looking at the source code in behind the scenes for that
prompt type. You could likely modify the source code so that the javascript
executed by that click action is directed to the deselect code.

Look into setting up templates in the help file. Then modify all of the
default templates to include the footer you wish. This could also likely be
taken care of using the sdk.

Hope this helps
ya