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 ,
Here are some steps you can follow :
1. Add survey response to both the table
2. Create a group on survey response (both the tables)
3. Add a page break between each group by selecting option "Between each instance of a group" under row group properties
Please note, survey response should be a filter to both the tables
It should solve your issue.
Did I answer your query ? Kindly mark this as solution if this helps .
Cheers
Hi @divyed ,
Thanks for the response! Just to clarify, the page break should happen on negotiation issue, not survey response. Are the instructions still the same above? Survey response is only a field on one of the fact tables, while negotiation issue exists in both and is selected via a DIM table value set as a parameter.
I did try using your logic above with negotiation issue, but it is still splitting up the page breaks (doing all of site notes first and then all of survey responses second).
Below is what it should look like (grouped on company strategy, in this case I've selected one, but if I selected multiple issues, it should keep them on a page together before page breaking to the next one):
but this is what I get when I do the page break between each instance of the group (and have multiple issues selected:
It breaks up the site notes and survey responses on different pages.
Hello jbarker95 ,
Yes logic will be same. As you have 2 parameters to filter the tables,use both parameters in group by and it should work. Logic and steps will be same.
I hope this helps.
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!