troubleshooting Question

Problem previewing reports in VS 2015/2017 using SSRS and Oracle 12c

Avatar of tancat
tancatFlag for United States of America asked on
Microsoft Server OSMicrosoft SQL ServerOracle DatabaseSSRSMicrosoft Visual Studio
4 Comments1 Solution1788 ViewsLast Modified:
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?

Thank you,
Cali
ASKER CERTIFIED SOLUTION
tancat
Oracle Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros