I want a report in excel from my SQL database from one table. I want
to create a view and then use DTS package to export it to excel
format.
But how can i get the following format in a view?? They should be
grouped by date.
Date Column 1 column 2 column 3
29/10/2003 one $30.00 somedate
two $45.00 somedata2
three $67.00 somedata3
Total ******** $142.00
30/1/2003 blah blah blah
blah blah blah
and so on . How can i get such a format in a view.
Thanks in advance. I can't use SHAPE command in view i guess.
to create a view and then use DTS package to export it to excel
format.
But how can i get the following format in a view?? They should be
grouped by date.
Date Column 1 column 2 column 3
29/10/2003 one $30.00 somedate
two $45.00 somedata2
three $67.00 somedata3
Total ******** $142.00
30/1/2003 blah blah blah
blah blah blah
and so on . How can i get such a format in a view.
Thanks in advance. I can't use SHAPE command in view i guess.
Comment