Click here to Skip to main content
15,171,303 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900