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