Clever Geek Handbook

Reporting Services 2005 - Parameter Dependent on Cascading Parameters

good day

I have the following:

In an SSRS 2005 report, I have three report parameters: FinancialPeriodType (Month or Week in DropDownList), FinancialPeriod (cascading DropDownList populated based on first selection) and another parameter, ReleaseBalance, of type float.

The first two parameters are cascading, that is, the first parameter is used by a query that populates the two available values. This works great.

What I am doing is the default ValueBalance for a value from a dataset populated by a stored procedure that takes the first two parameters. However, as soon as I select a value for the first parameter, I get the following error:

An error occurred while processing the report. The value for the report parameter 'OpeningBalance' is invalid for its type. '

I tried to set the default value of the second parameter as a meaningful default (like 200901) and also the default second parameter in the SQL storage procedure without any changes. Using SQL Profiler I noticed that selecting a value for the first parameter doesn't even execute the SQL used to get the available values ​​for the second parameter.

+2


source to share


1 answer


Ok after multiple and popup it seems like RS doesn't like the fact that the OpeningBalance is float. By changing it to a string, and then completing the task if necessary, solve the problem.



0


source






More articles:


All Articles