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.
Date
Votes
2 comments
-
Jet Reports Historic Posts 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 -
Jet Reports Historic Posts Thank you very much!
Please sign in to leave a comment.