I using C# to write an application. This app using SQL Server 2000 as database. Report Viewer as report. I want to export from SQL to Excel format like this below. This is my result after export from ReportViewer to Excel:
Date Amount Credit Date Amount Debit Balance 26/08/08 $1000 26/08/08 $500 $500 But I want this result display in Excel like this: Date Amount Credit Date Amount Debit Balance 26/08/08 $1000 $1000 26/08/08 $500 $500 (Date mean the transaction date; Balance = Amount Debit - Amount Credit) If the Date on the left is the same the Date on the right then the new row is this display in Excel. How I code with this format in C#. An example is my best wish! Thanks!