Possible to perform mathematical functions on two or more text boxes?

I am looking to take the sum of the values displayed in a couple text
boxes and display the result in another text box. Is it at all
possible to include the values displayed in other text boxes in
expressions in other text boxes?On Jul 11, 8:19 am, mtnbiker419 <rdrace...@.gmail.com> wrote:
> I am looking to take the sum of the values displayed in a couple text
> boxes and display the result in another text box. Is it at all
> possible to include the values displayed in other text boxes in
> expressions in other text boxes?
If I'm understanding you correctly and you want field values displayed
in textboxes (i.e., table control cells/text boxes, etc), you can
reference them within the dataset itself (if they are aggregates or
can be aggregated):
=Fields!FieldName.Value + Sum(Fields!FieldNameInOtherDataset.Value,
"DatasetNameUsedInTextboxB")
-or similarly -
=Fields!FieldName.Value + Avg(Fields!FieldNameInOtherDataset.Value,
"DatasetNameUsedInTextboxB")
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Possible Bug with HTML Comments for Data Driven Subscription

I have specified a good sized comment that gets displayed in the message
body. It is html, which by the way could be improved as it is a bit
difficult as it all has to be on one line which makes the <pre> tag useless
so I have to replace all spaces with nbsp and all line breaks with <br> (Hint
- wishlist). In either case when I go back and change something else later -
for instance the email address, it replaces the brackets on my tags in the
comment box with < and &rt, thereby messing up my comment and giving me
something that is gobbledy gook as far as the user is concerned. Why does
reporting services mess up my comment when I go back to change something else?
Thanks,
Scott EguiresThis is a known issue. The Asp.Net control encodes the data for us which
causes this problem. There is no real workaround, except to keep you html
in a separate location and cut and paste it in when ready.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"dkangel" <dkangel@.discussions.microsoft.com> wrote in message
news:9EC5C437-196A-4CD9-BA1D-BBBCD10DC100@.microsoft.com...
> I have specified a good sized comment that gets displayed in the message
> body. It is html, which by the way could be improved as it is a bit
> difficult as it all has to be on one line which makes the <pre> tag
useless
> so I have to replace all spaces with nbsp and all line breaks with <br>
(Hint
> - wishlist). In either case when I go back and change something else
later -
> for instance the email address, it replaces the brackets on my tags in the
> comment box with < and &rt, thereby messing up my comment and giving me
> something that is gobbledy gook as far as the user is concerned. Why does
> reporting services mess up my comment when I go back to change something
else?
> Thanks,
> Scott Eguires

Positioning Subtotal in Matrix

Is there a way to re-position the subtotal in a matrix report such that the
subtotal is displayed at the beginning of the report instead of at the end.
Currently:
Q1 10
Q2 5
Q3 10
Q4 3
Total 28
Need:
Total 28
Q1 10
Q2 5
Q3 10
Q4 3
Thanks!You can change the subtotal position. Click on the little green triangle in
the (row/column) heading to get the subtotal properties and look at the VS
properties window. There is a "Position" property which is set to "After" by
default. You can set it to "Before", which results in the desired effect.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Teresa" <Teresa@.discussions.microsoft.com> wrote in message
news:8565A38F-17B9-40F9-BDF2-499E73A3FC85@.microsoft.com...
> Is there a way to re-position the subtotal in a matrix report such that
> the
> subtotal is displayed at the beginning of the report instead of at the
> end.
> Currently:
> Q1 10
> Q2 5
> Q3 10
> Q4 3
> Total 28
> Need:
> Total 28
> Q1 10
> Q2 5
> Q3 10
> Q4 3
> Thanks!
>

positioning of report parameters when diaplayed in report manager

hi all

i have a report with set of parametrers.

by default when we create parameters they r displayed adjacent to each other.

is there any way by which we can specify position of parameter to be displayed in parameter area?

for eg:- suppose i have two parameters say age & name

then i want to display them one below the other.

is this possible?

if yes how?

plz help me.

waiting for reply.

You cannot customize report manager in this area.

The closest you can get is to e.g. with VS 2005 build your own frontend application (Winforms or Webforms) that deals with the parameters and then use RS Winforms/Webforms ReportViewer controls to display the report based on the selected parameters. More information on the ReportViewer controls: http://www.gotreportviewer.com/

-- Robert