saritha,
ocp_dev did what I was speaking of for reports.
I am wanting to know, do you want to see the detail and then the sub totals and grand totals or just the sub totals and grand totals.
if you are desiring the first type:
in Report Builder Data Model Section
1. Create your query
I think the query would like
select substr(tc_line_rev_acct_no,1,5) actgrp,
tc_line_rev_acct_no, totamtpd
from table_x
2. Pull out the actgrp from G_actgrp (actgrp might be changed by Report Builder). This will create two G_NAME in the data model.
3. Generate your report using a Group above method.
Else:
you can use a nested query..for the second part.
Good Luck!
