.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

How to pass cridentials for SSRS in ASP.net

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
 
hi, please reply its urgent. I post my report on report server and it is working properly when i access it from report manager or report server but when I try to access report from my asp.net application, it through following error "The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. The request failed with HTTP status 404: Not Found " Following code i used on page load           ReportServerUrl As String = http://Servername/ReportServer ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote  New Uri(ReportServerUrl) "/ReportsFolder/Report1" While ReportViewer1.ServerReport.IsDrillthroughReport  ReportViewer1.PerformBack() End While ReportViewer1.ServerReport.Refresh() Thanks in advance     ReportViewer1.ServerReport.ReportPath = ReportViewer1.ServerReport.ReportServerUrl =


View Complete Post


More Related Resource Links

How to pass current user's login name as parameter to a RDL . (SSRS integration with sharepoint)

  
I have a webmethod which has two parameters. One is for year and another is for Currently logged in user. I call this method in RDL file. From RDL File how can we pass Currently logged in user's login name? I tried  with USER!UserID. It is passing the USERID but i need to pass the login name(SPWEB.currentuser.loginname)  

pass Drop down selected value to Texxtbox in SSRS Reports

  
hi, i have developed a ssrs report which as Two dropdown as parameter first one is used to select the Starting year second one is used to select the ending year based upon the selected value a table will retreive data's Above the table there s textbox which is used to give message as "Project From year 2006-2007 " this 2006-2007 must be the dropdown selected how to do this? Thanks, Saraswathy

Pass parameter to Hidden Field in SSRS Report

  
Hi, I have Two Columns in a Table Say As Table1 Column1 = Text Column2= id My SSrs Report has two parameter values as Column1 and Column2. Column2 should be hidden SELECT DISTINCT COlumn1 FROM Table1. i have passed this query dataset to Column1 parameter. Now My requirement is that, when ever column1 drop is selected. the hidden field column2 should fecth the corresponding ID. this column2 has Storeprocedure which will Display the Output when View Report button is clicked Thanks, Saraswathy

MDX to pass all members of a hierarchy to SSRS

  
Hi.. I am creating a report action for a cube. i want to pass the members of different levels from the hierarchy to the report.I don know how to retrieve the members from different level. Can some one provide me a basic strcture of the code to achive that.    

Pass paramaters to SSRS Subscriptions using VS2005

  

Hi,

Newbie here. I have created SSRS reports and built a user UI to run these reports. Now when creating SSRS subscriptions in report Manager, is it even possible to programmatically pass the delivery method (email or file share), To email address, scheduled time and date, etc from my front-end UI to the Report Manager?

Any help will be greatly appreciated. Thanks


Pass delivery method, email address to create SSRS subscription using VS2005

  

Hi,

I have created SSRS reports and built a user UI to run these reports. Now when creating SSRS subscriptions in report Manager, is it even possible to programmatically pass the delivery method (email or file share), To email address, scheduled time and date, etc from my front-end UI to the Report Manager?

Any help will be greatly appreciated. Thanks


How do I call an SSRS Report from a stored procedure, and pass parameters?

  

Hi all,

I have a Report, that I want to run ad-hoc from a Stored Procedure. 

I want to render this report to PDF format, and save it to a drive.

The difference between this post and most threads I've seen is I don't want to run a stored proc within the report and send parameters to the stored proc.

I DO want to call a report FROM the stored proc, and send parameters TO the report.

How can I do this?

Many thanks,

Jason


programatically pass the connection string to the ssrs reports

  

