Reporting Services Prompts -- sql server reporting services

Al
8/2/2006 10:19:25 PM

We have a report that accesses a SSAS cube and has several prompts. We are
having a few issues with these prompts:

1) All but the first prompt is greyed out so you have to take them in order.
The users would like to be able to take them in any order.
2) After selecting the information from the first prompt it appears to be
doing a requery in order to get the values for the second prompt. This is
unnecessary since the values from the first one don't affect the values for
the second one. This also takes time which of course is not good.
3) There are a couple of prompts that it would be nice to widen the prompts
from let's say 30 characters to 50 characters.

Any ideas would be appreciated.

Thanks,

Al

magendo_man
8/3/2006 7:20:02 AM

I presume that your prompts are drop-down lists from datasets you have
associated with the report. Have you got an option with label 'ALL' and value
NULL in each of these. I genarally do this with a UNION query between the
actual data and the ALL/NULL default. You will also need to tick "allow null
value" for each report parameter.

HTH,
Magendo_man

[quoted text, click to view]

Al
8/3/2006 8:43:22 PM

Thanks, for the response. We found that there was a constraint in the
Datasets. Once we removed them the prompts started doing what we wanted
them to do.
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Reporting Services Prompts