Calculate value, assign into TextBox

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

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Calculate value, assign into TextBox

Author

Topic

Delinda
Constraint Violating Yak Guru

315 Posts

Posted - 2010-05-29 : 11:08:48

Hi,

My dataset as follow,


rphID | cat  | rphDte                     | RID  | sales
----------------------------------------------------------------
1	sales	2010-05-01 00:00:00.000	    701	   2343.00
1	pax	2010-05-01 00:00:00.000	    701	   3467.00
1	sales	2010-05-02 00:00:00.000	    701	   563.00
1	pax	2010-05-02 00:00:00.000	    701	   347.00
1	sales	2010-05-02 00:00:00.000	    720	   1563.00
1	pax	2010-05-02 00:00:00.000	    720	   3457.00
1	sales	2010-05-01 00:00:00.000	    720	   4390.00
1	pax	2010-05-03 00:00:00.000	    701	   4789.00

*above value used by matrix report

Based on above value,
Sum of sales is 8859
Sum of pax is 12060

In my SSRS, my textbox is
1. txtSumOfSales
2. txtSumOfPax

My question is, how to assign
txtSumOfSales=8859
txtSumOfPax=12060

Really need help

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources