Programmatic export to Excel file

Hot Topic

Increase Aggregation Percentage
embedding a DTS package which contains a 'Copy SQL Server Objects Task'
The product level is insufficient for component
Day of the month
sql server 2005 setup error
The best Data Transformation tool to Update/Insert
Conditional statement with a cast from string to date
Custom Log Provider - Notification Services
SQL Profiler 2005 showing inaccurate duration
Replication fails when table name has single hyphen

SQL Server

Is there anything like rowid, rownum like in MySql and Oracle??
Calling SqlDependency.Stop() in class destructor
UPDATE Statement with a JOIN Condition
[newbie] Execute SQL task bypassed, why ? [because of Source XML validation!]
Match numbers
Report Paramert problem
Determine Processor Architecture for SQL Server 2005
sql server 2005
CONTAINSTABLE inconsistency with phrase
The report is not formed

Programmatic export to Excel file

I would like to call reporting services programmatically and save the report to disk in Excel format.

I do this now via calls to Crystal Reports from VB .Net. Is there anyway to do this with Reporting Services

I still would be using VB .Net.

Answer this question

Programmatic export to Excel file

davidguygc
Yes, you can access a report server from another application using the web service. Here's a pointer to using the web service: http://msdn2.microsoft.com/en-us/library/ms154699.aspx
Programmatic export to Excel file

Answer this question