March 25, 2009 at 6:15 am
Hi All,
My first time posting here, I have tried searching for this issue but haven't seemed to find the search terms required to get any results, or, there aren't any!
Anyway, we are using SSRS 2005 and are serving our reports directly out of the default SSRS web portal for now.
I have developed a report which accepts 4 multi-value parameters and passes them to an SP. The base functionality is fine and the report returns data as it should.
The options available in each of the multi-value parameters are obtained via stored procedures, this also works.
The problem I am experiencing is produced as follows (and can be produced in either the preview tab in BIDS OR the SSRS portal itself):
1. Load the report
2. Make my selections for each of the 4 input parameters
3. Click 'View Report'
At this point - intermittently - the 3rd input parameter either resets itself to blank and the report doesn't run or I get a message demanding the parameter is populated (it is required) yet the screen shows selected values.
I have to repeat the process from step 1 until it eventually gives in and actually runs the report successfully.
Has anyone experienced behaviour like this? If so, do you have / know of a fix?
Many thanks in advance for any help,
James
August 7, 2014 at 3:25 am
Hi,
I had similar issue in SSRS 2008.
When i tried to retrieve parameters (Date/Time) with labels (nvarchar(7)) after click "View report" parameters values picked from dropdown were cleared.
I read couple of topics on forums, but finally found out solution myself. Parameters had to be passed as Text not as Date/Time.
However problem might be caused by something else because in other report Date/Time as type of parameters in similar scenario works well.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply