I have been tasked with creating some reports out of VS and SSRS from an Oracle 12c database. I am an Oracle developer but I don't know much about VS or SSRS. I have both VS 2015 (14.0.25431.01 Update 3) and 2017 (15.7.5) installed and I have installed ODTwithODAC for 12c. I have also installed SSDT for both VS 2015 and VS 2017.
Using VS 2017, i have created a new project but I am unable to create a shared data source. As soon as I select Oracle Database in the Type drop-down, the Edit button next to the connection string becomes grayed out.
Using VS 2015, I have cloned an existing project that works fine for my colleague. However, when I first tried to load the project I received a message that the version of the report server project is not supported and the project must be upgraded. If I say no, then the project won't load. If I say yes, the project loads and everything seems to be ok. However, when I try to Preview an existing report from the project, I receive the following error:
"An error has occurred during local report processing. An error has occurred during report processing. An attempt has been been made to use a data extension 'ORACLE' that is either not registered for this report server or is not supported in this edition of Reporting Services." There is nothing in the Error List when this happens.
The only difference between my colleague's setup and mine is that he has SQL Server Reporting Services 14.0.806.134 and I have 14.0.1012.227. However, I cannot find his specific version online anywhere to download it.
I am able to query the database if I go to the Dataset under Report Data, right-click and select Query and Run the query - no errors and data are returned.
Any ideas on how to resolve either of these problems? I was told that we have to use VS 2015 because we get an error with SSDT for 2017. Well, I'm getting an error with 2015 so neither one seems to be better than the other.
Is any additional information needed to solve this?