Group in a table

Questions and Answers asked by users to users, about how others use Jet Reports.

For additional "how to" information, please visit our online Knowledge Base https://jetsupport.jetreports.com/hc/en ... ofessional
Forum rules
The Jet Reports Community forums are not a guaranteed support medium. Official support for Jet Reports is available only through the support desk at http://support.jetreports.com. Staff responses to posts on the forum are not guaranteed.
ap1303
Posts: 1
Joined: Mon Mar 27, 2017 9:22 am

Group in a table

Postby ap1303 » Tue May 16, 2017 4:02 am

Hi

I am new to the table builder function and trying to figure my way around it.

I was wondering if anyone knows if it is at all possible to apply a group in a table? I have pulled out a list of customers and their orders and I want to group on the customer number. I know it is possible to put the information into a pivot table but wondered if there is a way to put it directly into the table?

Many thanks
Amy

User avatar
HPDeskJet
Jet Reports Certified Professional
Posts: 442
Joined: Wed May 26, 2010 3:40 pm

Re: Group in a table

Postby HPDeskJet » Tue May 16, 2017 8:16 am

Hi Amy -

The NL(Table) function is design to do just that... create an Excel table that can then be manipulated using Excel's pivot capabilities.

For grouping, you would want to build a grouping report such as described in the Grouping Reports videos
-HP
_______________________
Jet 2015 Certified Trainer


Return to “How do I?”

Who is online

Users browsing this forum: Bing [Bot] and 2 guests