Dynamic Report using Cross Tab query

[Rey]

Hello,

I have a report built on a cross tab query. I'm tracking exceptions
by employee weekly. So at the end of the week an employee has a total
number of exceptions. My crosstab returns employees and total
exceptions by week. How can I setup the report so that the text boxes
populate as weeks go by. Currently, future weeks don't show up in my
crosstab query, because there is no data.

 

[Marshall Barton]

I have a report built on a cross tab query. I'm tracking exceptions
by employee weekly. So at the end of the week an employee has a total
number of exceptions. My crosstab returns employees and total
exceptions by week. How can I setup the report so that the text boxes
populate as weeks go by. Currently, future weeks don't show up in my
crosstab query, because there is no data.

Calculate a relative week number based on some base date
(e.g. today's date), Thenthe report can use fields like
week 0, week -1, etc.

You can then use the query's Headings property to specify
which weeks to display whether there is any data or not.