Hi,
I want to create a report with the excel data grouping functionality in it.
This works fine. But how do i get this data grouping to be dedault collapsed after running the Jet Report.
Gr Mark Peeters
4 comments
-
Jet Reports Historic Posts Official comment I got it working by placing deleting the datagrouping and placing it again.
Dont know what went wrong but it works. Tnx for the help.
Mark -
Jet Reports Historic Posts Hi Mark,
You mean Excel grouping combined with an NL(Rows) replicators?
Let's say your group replicator is 4 rows:
- in design mode select row 2, 3 and 4;
- select Excel ribbon Data -> block Outline -> Group
Does it work? -
Jet Reports Historic Posts Hi Mark,
Excel grouping should always get collapsed during a report run. To test this, I created a report using the Report Wizard. At the end of the Report Wizard there is an option you can check to add Excel outlining/grouping to the report. Then when I run the report, all the groups are collapsed. Is this not the case for you?
Regards,
Hughes -
Jet Reports Historic Posts Hans and Hughes thanks for your replies.
Hughes,
I know that it works the way i want when i use the wizard.
Mij problem is i allready have the report en now want to add the excel data grouping the way Hans is discribing.
All works fine but after report run it is not collapsed the way it is when you run the wizzard.
So my question how do i take care of the collapsing after running the report if i ad the excel data grouping manually.