[Closed] Filtering data before pulling it in the report

[maverick_hs]

Hi,

I have a table T which joins to six tables (F1 to F6) and to six other tables (D1 to D6). For each record in T I have a corresponding record in each of the D tables and 10 records in each of the F tables. There is no relationship between the F tables. For each record in T, I want to pull a value from D1 and then based on D1 pull ONE record from F1. Similarly for F2 to F6. Right now when I make the joins and apply the filters, for each record in table T, my report pulls 10 records from F1, 10 from F2 and so on and then applies the filter. ReportNet applies the filter to the 10 records as a whole. I want to have the filter separately on the information that i get from the six F tables. i.e. to say, I might want row 3 from F1, but row 5 from F2 and so on, which row I need from a F table depends on the value in the D table.

I really hope there is a way to do this in ReportNet...

I appreciate any suggestions/comments,

Thanks

[sir_jeroen]

So you have already a "non-Reportnet" sql statement that does what you need?
I don't know the solution (as I can't get the picture :S ) But you could alway try it using a SQL Tabular model in which you paste your sql statement directly. Maybe that works.

[mallika]

explain your requirement with mock data in T, D tables and F table and required report output if possible..

[maverick_hs]

Well, I changed the table structure so that I only have one row corresponding to each record in the main table. So, I guess, this case can be considered closed.