Hi,
I'm developing a report in AA to mimic an excel currently used by my customer. I've defined the report as a tabular report, and have a button on a grid detail view to export it to excel using the advanced export action.
After struggling for some time to fully understand how variables are used in reports (initially I though I could set a variable in the onrecord event, and have it display field values from another table - I realized it doesn't quite work this way; seems a variable is a single instance - the setting of the variable in a subsequent onrecord event will change the value previously written to a cell in the report!). Anyway, managed to overcome this problem by setting some triggers on the table to update fields in the main table.
Which leads me to my next set of problems:
1. I can't find any way of setting the format of the cells in the created excel. I have some columns in the report definition which are formatted as currency values. However, when the excel is created, all the cells seem to be created as 'General' format. Is there a way to format cells as 'currency' or any other non-general format ?
2. I have borders around each of the cells. This seems to work fine in preview mode. However, when I generate the excel, the borders don't appear around cells with 'null' values. Is there a way to always generate borders, regardless of whether the cell contains a value or not ?
3. I think the answer to this is no, but I'll ask the question anyway. The customer report is multi-tabbed (it has 4 sheets which contain different filtered views of the records). Is there a way to create a multi-tab excel ? The only way I can think of doing it is to create multiple copies of the report definition, each with different filters, and generate 4 excel files. Then use a macro in one of the excels to combine them together. Anyone have a more elegant solution ?
Cheers,
greg
I'm developing a report in AA to mimic an excel currently used by my customer. I've defined the report as a tabular report, and have a button on a grid detail view to export it to excel using the advanced export action.
After struggling for some time to fully understand how variables are used in reports (initially I though I could set a variable in the onrecord event, and have it display field values from another table - I realized it doesn't quite work this way; seems a variable is a single instance - the setting of the variable in a subsequent onrecord event will change the value previously written to a cell in the report!). Anyway, managed to overcome this problem by setting some triggers on the table to update fields in the main table.
Which leads me to my next set of problems:
1. I can't find any way of setting the format of the cells in the created excel. I have some columns in the report definition which are formatted as currency values. However, when the excel is created, all the cells seem to be created as 'General' format. Is there a way to format cells as 'currency' or any other non-general format ?
2. I have borders around each of the cells. This seems to work fine in preview mode. However, when I generate the excel, the borders don't appear around cells with 'null' values. Is there a way to always generate borders, regardless of whether the cell contains a value or not ?
3. I think the answer to this is no, but I'll ask the question anyway. The customer report is multi-tabbed (it has 4 sheets which contain different filtered views of the records). Is there a way to create a multi-tab excel ? The only way I can think of doing it is to create multiple copies of the report definition, each with different filters, and generate 4 excel files. Then use a macro in one of the excels to combine them together. Anyone have a more elegant solution ?
Cheers,
greg
Comment