troubleshooting Question

SSRS Legacy Report Running with no Data Source?

Avatar of Karl_mark
Karl_mark asked on
SSRSDB Reporting Tools
4 Comments1 Solution214 ViewsLast Modified:
I've taken over the SSRS reports in our organisation and have the responsibility of developing new reports. I can do this (although not as well as the previous incumbent coming as I do from more of an SQL background).
Anyway, I'm having a problem with login credentials for some reports I've developed; we have a bespoke solution provided by our application vendor which passes credentials through to the reporting server. For some legacy reports this works fine and the reports open. However, the new reports I have created prompt for an SSRS login, UNLESS I have already opened one of the reports that does work. It seems that running a report that does work stores the credentials meaning that subsequent report requests do not require SSRS login.
So, what I would like to do is figure out why a working report does not require login credentials and see if I can replicate the setup in my new reports. Looking at one of the reports in BIDS, I can see that there is no data source shown, either embedded or shared. Obviously the report will not run in BIDS. However, the same report runs perfectly happily in Report Builder 3.0. I can't see any connection strings hidden anywhere, no parameters or variables appear to be set up, so I'm just wondering how it is possible for that report to work with no data source?

For information, here is a screenshot of the report in Report Builder:

Report Builder Design
And the Report results:

Report Results
Database Analyst
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 4 Comments.
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>


Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 4 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004