Hi guys,

I've created a sales nested report to be used in multiple DWs. It's a nested with grand totals, This nested has a "sub" nested that shows payments forms (so it's a nested inside a nested).

So far so good. The thing now is that the main DWs that use this nested (regular DWs with the nested dw on the summary band) will have additional functionallity (filter options to be precise).

My questions are: which option do you suggest, and how to code it?
Option 1: My first choice: dinamically alter the nested, adding a "where clause" to re-retrieve the nested data;
Option 2: Filter the nested dw (that will be a bit more complex, because the nested doesn't have the columns to filter, so I'll have o change the nested to bring all data and use computes)
Option 3: something I haven't thought of;

And how would I go around coding it? GetChild won't do, they are not composite. How I'd get around re-retrieving or filtering the nested and sub-nested?

Thanks a lot.

Daniel