December 5, 2008 at 7:29 pm
Being a newbie, this may sound stupid.
My question is this.
I have two datasets, each using a different datasource.
@customerid parameter is entered by the user in one of the datasets to be used to filter output.
Can I, and if so how, use the same value of @customerid in the second dataset to search the other database? Is there a way to pass it over?
Thank you in advance.
To give an example. User is asked for customerid.
I use customerid to query a table in dataset1 which uses datasource1 (database1)
But, I also want to use the same value of customerid in dataset2 which uses datasource2 (database2).
How do I get this value into dataset2?
December 8, 2008 at 9:03 am
report parameters are global, so just reference it in the other dataset.
December 8, 2008 at 9:05 am
Thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply