Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Help displaying results in matrix or table

Author  Topic 

Tart_SQL
Starting Member

41 Posts

Posted - 2008-10-28 : 13:09:19
Has anybody ever done a report where depending on user input/choice the results are displayed in either a matrix or table.
Is it wise to have one rdl file that does this, or what alternative should I implement?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-28 : 13:26:24
you can have both matrix and table and toggle visibility property of them based on user parameter like
=IIF(Parameters!userparameter.value=1,False,True)
Go to Top of Page

Tart_SQL
Starting Member

41 Posts

Posted - 2008-10-28 : 14:52:43
But what about the space that is shown on the preview, how do you get rid of the space.

In this case I have a table before the matrix and I see a lot of space during preview, do I have to put one on top of the other? And if so what problems can this cause when there is overlapping.
Go to Top of Page
   

- Advertisement -