Hi , I'm using sql server reporting services reportviewer 2005 to generate reports. However one of the reports is a matrix report that contains hyperlinks on one of the column group fields, however the users are complaining that when they export the report, the hyperlinks are displayed on the report. I want to change the report, so that if the the excelformat parameter is set to true then the data in the text box is not blue with an underline (traditional hyperlink text). However the only way I can think of doing this is by having one column with a hyperlink textbox in and another with normal textbox in. If parameter ExcelFormat is true then show the column with normal text, otherwise show the hyperlink text.The problem with this is that a huge gap is shown where the hidden column should be, which looks stupid. Is there any way of having 2 textboxes in one column and just show one of them depending on the value of a parameter. Thanks in advance Robbie

Robbie, this link has lots of advance Matrix Reporting Techniques in which you wll find answer to your question too. http://www.simple-talk.com/sql/reporting-services/advanced-matrix-reporting-techniques/