0

How do I use Report Builder to create pivot tables?

Jet Reports Historic Posts

November 19, 2014 15:39

None

Follow

Hello. First time posting in this forum, hope I am doing this correctly.

When I use Report Builder and associated data views the NL statement includes (What = "Rows"). I need to take that data and turn it into an Excel pivot table that will automatically refresh every time I reopen the file. However, the Jet Reports knowledgebase says in order for pivot tables to refresh, use NL (What = "Table"). Is it possible to use the Report Builder to create tables instead of rows of data? What am I missing? Thank you.

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts November 19, 2014 21:41 Official comment

  The report builder is for building reports and it does so using standard NL(rows), NL(first), etc.
  
  If you goal is to build an NL(table), you either need to create your function using the jFX or by using the Table Builder instead.
  
  The Table Builder builds an NL(table) function. http://kb.jetreports.com/article/AA-00780

• 0
  
  Jet Reports Historic Posts November 20, 2014 18:27

  Thank you very much!