"EMartinez" <emartinez.pr1@gmail.com> wrote in message
news:1190947930.796948.230360@w3g2000hsg.googlegroups.com...
> On Sep 27, 8:24 pm, " -Hillary" <hill...@yahoo.com> wrote:
>> I am designing a report which need to take parameter input by user when
>> the
>> report is open. Can anyone please tell me how to do this? Using MS SQL
>> 2005
>> report. Thanks.
>
>
> If I understand your question correctly, you will want to pass this
> expression (=User!UserID.ToString) as a parameter (via selecting the
> Edit dataset [...] button then the Parameters tab on the Dataset tab)
> back to the dataset (that should be tied to a stored procedure or
> query) that is sourcing the Report parameter. Hope this helps.
>
> Regards,
>
> Enrique Martinez
> Sr. Software Consultant
>

On Sep 27, 8:24 pm, " -Hillary" <hill...@yahoo.com> wrote:
> I am designing a report which need to take parameter input by user when the
> report is open. Can anyone please tell me how to do this? Using MS SQL 2005
> report. Thanks.

" 00 Michael Jordan" <a@b.com> wrote in message
news:uFlDlcYAIHA.5360@TK2MSFTNGP03.phx.gbl...
> No, this is not what I want. I want a pop-up window to ask user to input
> a parameter when I am a report and this parameter will filter out the
> data. Say, when I run a product sales report, a pop-up window can ask me
> for which state and I input California. So the report only shows
> California sales report. Please help. Thanks.
>
>
> "EMartinez" <emartinez.pr1@gmail.com> wrote in message
> news:1190947930.796948.230360@w3g2000hsg.googlegroups.com...
>> On Sep 27, 8:24 pm, " -Hillary" <hill...@yahoo.com> wrote:
>>> I am designing a report which need to take parameter input by user when
>>> the
>>> report is open. Can anyone please tell me how to do this? Using MS SQL
>>> 2005
>>> report. Thanks.
>>
>>
>> If I understand your question correctly, you will want to pass this
>> expression (=User!UserID.ToString) as a parameter (via selecting the
>> Edit dataset [...] button then the Parameters tab on the Dataset tab)
>> back to the dataset (that should be tied to a stored procedure or
>> query) that is sourcing the Report parameter. Hope this helps.
>>
>> Regards,
>>
>> Enrique Martinez
>> Sr. Software Consultant
>>
>
>

wrote:
> RS has full support for parameters. You open up the report and at the top it
> lists the parameters. You can select from a predefined (by you) list, you
> can put in a value in a text box, you can select from a calendar control (RS
> 2005). It also has support for multi-select list boxes (RS 2005).
>
> If you create a query with a parameter RS automatically creates the report
> parameter.
>
> For instance, lets say my query is
> select * from sometable where somefield = 'blahblah'
> change to
> select * from sometable where somefield = @BlahType
>
> RS will create a report parameter called BlahType and give a prompt of the
> same name. You can change the prompt for the parameter by being in the
> layout tab, report menu->Report Parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> " 00 Michael Jordan" <a...@b.com> wrote in messagenews:uFlDlcYAIHA.5360@TK2MSFTNGP03.phx.gbl...
>
> > No, this is not what I want. I want a pop-up window to ask user to input
> > a parameter when I am a report and this parameter will filter out the
> > data. Say, when I run a product sales report, a pop-up window can ask me
> > for which state and I input California. So the report only shows
> > California sales report. Please help. Thanks.
>
> > "EMartinez" <emartinez....@gmail.com> wrote in message
> >news:1190947930.796948.230360@w3g2000hsg.googlegroups.com...
> >> On Sep 27, 8:24 pm, " -Hillary" <hill...@yahoo.com> wrote:
> >>> I am designing a report which need to take parameter input by user when
> >>> the
> >>> report is open. Can anyone please tell me how to do this? Using MS SQL
> >>> 2005
> >>> report. Thanks.
>
> >> If I understand your question correctly, you will want to pass this
> >> expression (=User!UserID.ToString) as a parameter (via selecting the
> >> Edit dataset [...] button then the Parameters tab on the Dataset tab)
> >> back to the dataset (that should be tied to a stored procedure or
> >> query) that is sourcing the Report parameter. Hope this helps.
>
> >> Regards,
>
> >> Enrique Martinez
> >> Sr. Software Consultant