quarter problems?!?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Recently i made report based on crosstab query,
Columns represent quarter of year in conjunction with data about expenses.
Problem is that crosstab query, i mean Report in connection with that query
works only if there is inputs for each quarter of year.
Off course that i can make blank input for each quarter, and calculation
will be correct.
But is there any smarter solution because that blank record will be in all
reports,
and i don't want it. Is there any code in reports to remove blank records
based on blank field?
Thx in advance
 
Yes, by predefining the columns in the PIVOT line like this ---
PIVOT YourField IN(1, 2, 3, 4)
This is if your normal output columns are labeled 1, 2, etc. otherwise use
the same as it outputs. Of course enclose text in double quotes like this ---
PIVOT YourField IN("QTR 1", "QTR 2", "QTR 3", "QTR 4")
 
SoulReaver said:
Recently i made report based on crosstab query,
Columns represent quarter of year in conjunction with data about expenses.
Problem is that crosstab query, i mean Report in connection with that query
works only if there is inputs for each quarter of year.
Off course that i can make blank input for each quarter, and calculation
will be correct.
But is there any smarter solution because that blank record will be in all
reports,
and i don't want it. Is there any code in reports to remove blank records
based on blank field?
Click to expand...


Can't you jusr add a criteria (WHERE clause) to filter out
the blank record?
 
Back
Top