Cross tab help

[A S MANN]

We have a crosstab query with Courses at Column Heading and Name as Row Heading And Amount as Value field.


We need to have value of all the Courses data in table ( Sourse of Cross tab Query) If one of more Courses do not have Data value than report based on crosstab give error asking for missing/null value of missing Courses.
Is their is any way to give missing value and report will work without error?
Thanks in advance

[weekend00]

Do you mean you want to assign 0 to thoses course which are null?

use isnull(amount,0) instead of amount as value in crosstab.

[A S MANN]

I want to assign o to non exist course say if a course A Does not Exist in My Table it will not come in Crosstab query. But Course A Exist in Report which has crosstab as sourse.Report shows me error asking for non exist Course A.
Is their a way to assign o to non exist course A in Cross tab query or in report.
isnull(amount,0) instead of amount as value in crosstab does NOT work in cross tab query
Any other way out?

[weekend00]

How do you have course A in your report while it is not in the crosstab query?

do you have other course B, course C ... in report but not in query?

[A S MANN]

Table data few times have Course A But not always so it is added to report.
When Course A exist in Table , hence in Cross tab it will come in Report But sometimes if their is no entry of Course A in Table than report shows error for non exist Course A
Is their a way to assign o to non exist course A in Cross tab query or in report.
If Course A Does Not Exist ( Null Valus ) Than consider as 0? How to do this?

[weekend00]

If course A doesn't exist, we don't know it doesn't exist unless you have courses list some where.