March 27, 2014 at 10:10 pm
In an existing SSRS 2008 r2, report, I am attempting to add a parameter called 'Customer_Category'. I am getting the following error message:
The report paramter 'CustomerNumber' has a DefaultValue or a ValidVaue that depends on the report parameter 'Customer_Category'. Forward pointing dependencies are not valid.
I am trying to determine how to fix this error. The 'CustomerNumber' is a parameter value that is obtained by reading from a dataset. In this dataset there are existing other parameters called 'Customer_Type' and 'Customer_Preference'. Both of these parameters obtain there values from selections that the user makes when the SSRS report is executing. There are no default values.
I am trying to have the 'Customer_Category' be the same way where there are no default values and the user must select the parameter value when the report is executing. There should only be one value that the user can select from.
Here is the sql that is used from obtaining a list of customers from the dataset for customer_number:
SELECT Distinct CustomerNumber
FROM BridgeUserCustomer
WHERE
Type = @Customer_Type
AND Preference = @Customer_Preference
and Category = @Customer_Category
GROUP BY CustomerNumber
Would you tell me what is wrong and what I can do to solve the problem?
March 28, 2014 at 1:25 am
From the error it sounds like you have two parameters like this:
Parameter 1 (based on Parameter 2)
Parameter 2
If that's the case (I didn't try to digest everything you said) then you just need to move Parameter 2 to be above Parameter 1.
When you have parameters that reference each other, order is important so that everything can be resolved properly.
March 28, 2014 at 8:25 am
thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply