We help IT Professionals succeed at work.
Get Started

SSRS Legacy Report Running with no Data Source?

Karl_mark
Karl_mark asked
on
205 Views
Last Modified: 2015-11-24
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
Comment
Watch Question
Database Analyst
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE