cross-tabulating reports
Posted: Tue Jul 17, 2012 9:54 am
aFor the purpose of this report I need to export in cross-tabulated format. With a column for each month. The only way I can get this to work is to set up a calculation for each field. ____JuneName: iif(NameMonth=^June^,TrimLeft,^ ^)__JulyName: iif(NameMonth=^July^,TrimLeft,^ ^) ____With the report____Junename | JulyName| etc.____The issue is I get blank lines in each column due to the ^ ^ ____Is there any way to get this to work?