RDLC not able Achieve this result ( Rows total )

Question

User1610382325 posted

Hi,

I am trying to make a report like below. not able to achieve. kindly advice how to do. 

Last before column i need to show sum of phase code value  and in the last column SUM of Section value i need to show. 

I need exactly this .  Share you ideas and thoughts. how can i achieve. 

Thanks in advance.

Ponraj

Answer 1

User1711366110 posted

Hi ponraj,
  Thanks for your post.
As per my understanding of your case ,
  you can write the query from dataset--> Go to Details group in Row Group- > Add total-> After
 or
 write a formula based on your row group & and its expression
For your reference, check the following link :
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/85b3cde5-c89b-40e1-a1ab-fb090ea7446d/sum-values-based-on-iif-condition-in-rdlc-report?forum=sqlreportingservices

if possible Could you post your screenshot or expected output again ?
--
with regards,
Edwin

Answer 2

User1610382325 posted

Hi Edwin,

I am not getting exactly like this. In a same row with total as well "row merge" and show the total based on the phase code.