If I add a pivot table to my Jet report it doesn't refresh after running the report. The pivot table only shows the first line of the data (NL;Rows;…)
Version: Excel 2010
Jet 12.0
Nav 2009
How can I create pivot tables (incl. slicers) that will show the correect data?
Kind regards,
Saskia Kuijer
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment Hi Saskia,
To add some extra columns with or without a formula, you have to click on Add Formula on the bottom of the table builder box.
And if you want to add some filters, you have to click on the table name and then on the right you can add filters. See my print screen attached.
Does this help?
Regards,
Bert -
Jet Reports Historic Posts I'm assuming you are using NL(Table) in Jet, is that correct? Did you add a "TableName=" filter so that the table has a unique name? In order for the pivot table to continue to be hooked up to the Excel table, you have to give the table a name. Otherwise, the table name will change with each report run and the pivot table will lose its connection to the data. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
I did not add a table name.
My Jet Report formula: =NL("Rijen";"Ledengroepsamenstelling") –> translated: NL("Rows";"Table 50.018")
I tried to add a table name in designer mode: Excel: Formulas - Define names and selected 2 rows.
After running the report the named range is only 2 rows, and not the complete table.
"How can en where do I add a Table name= filter?
Kind regards
Saskia -
Jet Reports Historic Posts Hi Hughes,
I know what you mean. Problem solved…almost..
One last question, with table builder i can report data out of several tables. Is it possible to add some extra Excel columns in the table; I'd like to put some Excel funtions in the table. For example: in the table builder I select field age actual out of the contact no. table. In Excel I'd like to group them (20-25 years; 25-30 years, etc.) in a seperated column.
Further I'd like to use an Excel function: If the value in a cell is … then show True or else False. –> I'd like to add some extra columns in the table. Is that possible?
And final question: is it possible to run the table on basis of filters? (For example date filter?
Looking out to hear from you.
Kind regards Saskia
Please sign in to leave a comment.