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!