June 10, 2014 at 1:23 pm
For Reporting Services 2012 on Windows Server 2012 --
I am trying to add new new connection type to SSDT for SSRS. I have a .Net driver that I can use as a ADO.Net source in SSIS and want to use the same driver in SSRS. I can add it as a Data Connection under server explorer but cannot reference it on a report. thoughts?
June 10, 2014 at 3:07 pm
Server Explorer doesn't have anything to do with SSRS.
You need to create a connection in the data sources of the report which is located in the Report Data pane (or under Shared Data Sources in the SSRS solution).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 11, 2014 at 9:11 am
Using SQL Server 2012, SSDT: Maybe a picture would help… (see my attached PIC)
After right-clicking on Data Sources and select Add New Data Source this is the prompt. How do we add to the list of data source types?
June 11, 2014 at 12:04 pm
It might be possible to add a custom data source extension, but I have never done it before.
Take a look at this page:
Data Sources Supported by Reporting Services (SSRS)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply