As per the request , i have to generate reports for 16 weeks.I am grouping the data for every week and displying the date for 16 weeks using 'ACROSS'.But here for some weeks there is no data,so these weeks do not display on the report.i want to display these weeks ,and put the value as zero for this.

This message has been edited. Last edited by: Kerry,

Adithya,

You can use:
ACROSS week COLUMNS 1 AND 2 AND ... AND 16
if your weeks are numbered from 1 to 16.
If not, use thew values for the 16 weeks of your week field.