Display the SUM and Total product wise in a SRSS Drill Down report

Question

Hi,

I have a requirement where I need to display the Total of some columns I have mentioned below product wise ..(at present I am showing it as the whole total.) Can someone please suggest me how to do this in a SRSS drilldown type report.

ie: for all the products starting with R there should be a sum at the end and for all the product types starting with S there should be a separate total. (I have grouped the report based upon the first column in the picture..which is (CNo)

Answer 1

Hello,

Thanks for your Post.

Based on your description, you want to add a subtotal to the all the products which starting with same character, "R" or "S". In order to meet your requirement, please refer to the following steps:
    1. Add a child row group to the group"CNo" and specify the group expression as follows:
    =Left(Fields!CNo.Value, 1)

   2. Add a group footer for the child group which display the subtotal value for the group.

If you have any question, please let me know.

Regards,

Fanny Liu

 

---

Fanny Liu
TechNet Community Support

Answer 2

Thanks a lot Fanny,

It was a brilliant suggestion. I am able to get the totals but only for the first column highlighted in round figure is coming correctly. But for  the one which is highlighted in square is not giving me wrong values. Do I need to do a grouping  for each column  seperatly. Any suggestions please..this is a very urgent requirement.

Answer 3

Hi,

Please check the expression for highlighted in square , did you use sum function here?, if not then please try as: =Sum(you expression) and I hope it would be helpful.

---

Regards Avanish T

Answer 4

Hi Avinash,

I have used the SUM function but I am wondering why value is coming properly for only a single column. You could see a + button in my report , I am displaying details for each CastNo when user expands the +  sign.  That might be causing the issue..

Please have a look at my table structure. I am having multiple values against each CastNo in the table. So when user expands the tree using + sign I am displaying all the "Name" against each castNo. First grouping has been done using Name and then second grouping has been done using CastNo and finally third grouping has been done using productType in SRSS report. I am doubtful about the grouping or the rows which are repeating against each cast. This might be giving wrong values when I do a SUM.

Answer 5

Hello,

How do you specify the value expression for the “GrossCastWeight” column and the total row? Please verify the scope in the expression for the aggregate values, for example:
=SUM("value expression for the ‘GrossCastWeight’ column", "CNo").
If the issue persists, please post both expressions with us, it is benefit for us to do further analysis.

Regards,
Fanny liu

---

Fanny Liu
TechNet Community Support