Miss column cause by Group in table

[wang alex]

  Like Demo Product sales per period,  2001 Q1 and 2001 Q2 column miss beause there is no record in 2001.1-2001.6.
  If i still want to show the column, but just zero. How can i do?

[Steve]

Hi wang,

The CrossTab/Table items are view over your data i.e. we group your data and based on that create the layout. If there is no data, then there would be no layout created for that group. In other words, you should alter your data, so that there is at least one record returned for a group, so that we can create a column/row group for you and then if you want you can write appropriate expression to modify the data to show zero, N/A etc.

Regards,
Steve
the Telerik team