Reporting Services - Determine Number of Columns Shown in Matrix -

Is it possible to define the number of columns displayed in the Reporting Services report, and use it for different visibility expression text boxes?

I face the following scenario:

My client has a Reporting Services 2005 report, which has a matrix, which displays a variable number of columns based on the selected parameters . On this occasion, some users have created reports with a large number of columns. This causes a server error when they try to export to Excel later, because the format of Excel 97-2003 is limited to 256 columns.

So I would like to display a message at the top of the report, since 256 columns have been shown in more metrics, which advise users of this limit and suggest solutions to export to CSV ( And see if they have them in Excel 2007).

Would you be able to count on your dataset to count your columns?

  calculation (field! Field u sda column grouping.value, "datasetname")  

Make sure how your data and metrics are set up, I do something like where I need to know the number of columns so that I can draw a proper line. But I think that you should be able to count on a dataset or you should create a group to find what you are looking for. (If necessary, I can paste some code on Monday.)