Reporting using ASP.NET and MS Word

[MetaFunk]

Hi

I have requirement to develop a report in ASP.NET which needs to be exportable to MS Word.

The report format needs to be

Group A
Some Info ...
Some Info ...
Some Info ...

Group B
Some Info ...
Some Info ...
Some Info ...

Group C
Some Info ...
Some Info ...
Some Info ...

I think you get the picture. Any suggestions on the best way to acheive this ?

Regards
G,

 

[evaleah]

I am not sure about MS Word, but would Excel do?

If you databind a datagrid control you can then execute the following code to make it come out as Excel. Just change dgResults to whatever the name of your datagrid is. You might get this to go into Word if you change the vnd.ms-excel part to read vnd.ms-word but I haven't tested it so don't know.

If Me.dgResults.Items.Count > 0 Then
'Set the content type to Excel...
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Me.EnableViewState = False
Dim tw As New System.IO.StringWriter
Dim hw As New System.Web.UI.HtmlTextWriter(tw)
dgResults.RenderControl(hw)
Response.Write(tw.ToString())
Response.End()
Else
GetDataSet()
End If


HTH

Eva

 

[MetaFunk]

Hi Eva

Thanks for yor reply. I am familiar with the Excel method.

The requirement is for MS Word and the bigger problem is data grouping which I have explained earlier.


G,