Reporting Services Prompts

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,
AlI 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
"Al" wrote:
> 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
>
>|||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.
"magendo_man" <magendoman@.discussions.microsoft.com> wrote in message
news:0DFBBDA3-CB92-4CB2-92E0-A42216EEB97B@.microsoft.com...
>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
> "Al" wrote:
>> 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
>>
>>