Has "Select All" option been checked for Multi-Valued Parameter?

Greetings.

I have downloaded the patch to SP1 that restores the Select All choice for MVP. I am now wondering if there is a clean way (property?) to know if the Select All box is checked. My reason for needing this is that I want to selectively print a block near the top of the report that shows all of the parameters used to create the report. There are many blocks of parameters and each can have 5-10 possible choices. It would be much cleaner if I could print "all" rather than list all of the possible values, if in fact that category was not really used to filter the rows.

Perhaps I need to build a dynamic where clause but I would rather not go to that trouble if I can use a built in feature or property.

Thanks in advance. I hope this makes sense.

No, this is by design. All values will be passed as a comma separated string.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||One possibility that you may use is to add an 'All' option to your selection list. Then in your SQL you could use specify WHERE ((FieldName IN (@.Parameter)) OR ('All' = @.Parameter)). Ugly but functional.

Handle Postbacks

RS2000
If a report have several parameter dropdowns, the data for each populated
dropdown is fetched again when data for non populated drop down is fetched.
Is there a way to handle postbacks events/viewstate more effective?
Regards Martin BringHave you created your own asp.net dropdowns to feed the parameters into the
report url address?
You can use the Atlas framework from Microsoft (see http://atlas.asp.net).
This allows partial postbacks of an asp.net 2.0 page, perfect for dependent
dropdowns...
"Maran" wrote:
> RS2000
> If a report have several parameter dropdowns, the data for each populated
> dropdown is fetched again when data for non populated drop down is fetched.
> Is there a way to handle postbacks events/viewstate more effective?
> Regards Martin Bring|||Thank you for replying.
No, I am just using the "out-of-the-box" functionality and so will it stay
for some time. In the future we might use our own code for paramters and
h´just call RS web service.
Regards Martin
************
"NH" wrote:
> Have you created your own asp.net dropdowns to feed the parameters into the
> report url address?
> You can use the Atlas framework from Microsoft (see http://atlas.asp.net).
> This allows partial postbacks of an asp.net 2.0 page, perfect for dependent
> dropdowns...
> "Maran" wrote:
> > RS2000
> >
> > If a report have several parameter dropdowns, the data for each populated
> > dropdown is fetched again when data for non populated drop down is fetched.
> >
> > Is there a way to handle postbacks events/viewstate more effective?
> >
> > Regards Martin Bring|||I am not sure I fully understand what problem you have. Are you trying to
have dependent dropdowns in the report viewer ?
"Maran" wrote:
> Thank you for replying.
> No, I am just using the "out-of-the-box" functionality and so will it stay
> for some time. In the future we might use our own code for paramters and
> h´just call RS web service.
> Regards Martin
> ************
> "NH" wrote:
> > Have you created your own asp.net dropdowns to feed the parameters into the
> > report url address?
> >
> > You can use the Atlas framework from Microsoft (see http://atlas.asp.net).
> > This allows partial postbacks of an asp.net 2.0 page, perfect for dependent
> > dropdowns...
> >
> > "Maran" wrote:
> >
> > > RS2000
> > >
> > > If a report have several parameter dropdowns, the data for each populated
> > > dropdown is fetched again when data for non populated drop down is fetched.
> > >
> > > Is there a way to handle postbacks events/viewstate more effective?
> > >
> > > Regards Martin Bring|||Yes, our parameter dropdowns is dependent on each other.
For example: If the user choose a country in one dropdown, regions will show
in another dropdown.
When running the report from the report server the data for the dropdowns
will be fetched each time (for the populated ones). Relating to ASP.Net I
would like the report to have som "ViewState" to remember the data it have
already fetched.
I just found out today that running the report in Visual Studio will not
fetch the data twice.
Regards
Martin Bring
"NH" wrote:
> I am not sure I fully understand what problem you have. Are you trying to
> have dependent dropdowns in the report viewer ?
> "Maran" wrote:
> > Thank you for replying.
> >
> > No, I am just using the "out-of-the-box" functionality and so will it stay
> > for some time. In the future we might use our own code for paramters and
> > h´just call RS web service.
> >
> > Regards Martin
> >
> > ************
> >
> > "NH" wrote:
> >
> > > Have you created your own asp.net dropdowns to feed the parameters into the
> > > report url address?
> > >
> > > You can use the Atlas framework from Microsoft (see http://atlas.asp.net).
> > > This allows partial postbacks of an asp.net 2.0 page, perfect for dependent
> > > dropdowns...
> > >
> > > "Maran" wrote:
> > >
> > > > RS2000
> > > >
> > > > If a report have several parameter dropdowns, the data for each populated
> > > > dropdown is fetched again when data for non populated drop down is fetched.
> > > >
> > > > Is there a way to handle postbacks events/viewstate more effective?
> > > >
> > > > Regards Martin Bring

halt execution and wait for parameters

Hello,
does anybody know of a way to to have RS wait to execute (on access) until
the parameter fields have been filled?
thanks,
gregI've noticed this was a problem when I had default values for every
parameter. Try to remove default values.
"greg" <greg@.discussions.microsoft.com> wrote in message
news:DDF49D51-17BC-4D9B-ACD5-B240C559AC08@.microsoft.com...
> Hello,
> does anybody know of a way to to have RS wait to execute (on access) until
> the parameter fields have been filled?
> thanks,
> greg|||Thanks for the response. That is the same problem I'm having. I have to leave
defaults (8 fields) but the users change certian fields. thanks again good
to see others are having the same issues.
Greg
"Jason" wrote:
> I've noticed this was a problem when I had default values for every
> parameter. Try to remove default values.
> "greg" <greg@.discussions.microsoft.com> wrote in message
> news:DDF49D51-17BC-4D9B-ACD5-B240C559AC08@.microsoft.com...
> > Hello,
> > does anybody know of a way to to have RS wait to execute (on access) until
> > the parameter fields have been filled?
> >
> > thanks,
> > greg
>
>