Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How can I display value in another dataset on a matrix Expand / Collapse
Author
Message
Posted Monday, October 7, 2013 9:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:00 PM
Points: 295, Visits: 488
Hi

I have a Matrix report by Month and displayvalues based on "dataset2"

At the bottom or end of report
I would like to display the values in "dataset3" which are what I used to get values in dataset2

it would look kinda' like...


........... Jan Feb Mar .......
expr 1 22 11 11
expr 2 21 22 22 .....

(bottom would say.)
This data came from

field1
field1
field1...

which would be the three values in dataset3

Sorry if its a bit confusing in the explanation

Thanks
Joe
Post #1502223
Posted Monday, October 7, 2013 10:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:00 PM
Points: 295, Visits: 488
Hi

Ok so what I figured to do
(Why didn't I think of this before.. It is MOnday :)

Anyway, I inserted a Matrix and based off the dataset

Seems straightforward now..

If anyone has a better way I'd love to know that too..

Thanks
Joe
Post #1502271
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse