I'm tearing my hair out…
I have a simple report that pulls data from just one table. There is a pivot table and chart on another tab in the spreadsheet.
The problem is that whenever I hit the "report" or "refresh" button in Jet the data source for the pivot table stops pulling from the whole report and reverts every time to just the headings and top line of data.
I want to schedule this report to run automatically but there seems little point if this won't work.
Anyone got any clues?
Matthew
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi Matthew,
The best way to get data for constructing a pivot table is to use the NL(Table) function. You can actually use the Table Builder tool to construct your NL(Table) formula which makes this easy. This will create an Excel table with a name, which you can then reference in your pivot table. Since the Excel table keeps the same name between report runs, this makes the pivot table keep its reference to the data. Does this work for you?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes
Unfortunately I've had to go back to our developer on this one. The table concerned is of his creation and Jet doesn't seem to be able to see the fields in order for me to apply a filter in Table Builder.
I'll take a look at it later once I've spoken to him.
I'm running into brick walls everywhere I turn at the moment!
Cheers
Matthew -
Jet Reports Historic Posts Hi Matthew,
Not having the fields for a table appear in the Table Builder sounds like an issue in an early version of Jet that has been fixed. Possibly you just need to upgrade to the latest version of the Jet software, and it will be fixed. It could also be that you have "Favorites" enabled in the Table Builder, but that table or its fields are not favorites.
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes
I sorted this out by pulling all the data into the pivot table but selecting only the two fields that I wanted. Oddly this resulted in both those fields staying put when I reran the report.
Not sure why but as it works I'm not going to complain!
cheers
Matthew
Please sign in to leave a comment.