Forward dependencies

I have a report for which the connection string for the data source is
passed in dynamically as a parameter to the report. This report has a
second input parameter (e.g. state) for which the dataset is also
retrieved from the database. The data source for the states dataset
is the same data source which gets its connection string
dynamically.

When I execute this report I get the following error: "The report
parameter 'State' has a DefaultValue or a Valid Value that depends on
the report parameter 'ConnectionString'. Forward dependencies are not
valid."

If the single data source for the report gets its connection
information dynamically, is there any way to have a second dataset
depend on that data source? If not, how can I make the data source
for that second dataset dynamic also?

Thanks in advance.

Rich

You need to have the parameter used for the connection string come before
the parameter for State. Just change the order of the parameters.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"SQL Dude" wrote in message
news:faccd397-0d9d-4ebb-beec-954a041da624@f10g2000vbf.googlegroups.com...
> I have a report for which the connection string for the data source is
> passed in dynamically as a parameter to the report. This report has a
> second input parameter (e.g. state) for which the dataset is also
> retrieved from the database. The data source for the states dataset
> is the same data source which gets its connection string
> dynamically.
>
> When I execute this report I get the following error: "The report
> parameter 'State' has a DefaultValue or a Valid Value that depends on
> the report parameter 'ConnectionString'. Forward dependencies are not
> valid."
>
> If the single data source for the report gets its connection
> information dynamically, is there any way to have a second dataset
> depend on that data source? If not, how can I make the data source
> for that second dataset dynamic also?
>
> Thanks in advance.
>
> Rich

Bruce,

I think that got me a step closer but I'm not quite there. If I make
the change you suggested the report works now in the SSRS portal
(provided that I manually populate the connection string parameter).
In reality, I'll be running the report through the .NET Report Viewer
and passing that connection string dynamically in code. When I do
that now the states list is populated as expected so it looks like it
is getting the correct database connection information, but when I
attempt to execute the report nothing happens. I do see a JavaScript
error in some system-generated code:

*****

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/
4.0; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR
3.0.04506.30; MDDR; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729;
InfoPath.2; MS-RTC EA 2)
Timestamp: Wed, 9 Sep 2009 18:35:00 UTC


Message: 'document.getElementById(...).ParametersController ' is null
or not an object
Line: 6
Char: 71
Code: 0
URI: https://[address]

*****

Any ideas? Thank you again for the help.

Rich


On Sep 9, 9:09*am, "Bruce L-C [MVP]"
wrote:
> You need to have the parameter used for the connection string come before
> the parameter for State. Just change the order of the parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "SQL Dude" wrote in message
>
> news:faccd397-0d9d-4ebb-beec-954a041da624@f10g2000vbf.googlegroups.com...
>
>
>
> > I have a report for which the connection string for the data source is
> > passed in dynamically as a parameter to the report. *This report has a
> > second input parameter (e.g. state) for which the dataset is also
> > retrieved from the database. *The data source for the states dataset
> > is the same data source which gets its connection string
> > dynamically.
>
> > When I execute this report I get the following error: "The report
> > parameter 'State' has a DefaultValue or a Valid Value that depends on
> > the report parameter 'ConnectionString'. *Forward dependencies are not
> > valid."
>
> > If the single data source for the report gets its connection
> > information dynamically, is there any way to have a second dataset
> > depend on that data source? *If not, how can I make the data source
> > for that second dataset dynamic also?
>
> > Thanks in advance.
>
> > Rich

