visual studio 2010 - Creating Income Statement Design in Crystal Report

Question

I have table of accounts.

Note: If Ctrl is 1, it can control another accounts

and I also have table of transactions

All I want is to display this in crystal report that will look like this:

I try to create this but everytime I put TOTAL(Title 1, Title 1-2, Title 1-3) it always appear after the Account Title

Answer 1

Actually I feel you have complicated the report design.. You can do it without sub report aswell. Try below approach.

This solution works assuming you have linked the two tables in database expert.

1. First group the report with below formula.

   if ctrl=1
   then ctrl
   

2. Now again group with ACCTitle

3. In detail put the calculation fields of 2nd table.

Accttitle and Amount of transaction table.

1. Place Account title and Amount in group header1

2. Take the respective group summaries..

Let me know after trying this approach