Skip to Content
Former Member
May 24, 2010 at 08:24 PM

Default Report Templates ex: Trend



I have quick question of default or SAP given report Templates. How to use these templates? Assume based on my current view i have 10 accounts in rows and 4 measures in Columns (1st quarter). it is going to be around 40 cells in my report to display data.

do i need to use EvSnd() statement in all the 40 cells? If i refresh my query these 40 cells getting refreshed. Every time i need to enter 40 cells in my report. I know i was not doing right. Can any one guide me to display all the cells after refresh the work books as well.

How to dynamically populate the cell definition for all cells imean to say if i use 2006.TOTAL for measure which will give me 130 cells. how to dynamically pass the EVSND() function?

Appreciated all your help!!!