hi... to all
i've created ssrs reports local following is my code..
 public void source(string tbname,string Rptname)
        {
            ReportViewer1.Visible = true;
            string myQuery = "select * from " + tbname;
            SqlConnection myConnection = new SqlConnection(ConnectionString);
            SqlCommand myCommand = new SqlCommand(myQuery, myConnection);
            myCommand.Connection.Open();
            SqlDataAdapter da = new SqlDataAdapter(myCommand);
            DataSet dt = new DataSet();
            da.Fill(dt);
            //ReportParameter[] p = new ReportParameter[1];
            //p[1] = new ReportParame

programatically pass the connection string to the ssrs reports

  
hi... to all
i've created ssrs reports local following is my code..
 public void source(string tbname,string Rptname)
        {
            ReportViewer1.Visible = true;
            string myQuery = "select * from " + tbname;
            SqlConnection myConnection = new SqlConnection(ConnectionString);
            SqlCommand myCommand = new SqlCommand(myQuery, myConnection);
            myCommand.Connection.Open();
            SqlDataAdapter da = new SqlDataAdapter(myCommand);
            DataSet dt = new DataSet();
            da.Fill(dt);


            //ReportParameter[] p = new ReportParameter[1];
            //p[1] = new ReportParameter("@p_dno", "5");
            //this.ReportViewer1.LocalReport.SetParameters(p);
 &n

programatically pass the connection string to the ssrs reports

  
hi... to all
i've created ssrs reports local following is my code..
 public void source(string tbname,string Rptname)
        {
            ReportViewer1.Visible = true;
            string myQuery = "select * from " + tbname;
            SqlConnection myConnection = new SqlConnection(ConnectionString);
            SqlCommand myCommand = new SqlCommand(myQuery, myConnection);
            myCommand.Connection.Open();
            SqlDataAdapter da = new SqlDataAdapter(myCommand);
            DataSet dt = new DataSet();
            da.Fill(dt);


            //ReportParameter[] p = new ReportParameter[1];
            //p[1] = new ReportParameter("@p_dno", "5");
            //this.ReportViewer1.LocalReport.SetParameters(p);
 &n

SSRS Date Time value in parameter, pass SP

  

Hello,

I had a strange problem last week in few SSRS Reports, scheduled in a report server.

SSRS Report

This report uses StartTime and EndTime parameters defined as 'String' data type and the default value is populated from a dataset. (Format of String, 10/29/2010 6:00:00 AM)

The report uses a stored procedure (stored_proc) to pull the report data from the SQL Server database for display in the report.

The SP stored_proc uses 3 input parameters named below
@par1 nvarchar(4000)
@StartTime nvarchar(20)
@StopTime nvarchar(20)

It was worked well for the past one year, but suddenly it stop run in production and throws the below error.

System.Data.SqlClient.SqlException: Conversion failed when converting datetime from character string.

When we look at the SP, the below line of code throws the error(CreateDate is the database table column).

Where (CreateDate >= @StartTime AND CreateDate < @StopTime ) 

From the profiler log, we understand that the below statement was triggered by SSRS.

exec stored_proc @par1=N'4',@StartTime=N'10/29/2010 6:00:00 AM',@StopTime=N'10/29/2010 6:00:00

Can I have 3 different tables in a report? And, can I pass 3 temp table to SSRS as source for these

  
I'm using BI 2008 and sql 2005 and 2008.  Is there an example to show me?  Thanks.
Lapucca

How to pass multivalued parameters to SSRS report hosted in ReportServer from ASP.Net page

  

I have a webpage from which Im passing parameters to a SSRS report.

While passing mutiple values from a multi valued parameters, the URL is exceeding the value of 2038 and hence the report is not showing up. Any suggestions on this matter would be really helpful.

eg: MacCode is a parameter and is multivalued attribute. Im choosing from the webpage drop down the values 1,2,3,4,5,6,7,8 for this MacCode. When it is passing to the ReportServer URL , it may exceed 2038 character limitation of URL.

 

Howto handle this... Please help

 


How to Pass Values Between Web Pages ASP.NET

  
You can pass information between pages in various ways, some of which depend on how the redirection occurs. The following options are available even if the source page is in a different ASP.NET Web application from the target page, or if the source page is not an ASP.NET Web page:

Use a query string.

Get HTTP POST information from the source page.

The following options are available only when the source and target pages are in the same ASP.NET Web application.

Use session state.

Create public properties in the source page and access the property values in the target page.

Get control information in the target page from controls in the source page.

How to Pass Values Between ASP.NET Web Pages

  
You can pass information between pages in various ways, some of which depend on how the redirection occurs. The following options are available even if the source page is in a different ASP.NET Web application from the target page, or if the source page is not an ASP.NET Web page:

Use a query string.

Get HTTP POST information from the source page.

The following options are available only when the source and target pages are in the same ASP.NET Web application.

Use session state.

Create public properties in the source page and access the property values in the target page.

Get control information in the target page from controls in the source page.

pass value from textbox to action, formcollection best way here?

  

Hi I'm building a e-commerce store and on quantity of product I'm going with a textbox. I thought I would ask how would you do this? a viewmodel to use a strongly typed textbox or just get the value of the textbox from the formscollection passed in to the action?


Thanks for any input


Pass a grid column value to a Modal

  

Hi, I have a requirement to hide a field called details on a gridview and show it in a jQuery modal dialog when users click on the Customer ID hyperlink. This grid is created programmatically. I will be hiding the details column via the CSS display:none property. Does some one know how can I pass the grid's selected hidden column value to the modal? Here is some of the code I started:

            GridView mygrid = new GridView();
            //.....................................More columns code for the grid

            //Here is where I need to pass the Details column value associated with the customer ID field selected to the Modal and open the Modal dialog.            
            HyperLinkField linkField = new HyperLinkField();
            string[] dataNavigateUrlFields = { "CustomerID" };
            linkField.DataTextField = "CustomerID";
            linkFi

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend