Hi,

Some one please advise how to achieve this below sub summary for "Name1+Name2" group by fields below.

I tried this below using sub report by passing "Name2" parameter to subreport to generate "Name2" summary alone and suppressed sub report based on condition "Previuse(Name2) <> current(Name2)".
This works fine till two combinations but not when name repeates more than twice. Please advise, how to solve this issue.

Thanks in advance for those who replying to this question.


Rajesh          Uday           6      00:35:48      00:52:19      02:39:08      03:45:04      1.46      6
Senthil      Uday           13      00:47:52      01:07:45      06:39:30      00:32:25      1.42      13
-------------------------------------------------------------------------------------------------------------------
Sub Total      Uday           19      01:23:40      02:00:04      09:18:38      01:33:15      6.68      19
-------------------------------------------------------------------------------------------------------------------
Rajesh           Rajesh           1      00:01:11      00:00:00      00:00:16      38:55:18      0.00      1
Senthil      Shanmugan      1      00:05:27      00:07:08      00:12:02      00:12:02      1.31      1
Ganapathy      Shanmugan      80      08:19:22      12:09:01      54:09:24      00:42:45      1.46      80
-------------------------------------------------------------------------------------------------------------------
Sub Total      Shnmugam           81      08:24:49      12:16:09      54:21:26      00:42:22      6.46      81
-------------------------------------------------------------------------------------------------------------------
Senthil      Hari           12      00:45:57      01:06:37      05:38:06      00:28:10      1.45      12
Rajesh           Danapal          6      00:18:36      00:52:11      02:59:26      00:29:54      2.81      6
Senthil      Danapal          17      01:13:58      02:48:48      13:02:37      02:11:22      2.28      17
-------------------------------------------------------------------------------------------------------------------
Sub Total      Danapal      23      01:32:34      03:40:59      16:02:03      01:44:53      10.39      23
-------------------------------------------------------------------------------------------------------------------
Rajesh           Mani          40      02:26:35      04:36:50      28:20:44      02:19:25      1.89      40
Senthil          Mani           34      02:14:56      04:00:44      31:40:09      01:04:21      1.78      34
-------------------------------------------------------------------------------------------------------------------
Sub Total      Mani           74      04:41:31      08:37:34      60:00:53      01:44:56      12.79      74
-------------------------------------------------------------------------------------------------------------------

Hi,

Thank You! I tried but but no luck. "Name2" group is also displaying the same value what we see on the existing group. As I already mentioned the rows whatever i listed are in group header(grouped by combining "Name1+Name2") and I need to insert a sub total based on "Name2" alone(Sorry I have not placed titles here, where ever I say "Name2" it's second column on the list).

Thanks,

Thank You! I see what you suggesting. But problem now is on drill down.

Is there a way to skip one middle section(group) from drill down. I have 4 groups, where i click first group it displays 2nd group and clicking on 2nd group it will display 3rd group. Now I have added one new group above to my existing group 3 which i dont want to display it on my drill down. Please suggest. Hope If i get answer for this, I will complete my report today.

Hi,

Sorry, it was not working as i expect. Because the subtotal needs to be displayed whenever "Name2" changes as i given on my example, not at the end of entire section. Please advise.

Thanks,

Edited by CREXPLORER - 08 Sep 2014 at 5:59am