Table Builder

Questions and Answers asked by users to users, about how others use Jet Express.

Table Builder

Postby Cor111 » Tue Jan 24, 2017 6:54 am

If you create and run a Jet Express report - is there a way of going back to edit the report using Table Builder for example to add extra fields
Cor111
 
Posts: 4
Joined: Tue Jan 24, 2017 6:43 am

Re: Table Builder

Postby HPDeskJet » Tue Jan 24, 2017 7:47 am

Hello -

In recent version of Jet Express, you have the option to save the Table Builder template when you are done creating your design:

sample_table_builder.png
sample_table_builder.png (60.05 KiB) Viewed 504 times


You can then go back into Table Builder and open that template from the File menu:

file_menu.png
file_menu.png (6.53 KiB) Viewed 504 times


-HP
HPDeskJet
 
Posts: 171
Joined: Tue Sep 06, 2011 9:20 am

Re: Table Builder

Postby Cor111 » Tue Jan 24, 2017 8:22 am

Thank you thats brilliant

Do you have an idea if you can take a date formula and add eg 8 days
original date 01/01/2017 new date calculated 09/01/2017
Cor111
 
Posts: 4
Joined: Tue Jan 24, 2017 6:43 am

Re: Table Builder

Postby HPDeskJet » Tue Jan 24, 2017 8:34 am

While that would be easy to do with Jet Professional, formulas are not available in Jet Express:

tb_formulas.png
tb_formulas.png (83.96 KiB) Viewed 502 times
HPDeskJet
 
Posts: 171
Joined: Tue Sep 06, 2011 9:20 am

Re: Table Builder

Postby Cor111 » Tue Jan 24, 2017 8:42 am

OK Thanks

Last question -
If you add a field in the excel spreadsheet eg called comments and enter data for each row, when you press refresh it deletes all the added data - is there a way of only refreshing the nav data on the spreadsheet?
Cor111
 
Posts: 4
Joined: Tue Jan 24, 2017 6:43 am

Re: Table Builder

Postby HPDeskJet » Tue Jan 24, 2017 10:30 am

The option you would have for accomplishing that would be to copy the resulting Excel table, paste it on a new sheet, and add your comment to that new sheet.

Then, when you refresh the report, you could re-copy/paste to the sheet which already has your comments.
HPDeskJet
 
Posts: 171
Joined: Tue Sep 06, 2011 9:20 am

Re: Table Builder

Postby Cor111 » Wed Jan 25, 2017 3:27 am

Thank you for your help - much appreciated
Cor111
 
Posts: 4
Joined: Tue Jan 24, 2017 6:43 am


Return to Ask the Community

Who is online

Users browsing this forum: Google [Bot], Yahoo [Bot] and 1 guest