Solved

Adding textbox in SQL Reporting services

Posted on 2009-05-05
3
891 Views
Last Modified: 2012-05-06
Guy thanks for the help in SSRS.

What I have now is a complet table with one query.

I need to add tables in the query.

something like.

Table 1 + Table 2 = Table3 (Total of 1 and 2)
then take Table 3 Total and add something in Table 4.

Can you do math with the Textbox names in the talbes?

Sam
0
Comment
Question by:SamRunyon
3 Comments
 
LVL 13

Expert Comment

by:St3veMax
Comment Utility
You can add different values from multiple data sources; Click on 'Expression' when you right click on the cell you want the value in, then select the value 1 from Dataset 1 then value 2 from dataset 2, so you expression will end up with something like this:

=Fields!Dataset1.Value1 + Fields!Dataset2.Value2

HTH
0
 

Author Comment

by:SamRunyon
Comment Utility
Steve I tried that.

=Fields!EnergyClassic.Value * Fields!DataSetSpectraBTUFactor.Value

this is the error I got.

[rsFieldReference] The Value expression for the textbox EnergyClassic refers to the field DataSetSpectraBTUFactor.  Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
Build complete -- 1 errors, 0 warnings

Any Help.
0
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 500 total points
Comment Utility
you cannot reference items from another dataset like that, you can only reference aggregates and use a SCOPE of the dataset.  Don't know your exact values but something like this in Table4 could refference the total of a field from Table3.
=SUM(Fields!EnergyClassic.Value,"Table3")*Fields!DataSetSpectraBTUFactor.Value
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now