Showing posts with label url. Show all posts
Showing posts with label url. Show all posts

Friday, March 30, 2012

Problem in form Authentication

Dear All,
I have problem while calling my report from report server using URL METHOD.
we have config'red our reporting service using forms Authentication.
(so we have login page)
My problem is i have to call the report, using URL METHOD, by supressing
that login page
why becos, some Credentials i will get it from my aplication.
Pls guide me how to supress and call the report from codebehind using URL
METHOD.
Million of Thanx in advance
Gopal PrabhakaranYou need to Logon to the Report Server using the LogonUser() WebService
method

Friday, March 23, 2012

Problem in calling SQL Server Report through URL

I called a sql server report from asp.net using the following URL

http://phx-ps01/Reports/Pages/Report.aspx?ItemPath=%2fISTEPS_REPORT%2fEQAPCompleteActionsPHX&rs:Parameters=false&rno=" & a &"'

I passed one report parameter whhich is "a".

Report is called correctly, but the problem is parameter is not passed to the report and also parameter bar is visible on the tool bar in the report.

Is there any help that parameter value is passed correctly and parameter option is not displayed on the tool bar of the report.

Hope for the best.

Thanks in advance.

Hello,

To pass paramter to server report use the following code

List<ReportParameter> ReportParamters = new List<ReportParameter>();

ReportParameter paramA = new ReportParameter("a", "test");
ReportParamters.Add(paramA);

rptViewer.ServerReport.SetParameters(ReportParamters);
rptViewer.ServerReport.Refresh();