ASP.NET - MS reporting services

Asked By SVK N on 13-Mar-12 04:44 AM
ReportViewer1.LocalReport.ReportPath = Server.MapPath("reports/DETAILS.rdlc");

 ReportDataSource rdS = new ReportDataSource("PERSONAL", GetData());

 ReportViewer1.LocalReport.DataSources.Clear();
          ReportViewer1.LocalReport.DataSources.Add(rdS);

 ReportParameter rp = new ReportParameter("Year", ListYear.SelectedValue);
          ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });

i have a listbox with year  and another with month

i need that the report when generated by default shld be of current month & year

when the users selects the month or and year from the listbox i shld get the reposrt accordingly

i get error when passng parameters

i tried using even serverreport instead of local

when using local i get  Message = "An error occurred during local report processing." - local 
and with  serverreport i get  report path not set 

kalpana aparnathi replied to SVK N on 13-Mar-12 04:59 AM
hi,

please try to remove the datasource from the report menu and  after adding it again so  may be helpful to solve this error

Regards,
D Company replied to SVK N on 13-Mar-12 05:21 AM
Hello, Before passing the parameter to the report couple of things u have to check.

1,Is the parameters are created at design time, have u tested and working fine?
2. When u deployed your report on report server, were u able to access from browser, using url of the rport
3.When u open your report in browser does it allow u to pass the parameter?
4.Is the user have enough rights to pass the parameter from out side

Check all the prerequits and let us know , in case of more help u need.

Regards
D
SVK N replied to D Company on 13-Mar-12 05:37 AM
currently myself with administrative rights is getting the error  not given to any user yet
report without any parametres is working fine

when i i open the report in browser currentyly i have given no such  mode to pass paramter
it from the code itself

the listbox are populated at run time
SVK N replied to D Company on 13-Mar-12 05:37 AM
currently myself with administrative rights is getting the error  not given to any user yet
report without any parametres is working fine

when i i open the report in browser currentyly i have given no such  mode to pass paramter
it from the code itself

the listbox are populated at run time
D Company replied to SVK N on 13-Mar-12 06:16 AM
You must have designed your report in BI?
Is there any parameters are define for the report?
SVK N replied to D Company on 13-Mar-12 06:57 AM
yes
report paramters are defined as month & year
using report/ report paramaters from menyu bar
how do i use it & pass the paramaters values
D Company replied to SVK N on 13-Mar-12 01:34 PM
In the dataset have u set the filter property, and when u run your report i it showing u the parameters?
check it and let me know

regards
D