Use a dataset from another dataset

Hi,
I don't know if is it possible. I want create 2 dataset. In one of them i want filter some information accord to parameters value, and in another hand i want to use the first dataset like a datasource. Is it possible?
Thanks in advance.

Find more posts tagged with

Comments

mwilliams

Hi knight,

I don't think you'll be able to use the other dataSet as a dataSource, but what are you trying to do with this second dataSet? If you're just displaying the data in a table, you can do the filtering on the table. Let me know.

knight

Hi Michael,
I've a dataset created with a select .... from (select.. from.. where.. group), so the second query is big, and depending of report parameter may change (I'm using beforeOpen script), as result the query it's not so clear. So i want to separate it in 2 parts.
If it's no possible, no problem. Just I wont to know if exist a more elegant way to resolve this.
Thanks.

mwilliams

knight,

I'm thinking the way you have it now, with one query is going to be the way to do it.