April 8, 2010 at 10:16 am
I have a 315-col table (may be redesigned to a 360-col table) representing a flat-file (output from a site-audit on pda)
There are no complex entities/ER diagrams, so if I could view the SQL table in SharePoint (on SharePoint DataSheet) I would have the simple reporting done on the table in minutes, freeing me up to get on with more complex tasks in SQL
I have tried to engage the SharePoint/SSRS hook-up but SharePoint cannot see the Add-in.
While we are troubleshooting that, can anyone help - how to get SharePoint to view SQL table - is there an SSIS-based solution ?
T Charles Sheldon
April 8, 2010 at 10:54 am
tcsheldon (4/8/2010)
I have a 315-col table (may be redesigned to a 360-col table) representing a flat-file (output from a site-audit on pda)There are no complex entities/ER diagrams, so if I could view the SQL table in SharePoint (on SharePoint DataSheet) I would have the simple reporting done on the table in minutes, freeing me up to get on with more complex tasks in SQL
I have tried to engage the SharePoint/SSRS hook-up but SharePoint cannot see the Add-in.
While we are troubleshooting that, can anyone help - how to get SharePoint to view SQL table - is there an SSIS-based solution ?
T Charles Sheldon
In SSRS 2008 you could use Table instead of query in Report designer but if your table is 315 columns you need to write code so your report can be rendered without issues. The Sharepoint WebPart control is in the Reportmanager Styles folder you have to add your report into the WebPart and consume it in SharePoint. If you cannot use the WebPart, then you have to consume the web ReportViewer control in SharePoint.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply