If you create report groups, which group by Category and all the grouped items do not contain specific Funds (for e.g. Fund3 and Fund4), then there shouldn't be columns in the crosstab for them. If however there is data for e.g. in the first group for Fund4, then naturally Fund4 column will appear.
Please review the attached report showing your scenario implemented with a crosstab and report groups.
the Telerik team
HAPPY WITH TELERIK REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!