Hello,
I want to create a project details report and one of the subreport is on budget. In the budget tableReduced 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 reportReduced 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.