quarter problems?!?

[SoulReaver]

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

 

[KARL DEWEY]

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")

 

[Marshall Barton]

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?

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