Hi all,
Am having a really hard time with Cyrstal Report's cross tab. The report is based on a SQL Server stored proc. and produces the report attached below. The basic idea is get ending balance for previous year (2011), get its ending balance while for the next year (2012) as well. What is needed now is, I need to hide Arrived Items column from the smaller year (2011). The arrived items and annual balance of the smaller year are always the same. If either columns of the 2011 could be hidden in a way, it would be really great.
The parameters for the report are @smallyear and @bigyear. I have tried coloring the columns white but 2012 gets affected as well. The same if I set their width to zero. Anyway to do so?
Am having a really hard time with Cyrstal Report's cross tab. The report is based on a SQL Server stored proc. and produces the report attached below. The basic idea is get ending balance for previous year (2011), get its ending balance while for the next year (2012) as well. What is needed now is, I need to hide Arrived Items column from the smaller year (2011). The arrived items and annual balance of the smaller year are always the same. If either columns of the 2011 could be hidden in a way, it would be really great.
The parameters for the report are @smallyear and @bigyear. I have tried coloring the columns white but 2012 gets affected as well. The same if I set their width to zero. Anyway to do so?
Comment