Hide groups in crosstab

[Janezz]

Hi,

I have crosstab with 4 rows (groups): employee, product, region and customer, columns are months (number of columns is based on the date interval that is picked by the user running the report), data comes from the SQL 2000 (stored procedure), report shows sales for each employee for the groups during each month.
By default, all four groups are shown in the report, including row and column totals.
Is it possible to suppress certain groups based on the user selection? For example, user selects in the application to include only three groups and excludes region.
Is it possible to suppress certain groups in run-time?

I am using CR.NET bundled with VS 2005 (special version of CR 10).

Janez

 

[IanWaterman]

You can only do this by creating groups using a formula based upon the parameter result and fields required.

Thus if the group is to suppress, the formula should return "".

I have done this with a standard report, not tried it with a crosstab, but should work too.

Ian