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 ... 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 Staff responses to posts on the forum are not guaranteed.
Posts: 1
Joined: Mon Mar 27, 2017 9:22 am

Group in a table

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


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

User avatar
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
Jet 2015 Certified Trainer

Return to “How do I?”

Who is online

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