how to Sum Report Items and Grand Total Problems in report viewer with VB.Net2010

Question

Page1

Column-A    column_B  TimeDiff   <---Datediff() Here i'd used this function

a 2/05/12 00:00:00

a 4/05/12 02:25:17

a 6/05/12 01:45:55

Page2

a 6/05/12 02:25:17

a 7/05/12 02:25:17

a)Total timeDiff   04:50:34   <--- Here I need 08:01:46

B 2/05/12 00:00:00

B 4/05/12 02:25:17

B 6/05/12 02:25:55

B)Total timeDiff   04:51:12

Grand Total 09:39:46 <--i got it,But   12:52:58  <-here i need grand total. only report viewer last page.

please help me...

Answer 1

HI Emalai !

You might get the desired output using below expression;

=ReportItems!Textbox1.Value + ReportItems!Textbox2.Value

Please let me know if this doesn’t work for you. Hope I have answered you correctly.

Thanks, Hasham Niaz

Answer 2

Thank you Very much Hasham Niaz,

i got Error

Error 1 The Value expression for the textrun ‘Textbox106.Paragraphs[0].TextRuns[0]’ refers to more than one report item.  An expression in a page header or footer can refer to only one report item

and i'd used this coding

 =sum(Cint(ReportItems!Text_DayDiff.Value))

First page don't got total,i got total only second page values and Group Footer First page values not continues to total of second pages,

i need every group footer total values and Grand total

Answer 3

Please help me

Report viewer Result page show below, here used row grouping and DayDiff column used DateDiff() function

Page 1

Column-A column-B DayDiff <--Here using DateDiff()

a 2/05/2012 0

a 4/05/2012 2

a 6/05/2012 2

 Page 2

a 8/05/2012 2

a 11/05/2012 3

a)Group DayDiff Total is 5 but i need total 9  <---Here using custom code, =code.GetValue() and Problem is not get my first page values

b 13/05/2012 2

b 15/05/2012 2

b 19/05/2012 4

b)Group DayDiff Total is 8 

then second page Grand total 13 but i need grand total is 17 and Grand total is show on only second page not first page 

please help me 

Thanks

Emalai

Answer 4

Hi There

Thanks for your posting. Can you please have a look in your custom code are you using

Shared variable like this Public  Shared Total_Count_Sum As Integer = 0

If you are using Shared variable like that please try to change this like

Public  Total_Count_Sum As Integer = 0

And see if it makes any difference, your code might look like this one

Public  Total_Count_Sum As Integer = 0

Public Function  Count _Sum(ByVal value As Integer) As Integer

    Total_Count_Sum = Total_Count_Sum + value

 

    Return value

 

End Function

 

=Code.Count _Sum(DateDiff("d",Fields!A.Value-Fields!B.Value))

 Now you are passing the above expression to your code and returning the same value back but it will keep adding the value inside the Total_Count_Sum.

Now Please put this expression where you would like to get the sum

 =Code. Total_Count_Sum

If you have any questions please do ask

Many thanks

Syed Qazafi Anjum

Answer 5

Hi Emalai,

Sorry for the delay.

From your description, you are designning a client report definition (.rdlc) file. Let's assume the name of the field placed in the Column_A is "Column_A" and the name of the field placed in "Column_B" is "Column_B", and then, I suggest that you refer to the following steps:

1. Drag a Table control to the design surface.
2. Place "Column_B" in the Details row.
3. Add a parent group for the Details group, and set the group to group on the "Column_A" field.
4. Right-click on the details row of the "TimeDiff" column, select "Add Total".
5. Right-click on the textbox that contains "Column_A" field, and select "Add Total"-> "After".

For more information, please refer to the following article:
http://msdn.microsoft.com/en-us/library/ms170712(v=sql.105).aspx

Besides, this question is probably better served by the Visual Studio Report Controls forum where the experts are more familiar with the ReportViewer control. For your convenience, I have included link below:
http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/threads?page=1

Regards,
Mike Yin

---

Mike Yin

TechNet Community Support

Answer 6

Thank you very much,

Sorry for the delay 

i'd tried but not working because Time_Diff is not Field,It is add another one column in Right side I need total of every group footer please help me..

Answer 7

Hi Emalai,

Thanks for your posting.

I have unmarked my reply above since it didn't help you resolve the issue. Besides, I notice that you have created several threads with the same topic, I will merge them due to the duplicates. Thanks for your understanding.

From your description, you use custom code to obtain the aggrate valuee as the nested aggreate function is not supported in SSRS. Based on the current information, I suggest that you refer to Robert's blog Using Group Variables in Reporting Services 2008 for Custom Aggregation. It should be helpful for you.

Regards,
Mike Yin

---

Mike Yin

TechNet Community Support

Answer 8

Sorry for delay,

Right-click on the details row of the "TimeDiff" column, select "Add Total" this option not show "Add Total"