cross-tabulating reports

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
jtenbrook
Posts: 7
Joined: Tue Oct 10, 2017 12:44 pm

cross-tabulating reports

Post by jtenbrook » 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?

Post Reply