Hi,
When I use the table builder The table is colourd Jet reports - blue. Can I change the colour of the table?
When I add a column in table builder with formula =Today(), the date in the table builder is a number and not a date. Can I change that?
Is it possible to set a € format to the cell amount. The format of these cells are "standard".
Kind regards,
Saskia
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi,
1) Yes you can change the color of the table after you run the report, but it will go back to the default table color the next time you run the report, so practically the answer is no. This is because the table actually gets destroyed and recreated when the report is run. There isn't currently any way to tell the NL(Table) function what formatting to use.
2) You could use the Excel TEXT function to format the date like this: =TEXT(TODAY(),"MM/DD/YYYY")
3) The answer is the same as for number 1 above.
Regards,
Hughes -
Jet Reports Historic Posts With #1 there is actually a way to change the table style (colors) prior to running the table - as long as the report is saved in an Excel workbook (which I was very glad to find).
1. Design your report - and run it at least once to test the outcome.
2. Once you are happy with your design, go to the Table Tools tab in the Excel ribbon, and select the table style you want. (You need to have a table showing on the workbook for this tab to be available, so don't reset your report to design mode just yet.)
NOTE - you can design your own table style if you want, there are several help guides that you can Google for how to design a new style.
3. Right-click on the table style from the menu, and select "Set as Default"
4. Reset the report to Design, and save your workbook.
Now every time you open this report (from the saved workbook), your table colors will be what you chose as the default.
I believe (but have not tested) that this setting would stay from user to user as long as they are opening copies of the same file.
Default table style is default only to the document it is in, not default to your entire Excel set up.
Please sign in to leave a comment.