I have a Report where i group on a value named "Period".
For each Period in the main/parent report i need 2 sub reports to be filtered with the value Period from the Main/parent report.
The problem is that is only need the TOP 10 records to be showing in both sub reports.
As recordsource in the sub reports i have been trying to have a SQL like this:
Select Top 10 * from table_a.
But when i the filter the sub report with the Period value=1 i only get the values from the TOP 10 where Period=1.
Example before filter:
Then after i filter the sub report i get:
I hope this makes sence and that some one can help me.