Does anyone know of a way to create variable headings in ReportNet? I'm trying to create an AR report and the requestor wants the colums to be months old but instead of saying month 1, month 2, month 3, etc, they want to see April, February, January, etc. Theses column headings should change every month as 1 month old will be different when the report is run at the end of each month. Any ideas or suggestions would be greatly appreciated!
Thank you!!!
pepper
Add a Table to the Report and Create Calculated Columns with if or case statements.use syntax current_date -1..
Hope it helps you
Add a query item to query that drive your list report, called "Month" (or something).
Define the query item as (extract(month, [date])).
Then, click on the report column heading and add "Month" to Report Expression on the properties pane.
HTH. Keep us posted.