0

I have created a tabular report that has a couple of drilldowns that are subtotaled at the top of each table group via the following expression

Code:

=Sum(Fields!StandardTime.Value)

Data:

+-------+---+------------+----+----------+
|Company|Job|StandardTime|User|ActualTime|
+-------+---+------------+----+----------+
|Wirebox|tx |  5         |Joe |  1       |
|Wirebox|tx |  5         |Theo|  3       |
|Wirebox|ty |  10        |Joe |  4       |
|Wirebox|ty |  10        |Theo|  7       |
+-------+---+------------+----+----------+

Report:

+-------+---+------------+----+----------+
|Company|Job|StandardTime|User|ActualTime|
+-------+---+------------+----+----------+
|Wirebox|   |   15       |    |  15      |<---Company Total
|       |tx |   5        |    |  4       |<---Job Total
|       |   |            |Joe |  1       |
|       |   |            |Theo|  3       |
|       |ty |  10        |    |  11      |<---Job Total
|       |   |            |Joe |  4       |
|       |   |            |Theo|  7       |
+-------+---+------------+----+----------+

The problem I am getting is when I add the StandardTime together to get the total for the company with =Sum(Fields!StandardTime.Value) the result is 30 and not the desired 15 as per my example. I am guessing the report is adding all of the StandardTime for SQL query. But that data is duplicated in the query. Is there a way to Total only the figures I am outputting in the report?

Theo Kouzelis
  • 3,195
  • 5
  • 37
  • 66

1 Answers1

0

Add "Company" Group then total before on "StandardTime". for the also Add "Job" Group then total before on "StandardTime". This will give you your desire result.

Here a link how to add group on the report

Here is the sample that i tested..

Report defination

Results:

Report Results

Good luck!!

Hiten004
  • 2,425
  • 1
  • 22
  • 34
  • It is already in a "Company" Group because when you make a drill down report with the report wizard it does all that for you – Theo Kouzelis Dec 21 '12 at 09:47
  • I have test the report please look snapshot above. Hope this help. – Hiten004 Dec 21 '12 at 20:56
  • Hi would it be possible to send me a copy of your test report please – Theo Kouzelis Jan 10 '13 at 14:15
  • Hi @Hiten004 I am still having this issue and you said you managed to solve it. Would you be able to solve the issue for me and my company would be willing to pay for your time. Please let me know thanks. – Theo Kouzelis Jan 16 '13 at 13:35
  • @TheoKouzelis please check the results and varified. I have update the answer. i am not sure how to send the report file. i can not attach to the answer. – Hiten004 Jan 16 '13 at 17:03
  • 1
    yep those results are correct. You can send it to my email if you like which is theo@wirebox.co.uk – Theo Kouzelis Jan 16 '13 at 21:35