When I went back through the posts to your question forum member Savan essentially gave you the same solution I was going to offer. So look at that post. However, you will need to create a new report and abandon the crosstab design. 

 

Savan lists 3 levels of grouping

Grp 1 Center

Grp2  Acct_Main

Grp3 Acct_Sub

 

Follow Savan's data link suggestion and group suppression suggestions.

 

I am not sure where your remaining details come from but if you take Savan's solution you should be close enough to work out the rest of the design.

 

I do a lot of accounting style reports and find this type of design gives me what you are looking for.

 

 

 

Regards,

 

John W.

 

if center = "karachi then

cr1

else

 

 

This assumes you have properly related the data query to each center. If the number of cr and dr fields is not constant then this design may not work.

 

I am not sure how you can do what you want without a large amount of coding. Perhaps others will have a better solution or improve upon my thoughts.

 

Regards,

 

John W.