Can I add parameters to a report in the Microsoft Report Builder.

Hi,
I'm using SQL Server 2005 Reporting Services and Visual Studio 2005.
I'm just wondering if I can add parameters to a report with the Report
Builder or is this facility only available in the VS2005 report editor? If
it's possible what are the steps I need to follow?
Alternatively, assuming that I can't add parameters in the report
builder directly, I was wondering if parameters could be defined in a report
model and then after it's published the parameters could be included in the
Report Builder report using the model?
Thanks in advance,
Mark.Hi Mark
You can add parameters by adding a Filter.
When building the filter expression click on the operator in the expression
and choose "Prompt" this will generate a parameter. I guess this operator is
not available for all filtering expressions and depends on attribute
ValueSelection property.
Hope this helps,
Jordi Rambla
SQL Server MVP (Reporting Services)
SolidQualityLearning Iberoamericana
"Mark Hayes" <MarkHayes@.discussions.microsoft.com> escribió en el mensaje
news:75FEDA12-7594-4EB4-A035-F93C9A3E6979@.microsoft.com...
> Hi,
> I'm using SQL Server 2005 Reporting Services and Visual Studio 2005.
> I'm just wondering if I can add parameters to a report with the Report
> Builder or is this facility only available in the VS2005 report editor? If
> it's possible what are the steps I need to follow?
> Alternatively, assuming that I can't add parameters in the report
> builder directly, I was wondering if parameters could be defined in a
> report
> model and then after it's published the parameters could be included in
> the
> Report Builder report using the model?
> Thanks in advance,
> Mark.|||I read your response, I am trying to Add a filter or Parameter to a report. I
don't see any expression Builder, just a list of values? Which in my case has
18,000 rows. Where does one build an expression for a filter?
"Jordi Rambla" wrote:
> Hi Mark
> You can add parameters by adding a Filter.
> When building the filter expression click on the operator in the expression
> and choose "Prompt" this will generate a parameter. I guess this operator is
> not available for all filtering expressions and depends on attribute
> ValueSelection property.
> Hope this helps,
> Jordi Rambla
> SQL Server MVP (Reporting Services)
> SolidQualityLearning Iberoamericana
> "Mark Hayes" <MarkHayes@.discussions.microsoft.com> escribió en el mensaje
> news:75FEDA12-7594-4EB4-A035-F93C9A3E6979@.microsoft.com...
> > Hi,
> > I'm using SQL Server 2005 Reporting Services and Visual Studio 2005.
> > I'm just wondering if I can add parameters to a report with the Report
> > Builder or is this facility only available in the VS2005 report editor? If
> > it's possible what are the steps I need to follow?
> > Alternatively, assuming that I can't add parameters in the report
> > builder directly, I was wondering if parameters could be defined in a
> > report
> > model and then after it's published the parameters could be included in
> > the
> > Report Builder report using the model?
> >
> > Thanks in advance,
> > Mark.
>
>