Forum Discussion
Page Break on Common Field with Two Tables
Hello jbarker95 ,
You can try this method if still having issues with previous method . I have tested as well and working fine.
1. Add parameters to your report and populate using datasets as usual
2. Go to report designer => Add a list
3. Place 2 tables (which you want to show on each page) within the list and populate using fact tables . Please note , It should have columns from parameters like in previous method
it should look like
4. Click on List (not on tables) , go to details and add a row group . Pass your multivalued
parameter in the group
5. Go to group properties and add page break between each instance of group.
It will work and will give desired result.
Example :
I have two paremeters for Category and Subcategory where subcategory is multi valued.I have passed subcategory as group and here are the result:
Cheers.
Hello jbarker95 ,
You can try this method if still having issues with previous method . I have tested as well and working fine.
1. Add parameters to your report and populate using datasets as usual
2. Go to report designer => Add a list
3. Place 2 tables (which you want to show on each page) within the list and populate using fact tables . Please note , It should have columns from parameters like in previous method
it should look like
4. Click on List (not on tables) , go to details and add a row group . Pass your multivalued
parameter in the group
5. Go to group properties and add page break between each instance of group.
It will work and will give desired result.
Example :
I have two paremeters for Category and Subcategory where subcategory is multi valued.I have passed subcategory as group and here are the result:
Cheers.
Lists is exactly what I was looking for, thanks!