Here are the three formats I need to support...
VENDOR requires an Item Number column and a wide Description
STORES requires a Stock Number column and a wide Description
VFS requires an Item Number column and a Stock Number column and a narrow Description.
Hiding a column is easy - you right click the column's tag, click on column visibility, check the 'Show or hide based on an expression', and then enter the Hidden value. I need to hide the Stock Number column for VENDOR documents so...
But how can you change the width of a column without a Dante-like descent into code?
Fortunately Item Number and Stock Number are both the same width (I made them 0.75" each). That means the Description column needs to be 0.75" narrower when the document is VFS.
I created a new column 0.75" wide to the right of the Description column and merged the header and body cells of the Description column with the header and body cells of the new column. With the Description column's tag selected the report designer looks like this...
Then I told Reporting Services to hide the new column when the document is VFS.