sql server reporting services:
To anybody out there that can help me on this. I'm using report server. I'm using the Render method through a aspx page (C#).
When I render to a CSV file, the information from the report is there but
also there is extra lines at the bottom that have this below.
________________________________________________________________
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
" <HEAD>"
" <title>WebForm1</title>"
" <meta content=""Microsoft Visual Studio .NET 7.1"" name=""GENERATOR"">"
" <meta content=""C#"" name=""CODE_LANGUAGE"">"
" <meta content=""JavaScript"" name=""vs_defaultClientScript"">"
" <meta content=""
http://schemas.microsoft.com/intellisense/ie5"" name=""vs_targetSchema"">"
" </HEAD>"
" <body MS_POSITIONING=""GridLayout"">"
" <form name=""Form1"" method=""post"" action=""Render.aspx?Path=/Report+Project17/MissingDepDesCan&Format=CSV&Parms=aril~AC"" id=""Form1"">"
<input type="hidden" name="__VIEWSTATE" value="dDwtMTI3OTMzNDM4NDs7PuJySnvkcdlxZP6WJXX9WyEsez+F" />
</form>"
</body>"
</HTML>
_________________________________________________________________
I've used all the device (encoding and others) settings i know for the CSV file type
but still get this extra information at the bottom of the file.
When I use report server's own rendering page to export file to CSV
I do not get these extra lines.
*****************************************
* This message was posted via
http://www.sqlmonster.com *
* Report spam or abuse by clicking the following URL:
*
http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=eaad53f183ec48258ed8cfca06c8a4c0