How to pass parameters and LogOn Information from ASP.NET (C#) to Report

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » How to pass parameters and LogOn Information...

How to pass parameters and LogOn Information from ASP.NET (C#) to Report

Rate Topic

Display Mode

Topic Options

Author

Message

navpreet.khurmi

Posted Friday, April 03, 2009 8:15 AM

SSC Rookie

Group: General Forum Members
Last Login: Saturday, October 10, 2009 7:54 AM
Points: 31, Visits: 66

Hello,

I was using Crystal Reports earlier and had the code for opening the Crystal Report from my ASP.nET 2.0 (C#) code and also was able to pass the parameters but now I am new to SQL Server Reporting Services and have not Idea on How to pass parameters and LogOn Information from ASP.NET (C#) to SQL Server Reporting Services.

Can I open the Report from my ASP.NET?

Thanks!

Post #689939

Gift Peddie

Posted Friday, April 03, 2009 8:37 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432, Visits: 14,332

SSRS use Windows authentication by default while Asp.net uses forms authentication by default so if your Asp.net application is not intranet application then your better option is to use the ReportViewer control the web version.

http://gotreportviewer.com/

Kind regards,
Gift Peddie

Post #689965

navpreet.khurmi

Posted Friday, April 03, 2009 8:46 AM

SSC Rookie

Group: General Forum Members
Last Login: Saturday, October 10, 2009 7:54 AM
Points: 31, Visits: 66

Thanks for your reply.
It is an Intranet app and I am using Windows Authentication.

How Can I pass parameters from ASP.NET To Report?

Post #689978

Gift Peddie

Posted Friday, April 03, 2009 9:08 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432, Visits: 14,332

The two links below covers all known issues and existing solution if you choose to use ReportViewer control you could download the code in the ReportViewer site and see how it is implemented.

http://forums.asp.net/t/1376096.aspx

http://geekswithblogs.net/gobrien/archive/2004/07/30/9116.aspx

Kind regards,
Gift Peddie

Post #690003

pmp07

Posted Monday, February 04, 2013 8:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 06, 2013 12:58 PM
Points: 1, Visits: 18

Hi! I am working on a report as well that needs the parameters passed to it. Your link is unaccessible from within our firewall... Would you be willing to post the needed information? (my url works, just does not pass the parameters to the report - they just sit in the url)

Thanks in advance!

Post #1415338

« Prev Topic | Next Topic »

Permissions