Adding blank rows in Cross-tab

[Dukester0122]

I'm creating a cross-tab in CR 8.5 and want to add blank rows so if I export to Excel I could add the numbers manually.

This is for forecasting of our items. Here's an example:
Rows/Columns Jan03 Feb03 Mar03
Item A - Sales 10 15 20
Demand Forecast(blank)

 

[lbass]

You can create blank space for Demand Forecast by creating a formula:

whilereadingrecords;
""

Add this as a second summary field, and choose "Maximum" as the summary. This will create an extra row when exported to Excel. However, I was unable to get the corresponding row label "Demand Forecast" to export successfully, although I was able to get an accurate display within CR, by customizing the group name for the Item field using a formula:

{table.Item}+chr(13)+"Demand Forecast"

-LB