hoseam (10/5/2016)
Hi,I have Test.rdll, with one parameter and one dataset
Dataset:
Name:Country
Query:
select distinct
[Country]
from [DW].[dbo].[Dim_Country]
where Active = 1
and Country = @Country
Parameter:
General; Name= Country, Prompt = Country, Data type = Text(Allow blank. Allow Null)
Available Values;
Get values from a query; Dataset = Country, Value Field = Country
Default Value = Null
when I try to execute this report, I get error with "Forward dependencies are not valid", I want to know how to solve this since I only have One parameter with One Dataset.
If your report has one dataset with one parameter then you should not be getting this message. Is there more that we are missing? Are you trying to cascade your parameters ? The order that you list the parameters matters
https://msdn.microsoft.com/en-us/library/aa337169.aspx
Did you create the parameter yourself or did SSRS automatically create it? Make sure the case is exact as SSRS is case sensitive. @myParam and @MyParam are two different parameters in SSRS.
----------------------------------------------------