I have follow report to create using ReportViewer:

---------------------------------------------------------------------------------------------------------

Buy/Sell               Date                Quantity              Price                 Net

Buy                     12/12/2007         100                    11.6                7.90

Sell                     12/13/2007          99                     11.8                7.80

                                Totoal Buy:  100                  Total Buy Net      7.90

                                Total Sell      99                   Total Sell Net      7.80       

                                Total:          199                   Total Net            (0.1)

 ---------------------------------------------------------------------------------------------------------

Total Net   = Total Sell Net - Total Buy Net

I tried many ways, could not get what I wanted. The data source is object data source, not directly from database. Please help

Thank you very much

I only have problem with the bottom part, the summary part :

-----------------------------------------------------

                                Totoal Buy:  100                  Total Buy Net      7.90

                                Total Sell      99                   Total Sell Net      7.80       

                                Total:          199                   Total Net            (0.1)

 --------------------------------------------------

Thank you for your help !

Are you able to write additional select stmts against the database?  Can you create other datasources?

If so, build select stmts for the calculations you need, and add the needed text boxes to the bottom of your report for those values.

Does that make sense?

Create a table in Reporting Services.

[Row Header:]

Buy/Sell                  Date                        Qty.                    Price                    Net

[Row Details:] 

Buy                        12/12/2007               100                     11.6                      7.9

Sell                        12/13/2007                99                      11.8                      7.8

[Tip: Date format-- under format put "MM/dd/yyyy" for data type datetime.]

[Row Footer: (this next part is using formulae that I would use to get it--)]

Total Buy: =Sum(IIf((Fields!BuySell.Value) = "Buy", Fields!Quantity.Value, 0))

Total Sell: =Sum(IIf((Fields!BuySell.Value) = "Sell", Fields!Quantity.Value, 0))

Total: =Sum(Fields!Quantity.Value)

Hi petaru,

I tried , but Sum(IIf((Fields!BuySell.Value) = "Buy", Fields!Quantity.Value, 0)) gave me an error. seems not working.

I changed it to Sum(IIf(Fields!BuySell.Value = "Buy", Fields!Quantity.Value, 0)), still gave me the error.

Is this the way that does the comparision ?

Thank you so much. 

What did the error say?

It did not say anything, just "#ERROR".

If I put anything but "Buy" and" Sell" as the value to the expression (Buy and Sell are the only true values), it runs no error, but gave the 0 as the Sum result. It is supposed to have values

It seems that if the comparision went through, Fields!Quantity.Value encounters some problem, right ?

Thanks

I got it now! 

The following data types is what I used:

BS = varchar(50)

Net/Price = Decimal(18,2)

="Buy Total Qty: " & Sum(IIf((Fields!BS.Value) = "Buy", Fields!quantity.Value, 0))

You should also read your Error List :)

Ctrl + E in Visual Studio ^-^

I think I may resolve the issue. I may need to put CDec before Fields!Some.Value.

Thank you so much. Have a good afternoon !

^-^ I try to learn by resolving other people's issues.  I'm new to reporting services too.