Advertisement

04.15.2007 at 06:24PM PDT, ID: 22512810
[x]
Attachment Details

Reporting Services - Multi-value parameter check all by default

Asked by CoconutTelegraph in SQL Server 2005, MS SQL Server, .Net Editors & IDEs

Tags: reporting, services, default, all, parameter

Hi there,

In reporting services, I've got a multi-value variable called @location_id. When the report renders it gives me a drop down list with a list of checkboxes so I can set the location_id.

How do I set initial the report so that all of the boxes are checked by default. Currently I have to check one or more and then press "View Report". I'm able to set one value to checked by default by modifying the "Report Parameters" default value for location_id. I need to set all of them though.

Many thanks!!
CTStart Free Trial
[+][-]04.16.2007 at 01:44AM PDT, ID: 18916416

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.17.2007 at 03:09PM PDT, ID: 18927885

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.18.2007 at 12:50AM PDT, ID: 18930124

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, MS SQL Server, .Net Editors & IDEs
Tags: reporting, services, default, all, parameter
Sign Up Now!
Solution Provided By: PFrog
Participating Experts: 1
Solution Grade: A
 
 
[+][-]05.04.2007 at 11:03AM PDT, ID: 19032782

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32