Export to Excel 2000 format with Reporting services 2000 SP1

Hi,
I am clueless on how to generate the report in Excel 2000 format. i have
installed reporting services 2000 with service pack 2 in this machine. the
resultant Excel file format is in version 2003. i cant view that in Excel
2000. your feedback is highly appreciated.
Following is my code,
string report = m_ReportNameEXCEL;
string path = m_TargetReportLocation + report;
Byte[] bytes;
string format = "EXCEL";
string historyid = null;
string deviceInfo = null;
ReportServer.ParameterValue[] parameters;
DataSourceCredentials[] credentials = null;
string showhide = null;
string encoding = null;
string mimetype = null;
ParameterValue[] parameterused = null;
Warning[] warnings = null;
string[] streamIDs = null;
-
-
-
bytes = reportService.Render(
path,
format,
historyid,
deviceInfo,
parameters,
credentials,
showhide,
out encoding,
out mimetype,
out parameterused,
out warnings,
out streamIDs);
FileStream fs = File.Create(m_OutputPath + iYear.ToString()+ @."\" +
fileName);
fs.Write(bytes,0,bytes.Length);
fs.Close();
}
Thanks,
PradeepI have just looked it up in a Book. Only Excel 2002 or 2003 is supported. The
Data is rendered into MTHML with Mime Type ms-excel internally and brought to
Excel after that.
BUT: I am also using EXCEL 2000 on my machine and the exported Reports can
be opened without problems... (I have to say that I had Office 2003 on it
before, uninstalled it and installed OIffice 2000, God knows if there are any
DLLs left...?)
Maybe you are using anything inside your Report that needs a newer version?
Did you try a very simple Report?
There is the possibility to create your ow new Export formats. To do this
you have to program a File Rendering Extension. This is quite complex to
realize. You should get a good book to realize that.
Markus Poehler
netpoint-edv gmbh
"msnews.microsoft.com" wrote:
> Hi,
> I am clueless on how to generate the report in Excel 2000 format. i have
> installed reporting services 2000 with service pack 2 in this machine. the
> resultant Excel file format is in version 2003. i cant view that in Excel
> 2000. your feedback is highly appreciated.
> Following is my code,
> string report = m_ReportNameEXCEL;
> string path = m_TargetReportLocation + report;
> Byte[] bytes;
> string format = "EXCEL";
> string historyid = null;
> string deviceInfo = null;
> ReportServer.ParameterValue[] parameters;
> DataSourceCredentials[] credentials = null;
> string showhide = null;
> string encoding = null;
> string mimetype = null;
> ParameterValue[] parameterused = null;
> Warning[] warnings = null;
> string[] streamIDs = null;
> -
> -
> -
>
> bytes = reportService.Render(
> path,
> format,
> historyid,
> deviceInfo,
> parameters,
> credentials,
> showhide,
> out encoding,
> out mimetype,
> out parameterused,
> out warnings,
> out streamIDs);
>
> FileStream fs = File.Create(m_OutputPath + iYear.ToString()+ @."\" +
> fileName);
> fs.Write(bytes,0,bytes.Length);
> fs.Close();
> }
>
> Thanks,
> Pradeep
>
>|||SP1 and greater definitely creates native Excel format (that can be opened
in Excel 2000). To make sure the problem isn't your code, open up a report
in report manager and export it to Excel and see if you can open in Excel
2000. Note that when you upgrade to SP1 or SP2 it is both a report designer
upgrade and a RS server upgrade.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MarkusPoehler" <MarkusPoehler@.discussions.microsoft.com> wrote in message
news:BB9415C5-7400-4C88-9001-5964112E55EC@.microsoft.com...
>I have just looked it up in a Book. Only Excel 2002 or 2003 is supported.
>The
> Data is rendered into MTHML with Mime Type ms-excel internally and brought
> to
> Excel after that.
> BUT: I am also using EXCEL 2000 on my machine and the exported Reports can
> be opened without problems... (I have to say that I had Office 2003 on it
> before, uninstalled it and installed OIffice 2000, God knows if there are
> any
> DLLs left...?)
> Maybe you are using anything inside your Report that needs a newer
> version?
> Did you try a very simple Report?
> There is the possibility to create your ow new Export formats. To do this
> you have to program a File Rendering Extension. This is quite complex to
> realize. You should get a good book to realize that.
> Markus Poehler
> netpoint-edv gmbh
> "msnews.microsoft.com" wrote:
>> Hi,
>> I am clueless on how to generate the report in Excel 2000 format. i have
>> installed reporting services 2000 with service pack 2 in this machine.
>> the
>> resultant Excel file format is in version 2003. i cant view that in Excel
>> 2000. your feedback is highly appreciated.
>> Following is my code,
>> string report = m_ReportNameEXCEL;
>> string path = m_TargetReportLocation + report;
>> Byte[] bytes;
>> string format = "EXCEL";
>> string historyid = null;
>> string deviceInfo = null;
>> ReportServer.ParameterValue[] parameters;
>> DataSourceCredentials[] credentials = null;
>> string showhide = null;
>> string encoding = null;
>> string mimetype = null;
>> ParameterValue[] parameterused = null;
>> Warning[] warnings = null;
>> string[] streamIDs = null;
>> -
>> -
>> -
>>
>> bytes = reportService.Render(
>> path,
>> format,
>> historyid,
>> deviceInfo,
>> parameters,
>> credentials,
>> showhide,
>> out encoding,
>> out mimetype,
>> out parameterused,
>> out warnings,
>> out streamIDs);
>>
>> FileStream fs = File.Create(m_OutputPath + iYear.ToString()+ @."\" +
>> fileName);
>> fs.Write(bytes,0,bytes.Length);
>> fs.Close();
>> }
>>
>> Thanks,
>> Pradeep
>>