Hello,


I want to create a project details report and one of the subreport is on budget. In the budget table
Reduced 84%


601 x 323 (62.17K)


, I have various years and three budget types. (table budget)


In a subreport, I want to show it like the attached budget report
Reduced 73%


363 x 84 (8.71K)



and only show the FY2011-12, FY2012-13 and FY2013-14 columns if the budget is not null. and hide the FY2010-11 column for this particular one detail report (see attached table budget - filter as an example)
Reduced 84%


599 x 134 (23.73K)


. So the number of columns are depend on the null value.



I don't know how to create this crosstab query and an unbound report. Anyone has an example I could follow?

Thanks.