Hi,
Imagine this report:
Column A: Lists Countries (e.g. USA, CAN, etc.)
Column B: Lists States (e.g. Illinois, Arkansas, California, and other country's states)
Column C: Lists Cities (e.g. Chicago, Houston, and other countries cities)
I've grouped columns A, B, and C separately. I have a query that totals the number of entries for each column.
My total, when added to the report page, the naming is simply duplicated when exported.
For example for the Column A Group, the total appears as Total Entries
For Column B group, the total appears as Total Entries (2)
For Column C group, the total appears as Total Entries (3)
Each of these Total Entries are corresponding to their group (as they should) but is there a way to rename them so it's not just (2) and (3)? Could I perhaps rename them to 'Total Entries by Country', 'Total Entries by State', 'Total Entries by City'?
Is this possible? Will I need to make separate queries named as such for each one of these?
Thanks!
Quote from: t0mato on 12 Aug 2020 03:03:03 PM
Hi,
Imagine this report:
Column A: Lists Countries (e.g. USA, CAN, etc.)
Column B: Lists States (e.g. Illinois, Arkansas, California, and other country's states)
Column C: Lists Cities (e.g. Chicago, Houston, and other countries cities)
I've grouped columns A, B, and C separately. I have a query that totals the number of entries for each column.
My total, when added to the report page, the naming is simply duplicated when exported.
For example for the Column A Group, the total appears as Total Entries
For Column B group, the total appears as Total Entries (2)
For Column C group, the total appears as Total Entries (3)
Each of these Total Entries are corresponding to their group (as they should) but is there a way to rename them so it's not just (2) and (3)? Could I perhaps rename them to 'Total Entries by Country', 'Total Entries by State', 'Total Entries by City'?
Is this possible? Will I need to make separate queries named as such for each one of these?
Thanks!
Hi,
Any item you define has both a name and a label. If you select the item on the report page, and open the Properties pane, you should see both. What are they currently set to?
MF.