Hi everyone,
I am in the final steps of implementing a shared SSRS report from another organization.Thanks to their tremendous help, we adjusted permissions, parameters, data sources, changed file paths, etc., but still having some trouble.
In Test, the report executes, but does not actually provide any results. The criteria/parameters is in the output, but that is about it. I have played around with the different criteria and have produced the same results. Anyone have any thoughts or suggestions? Here is what is displaying: https://www.screencast.com/t/I41pHA9Kt I feel that the report does not have the correct connection to the database, but seems to when I select the different criteria.
I am by no means a DBA, so any thoughts broken down step by step (dummy version) would be much appreciated.
Happy Reporting!
Joe
Does it run via SSMS? If it does and produces data, make sure infomaker has the correct parameter order meaning that the procedure and the report have the parameters in the exact order they should be.
also, the report set up needs to be looked at as well for completeness, spelling, and parameter order