My experience with the report viewer in server mode (I assume that is how
you are using it) is that I get the same results as I would via report
manager. It is confusing because you are getting your parameter filled in
with the dataset which is dependent on the connection string. I don't really
see what is the problem.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Rich" wrote in message
news:f28ae7de-399a-4669-aad2-54c51fd668ae@o9g2000yqj.googlegroups.com...
> Bruce,
>
> I think that got me a step closer but I'm not quite there. If I make
> the change you suggested the report works now in the SSRS portal
> (provided that I manually populate the connection string parameter).
> In reality, I'll be running the report through the .NET Report Viewer
> and passing that connection string dynamically in code. When I do
> that now the states list is populated as expected so it looks like it
> is getting the correct database connection information, but when I
> attempt to execute the report nothing happens. I do see a JavaScript
> error in some system-generated code:
>
> *****
>
> Webpage error details
>
> User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/
> 4.0; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR
> 3.0.04506.30; MDDR; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729;
> InfoPath.2; MS-RTC EA 2)
> Timestamp: Wed, 9 Sep 2009 18:35:00 UTC
>
>
> Message: 'document.getElementById(...).ParametersController ' is null
> or not an object
> Line: 6
> Char: 71
> Code: 0
> URI: https://[address]
>
> *****
>
> Any ideas? Thank you again for the help.
>
> Rich
>
>
> On Sep 9, 9:09 am, "Bruce L-C [MVP]"
> wrote:
>> You need to have the parameter used for the connection string come before
>> the parameter for State. Just change the order of the parameters.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "SQL Dude" wrote in message
>>
>> news:faccd397-0d9d-4ebb-beec-954a041da624@f10g2000vbf.googlegroups.com...
>>
>>
>>
>> > I have a report for which the connection string for the data source is
>> > passed in dynamically as a parameter to the report. This report has a
>> > second input parameter (e.g. state) for which the dataset is also
>> > retrieved from the database. The data source for the states dataset
>> > is the same data source which gets its connection string
>> > dynamically.
>>
>> > When I execute this report I get the following error: "The report
>> > parameter 'State' has a DefaultValue or a Valid Value that depends on
>> > the report parameter 'ConnectionString'. Forward dependencies are not
>> > valid."
>>
>> > If the single data source for the report gets its connection
>> > information dynamically, is there any way to have a second dataset
>> > depend on that data source? If not, how can I make the data source
>> > for that second dataset dynamic also?
>>
>> > Thanks in advance.
>>
>> > Rich
>

Me either, Bruce. When I run it in the SSRS portal it looks like this
is what is happening:

1. I manually enter the database connection string and click on the
states drop down list.
2. The screen refreshes.
3. The states list is populated.
4. The report can be executed as expected.

It doesn't behave this same way when run through the viewer. I wonder
if something in going wrong when the screen refreshes.


On Sep 9, 3:13*pm, "Bruce L-C [MVP]"
wrote:
> My experience with the report viewer in server mode (I assume that is how
> you are using it) is that I get the same results as I would via report
> manager. It is confusing because you are getting your parameter filled in
> with the dataset which is dependent on the connection string. I don't really
> see what is the problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Rich" wrote in message
>
> news:f28ae7de-399a-4669-aad2-54c51fd668ae@o9g2000yqj.googlegroups.com...
>
>
>
> > Bruce,
>
> > I think that got me a step closer but I'm not quite there. *If I make
> > the change you suggested the report works now in the SSRS portal
> > (provided that I manually populate the connection string parameter).
> > In reality, I'll be running the report through the .NET Report Viewer
> > and passing that connection string dynamically in code. *When I do
> > that now the states list is populated as expected so it looks like it
> > is getting the correct database connection information, but when I
> > attempt to execute the report nothing happens. *I do see a JavaScript
> > error in some system-generated code:
>
> > *****
>
> > Webpage error details
>
> > User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/
> > 4.0; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR
> > 3.0.04506.30; MDDR; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729;
> > InfoPath.2; MS-RTC EA 2)
> > Timestamp: Wed, 9 Sep 2009 18:35:00 UTC
>
> > Message: 'document.getElementById(...).ParametersController ' is null
> > or not an object
> > Line: 6
> > Char: 71
> > Code: 0
> > URI:https://[address]
>
> > *****
>
> > Any ideas? *Thank you again for the help.
>
> > Rich
>
> > On Sep 9, 9:09 am, "Bruce L-C *[MVP]"
> > wrote:
> >> You need to have the parameter used for the connection string come before
> >> the parameter for State. Just change the order of the parameters.
>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
>
> >> "SQL Dude" wrote in message
>
> >>news:faccd397-0d9d-4ebb-beec-954a041da624@f10g2000vbf.googlegroups.com....
>
> >> > I have a report for which the connection string for the data source is
> >> > passed in dynamically as a parameter to the report. *This report has a
> >> > second input parameter (e.g. state) for which the dataset is also
> >> > retrieved from the database. *The data source for the states dataset
> >> > is the same data source which gets its connection string
> >> > dynamically.
>
> >> > When I execute this report I get the following error: "The report
> >> > parameter 'State' has a DefaultValue or a Valid Value that depends on
> >> > the report parameter 'ConnectionString'. *Forward dependencies arenot
> >> > valid."
>
> >> > If the single data source for the report gets its connection
> >> > information dynamically, is there any way to have a second dataset
> >> > depend on that data source? *If not, how can I make the data source
> >> > for that second dataset dynamic also?
>
> >> > Thanks in advance.
>
> >> > Rich