Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is it possible to bind a ServerReport to a ADO.Net Datasource? Expand / Collapse
Author
Message
Posted Monday, April 22, 2013 10:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:42 AM
Points: 41, Visits: 70
I'm kind of new to Reporting Services, so bear with me. But as we use it now we write reports and deploy them to a Report Server. From the ASP.NET side of the house, we are generating a fairly complex query based on the value of a bunch of filters that are implemented on the page through ASP.NET controls, and the use said query to populate a DataTable (for display on screen in a gridview). Is there no way to bind a ServerReport to a Datatable?
Post #1445064
Posted Tuesday, April 23, 2013 7:11 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 21, 2014 3:16 AM
Points: 86, Visits: 759
It is possible to do this, you need to look into creating a Data Processing Extension.

Try

http://msdn.microsoft.com/en-us/library/ms154655%28v=sql.105%29.aspx

to get started.
Post #1445405
Posted Tuesday, April 23, 2013 7:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:42 AM
Points: 41, Visits: 70
Thank you
Post #1445406
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse