Adding a legend to a Reporting Services report
Posted on 2006-04-24
I have a Microsoft SQL Server 2000 Reporting Services report using a matrix and using a dataset that gets its contents from a stored procedure. All is working fine, but I have some color-coding used in the report itself and I would like to add a legend at the top.
In Visual Studio .NET 2003, I switched to the toolbox tab on the left hand sidebar and dragged a table to my report. I removed the header and footer, removed a column and added rows and basically made the table the way I want. The problem I have is that the legend is not appearing once, and all the time (as I would want it). Instead it shows up as many times as there are rows in the dataset used by the matrix. How do I make it to work independently from the dataset, the same way as a textbox works for example?