Forum Discussion
Paginated Report - Stop Grouping
Hi CEllis ,
Uncheck this box to see two records without deleting the group:
Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi CEllis
This is because by default, when using paginated reports, it automatically groups the data. Here is a link where it will show you how to remove the grouping to show all the rows as expected. How to remove Grouping after report is built? – SQLServerCentral Forums
Hi GilbertQ
The properties doesnt show the tab grouping from the post steps.
'I assume that the report is using a Table, if so, click on the table to select it, then right click and select properties. In the properties window select the groups tab and in here you can remove all the groups just by highlighting and removing.'
Many thanks
Chris
Thanks for the reply form GilbertQ.
Hi CEllis ,
This feature is here:
By th way, you can uncheck this option when creating the table and it will expand the group:
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi GilbertQ
When I delete the detail group it only shows 1 record when I preview it.
Many thanks
Chris
Hi CEllis ,
Uncheck this box to see two records without deleting the group:
Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.