August 27, 2015 at 9:45 pm
When I execute an ssrs 2012 report in visual studio on my workstation and on a test report server, the parameter value is loaded correctly for the report. When I run the stored procedure in sql server management studio pointing to the prod databases that loads the values to the parameters in the ssrs reports, the sql runs fine.
When I run the ssrs 2012 report on the production report server pointing to the production database, the parameter dropdownlist is sometimes populated and other times it is not populated. When I run the ssrs 2012 report with the same parameters, I can tell consistently when the parameter dropdown list will have values and when it will not have values.
Thus can you tell me what I need to look at on the production report server, to see why the parameter value is populated in some cases and not in other cases?
August 28, 2015 at 1:32 pm
" I can tell consistently when the parameter dropdown list will have values and when it will not have values."
how? psychic powers?
Could it be a timeout?
August 28, 2015 at 2:07 pm
What is the source for the parameter values that should be included in this dropdown list?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply