How to create a dropdown list on report?

I would like to create a first dropdown list on my report. How can I do that?
I am using followings,
Reporting service (SQL Server 2005 June CTP release)
Steps which I am following to create a report,
1. Creating a model using BIDS and publishing it to Report Server
2. By using Report Builder, I am creating new report and storing it on
Report server. In one of my report, I would like to display dropdown list for
Project with "Project Name". At present, I am using filter criteria for
displaying parameter on each report but it is only displaying text field.
I am still searching related post here and expecting help...
Thnks
--
There is a light on the other side, Keep walking.Try these steps. Step number 3 is the key item here.
1. Open the Filter dialog
2. Add a entity or field to the filter layout area
3. Click on the entity or field name. This will open a context menu. Select
the 'Prompt' option
4. Click on the filter condition. This will open a context menu. Select the
'In a List' option
5. Click the filter value dropdown. You can pre select values to display or
leave all items unchecked.
6. Run the report. You should see dropdown that contains a list of parameter
values.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nilesh Trivedi" <NileshTrivedi@.discussions.microsoft.com> wrote in message
news:4D0A8262-1594-4A5B-B06E-2A51401307AF@.microsoft.com...
>I would like to create a first dropdown list on my report. How can I do
>that?
> I am using followings,
> Reporting service (SQL Server 2005 June CTP release)
> Steps which I am following to create a report,
> 1. Creating a model using BIDS and publishing it to Report Server
> 2. By using Report Builder, I am creating new report and storing it on
> Report server. In one of my report, I would like to display dropdown list
> for
> Project with "Project Name". At present, I am using filter criteria for
> displaying parameter on each report but it is only displaying text field.
> I am still searching related post here and expecting help...
> Thnks
> --
> There is a light on the other side, Keep walking.|||Yes, I achieved so far. But my question is still open.
Consider following scenario,
Report designer - will create a report with selected dropdown items using
filter criteria <Fieldname> <in a list> <Item selected>. This field
<fieldname> is checked as prompt which will display parameter in a report
while running a report.
N.B.: As you are saying in your previous reply.
Report user - will run this report and will see only preselected <Item
Selected> by the Report Designer.
My query is to make more flexible to Report user so that Report user can
select any dropdown items. So on Report, Report user will have dropdown list
instead of simple textbox.
--
There is a light on the other side, Keep walking.
"Bruce Johnson [MSFT]" wrote:
> Try these steps. Step number 3 is the key item here.
> 1. Open the Filter dialog
> 2. Add a entity or field to the filter layout area
> 3. Click on the entity or field name. This will open a context menu. Select
> the 'Prompt' option
> 4. Click on the filter condition. This will open a context menu. Select the
> 'In a List' option
> 5. Click the filter value dropdown. You can pre select values to display or
> leave all items unchecked.
> 6. Run the report. You should see dropdown that contains a list of parameter
> values.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Nilesh Trivedi" <NileshTrivedi@.discussions.microsoft.com> wrote in message
> news:4D0A8262-1594-4A5B-B06E-2A51401307AF@.microsoft.com...
> >I would like to create a first dropdown list on my report. How can I do
> >that?
> > I am using followings,
> > Reporting service (SQL Server 2005 June CTP release)
> > Steps which I am following to create a report,
> > 1. Creating a model using BIDS and publishing it to Report Server
> > 2. By using Report Builder, I am creating new report and storing it on
> > Report server. In one of my report, I would like to display dropdown list
> > for
> > Project with "Project Name". At present, I am using filter criteria for
> > displaying parameter on each report but it is only displaying text field.
> >
> > I am still searching related post here and expecting help...
> > Thnks
> >
> > --
> > There is a light on the other side, Keep walking.
>
>|||I achieved my query by doing followings,
1. Create a basic report using Report Builder
2. Save Report on Report Server
3. Create a new project with Report Designer
4. Go to the Report Manager and Edit Report and save RDL file to Report
Designer project path
5. Add existing report to project created in step 3.
6. Apply features like Show/hide columns/Drilldown/Header/Footer/Company
Logo/Report properties/Change report parameters/ passing parameters to sub
report/Change column headers etc.
7. Save report (PUBLISH THIS REPORT TO REPORT SERVER WILL NOT WORK AND THROW
RUNTIME ERROR)
8. Go to Report Manager and upload and overwrite report file
9. Set report parameters in report manager (If required)
10. Run report with report server (if any initial parameter, apply in IE
address bar)
This is the way i am using RS 2005 (June CTP release). I am not sure whether
this is a right way of publishing report.
There are few advantages and disadvantages by using above way to develop
report
Advantages
- Utilising most of the report features available in Report designer
- Primary goal achieved by utilising Report model concept to develop report.
(BUT STILL EXPECTING MORE FEATURES AVAILABLE IN REPORT BUILDER)
Disadvantages
- Lot of maintainace to handle reports due to once upload this report can
not be edited in Report builder. Report builder capability is minimal and may
not be used as end user tool because final report is again developed in
report designer project which is a task of development team
- Adding a new column/change a layout etc. in existing report requires to
create report again i.e. STEP-1 as mentioned above
--
There is a light on the other side, Keep walking.
"Nilesh Trivedi" wrote:
> I would like to create a first dropdown list on my report. How can I do that?
> I am using followings,
> Reporting service (SQL Server 2005 June CTP release)
> Steps which I am following to create a report,
> 1. Creating a model using BIDS and publishing it to Report Server
> 2. By using Report Builder, I am creating new report and storing it on
> Report server. In one of my report, I would like to display dropdown list for
> Project with "Project Name". At present, I am using filter criteria for
> displaying parameter on each report but it is only displaying text field.
> I am still searching related post here and expecting help...
> Thnks
> --
> There is a light on the other side, Keep walking.