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

Adding two textbox values in a matrix report Expand / Collapse
Author
Message
Posted Monday, June 3, 2013 3:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 1, 2014 2:14 PM
Points: 100, Visits: 435
Hi All,

How to add two matrix reports that are pointing to two different datasets?

I am ok doing it this way
=Sum(Fields!JobBilledExVat.Value, "Dataset1") + Sum(Fields!JobBilledExVat.Value, "Dataset2")

But my matrix report populates the column field by data and the report grows based on the selected dates. when I use the above expression , it is not grouped by week.


How to add two textbox values in a matrix report grouped by a column.any help pls
Post #1459141
Posted Tuesday, June 4, 2013 3:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:41 AM
Points: 41, Visits: 165
Hello

I don't get it well sorry
Do you want to dispose the cells horizontally or vertically ?

If you want to dispose the textbox freely on a matrix cell, you need to put a rectangle region before you drag and drap the textbox on that rectangle region
Post #1459611
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse