How to show type first balance on one line and prevent repea

Question

How to show type first balance on one line and prevent repeating using crystal report How to show (first balance ) on one line summarized using crystal report as following : final output 1 first balance 9000 details InvoiceNo type debit 1 first balance 2000 2 first balance 3000 show these three lines on one line as above 3 first balance 4000 4 end balance 7000 5 SalesInvoice 8500 I need to show type (first balance) on one line with summarized so that what i need actually when type = first balance show on one line with sumarized debit using crystal report . This data saved on sql server 2012 .

Nitin Sontakke · Answer

I am not answering your question but correct term to use would be 'Opening Balance' for what you are calling first balance and 'Closing Balance' for you are calling end balance. I think if you put expected output in note pad or excel and paste the screen shot here. Give clear captions as This is what i have now: and This is what i want: and if possible share query too because it is possible that problem might be solved at the back-end itself.