Dynamic Report using Cross Tab query

  • Thread starter Thread starter Rey
  • Start date Start date
R

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.
 
Rey said:
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.
Click to expand...


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.
 
Back
Top