SSRS generating xls file
Hi,
we have couple of SSIS (Sql Server Intgration Services packages) which would generate .xls reports by querying data from SQL Server database. But this is not the efficient way of generating xls reports. rather SSRS would be more beneficial and meant for this sake I believe and would be of more performance also.
How do I generate a .xls file report from SSRS automatically? I mean rather than generating from the design window.
Currently we have created scheduled task for each of the SSIS package exe which would generate .xls file and store in some particular folder.
Now this has to be achieved in SSRS. Please help me If you have any ideas and forward me if you have any better links.
thanks in advance
Arun
|
