Reportviewer - few questions...

Hello!
I need help with my page.., If someone would help me (information or link)
how to do any step...
I'm creating a asp.net page with reportviewer control.
My idea is:
- three parameters to list (standart dropdownlist like in Reporting
Services)
a) computername (query from database "SELECT ComputerName FROM DATA")
b) countername (query from database "SELECT CounterName FROM COUNTERS")
c) countertype (query from database "SELECT CounterType FROM COUNTERS")
In Reporting Services 2.0 (SP2) where three tabs - data, layout and preview.
In Visual Studio 2005 is control "reportviewer". In "Report parameters" I
cannot set "Available values - from query"...
So my question is "How to fill parameter with values from SQL database?"
Thanks for helpC#:
ReportParameter rp = new ReportParameter("risk_rating", "LOW", false);
ReportParameter rp2 = new ReportParameter("userID", userID, false);
ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { rp,
rp2 });
Leszek wrote:
> Hello!
> I need help with my page.., If someone would help me (information or link)
> how to do any step...
> I'm creating a asp.net page with reportviewer control.
> My idea is:
> - three parameters to list (standart dropdownlist like in Reporting
> Services)
> a) computername (query from database "SELECT ComputerName FROM DATA")
> b) countername (query from database "SELECT CounterName FROM COUNTERS")
> c) countertype (query from database "SELECT CounterType FROM COUNTERS")
> In Reporting Services 2.0 (SP2) where three tabs - data, layout and preview.
> In Visual Studio 2005 is control "reportviewer". In "Report parameters" I
> cannot set "Available values - from query"...
> So my question is "How to fill parameter with values from SQL database?"
> Thanks for help|||Thanks!!
I made it other way - ojectdatasource, that is created on load aspx page.
Uzytkownik <mark.feferman@.gmail.com> napisal w wiadomosci
news:1149797507.592285.30150@.i39g2000cwa.googlegroups.com...
> C#:
> ReportParameter rp = new ReportParameter("risk_rating", "LOW", false);
> ReportParameter rp2 = new ReportParameter("userID", userID, false);
> ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { rp,
> rp2 });
>
> Leszek wrote:
>> Hello!
>> I need help with my page.., If someone would help me (information or
>> link)
>> how to do any step...
>> I'm creating a asp.net page with reportviewer control.
>> My idea is:
>> - three parameters to list (standart dropdownlist like in Reporting
>> Services)
>> a) computername (query from database "SELECT ComputerName FROM DATA")
>> b) countername (query from database "SELECT CounterName FROM
>> COUNTERS")
>> c) countertype (query from database "SELECT CounterType FROM
>> COUNTERS")
>> In Reporting Services 2.0 (SP2) where three tabs - data, layout and
>> preview.
>> In Visual Studio 2005 is control "reportviewer". In "Report parameters" I
>> cannot set "Available values - from query"...
>> So my question is "How to fill parameter with values from SQL database?"
>> Thanks for help
>sql