Hi. I have created a table with "Table Creator" and now I need to add new fields to the query, but i don't know how to show again the "Table Creator" with that query. Is it posible to edit the table or should I create the table again in order to include my changes?
Date
Votes
6 comments
-
Jet Reports Historic Posts Hi sgregorio,
Once you create the table with the Table Builder you cannot go back into the Table Builder to edit the report you just created. You have 2 ways of making your changes. (1) You can restart the Table Builder and recreate the report with your new changes, or (2) you can edit the existing report using the Jfx.
I hope this helps! -
Jet Reports Historic Posts Hi Sgregorio,
The Table Builder feature can be used for creating reports, but is not an editer.
Depending on the complexity of your report you may be successful in editing the report in Excel-
If you want to add a field from your 'base table' (meaning the very first table you selected) it is very easy -
There are horizontal lists of "headers" and 'fields' created by the table builder. Each of these represents a column in the table that is returned. If you insert a column in this list you can type in the name of the new header and field that you want.
The 'header' is what you want shown in the top row of the table.
The 'field' is the field name in NAV - this must exactly match your database.
If you want to add a field from a related table that you included using the Table Builder the process is nearly identical but-
Instead of typing the name of the field you will want to use the "Function Wizard" to create the field name. Start in the cell where you want the field to be, click the "Function WIzard" icon, then by clicking the 'lookup arrow" in the wizard select "Linkfield" for "What", and then select the name of the related table and field that you want included in your report.
If your modifications are more extensive than this you will probably want to just create a new report using the Table Builder. -
Jet Reports Historic Posts Do I understand this correctly?
If for example, I have designed a report linking 5 tables together, and then a few weeks later I get a request to add in a 6th table. Would I really have to start again from scratch?
If so this seems like a very limiting factor. -
Jet Reports Historic Posts Hi Collo,
It is always possible to change a report to add or modify tables and fields using the Jfx functions. Its just a matter of what is the easist/fastest approach for doing so.
In general I've found that when adding a related table that it is easier to use the Table Builder interface to create a fresh report than to modify an existing report. The Table Builder interface automatically creates the linking between tables (when possible) and helps me ensure that I don't create typos when entering field names.
I jot down the tables, fields and filters that are in a report and can usually recreate the report in a minute or two.
Steve -
Jet Reports Historic Posts I agree with Collo—this seems ridiculous. I admit I don’t know how to use the Jfx tool at this point, but after building my very first table, it wasn’t even two minutes before I was looking for the ability to tweak my table in the Table Builder tool.
Does anybody know if Jet Essentials and Jet Enterprise offer this ability? -
Jet Reports Historic Posts Hi Collo & Sgregorio,
Greatly appreciate your input and feedback.
We're looking into developing a feature to save a template of your report so that you can modify it using the Table Builder.
Regards,
Steve
Please sign in to leave a comment.