December 12, 2011 at 2:53 am
Hi All,
I've created a Top 20 report on customers by turnover which i'm emailing on the 1st of every month. I now need to email a report for each customer in the Top 20 which contains the details (by product).
My ideal solution would be tabs in an excel file otherwise as separate workbooks/csv's.
Question 1 : Can i dynamically run individual reports based on the accounts in my top 20 list? where do i begin?
Question 2 : Can i output to the same excel/csv file on a different tab?
Thanks
December 13, 2011 at 7:34 am
Run the query for the top 20 and then loop through it, running additional queries.
In T-SQL, I'm not sure how easy this is. In SSIS, you can create a new "table" in a package in your Excel file, which I believe should create separate tabs.
http://www.rafael-salas.com/2008/03/ssis-and-dynamic-excel-destinations_01.html
December 13, 2011 at 8:43 am
Steve Jones - SSC Editor (12/13/2011)
Run the query for the top 20 and then loop through it, running additional queries.In T-SQL, I'm not sure how easy this is. In SSIS, you can create a new "table" in a package in your Excel file, which I believe should create separate tabs.
http://www.rafael-salas.com/2008/03/ssis-and-dynamic-excel-destinations_01.html
Steve, I'm disappointed. I thought you knew every single article ever published here. :hehe:
This may help if you want to do this soley in TSQL and SSRS. --> http://www.sqlservercentral.com/articles/Development/2824/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 13, 2011 at 2:18 pm
Hardly, too many articles to keep track of. :w00t:
That uses SSRS. While that's the preferred method, if you don't have an SSRS server, I don't want to give you another project. However if you do, read Jason's article.
December 13, 2011 at 3:31 pm
Steve Jones - SSC Editor (12/13/2011)
Hardly, too many articles to keep track of. :w00t:That uses SSRS. While that's the preferred method, if you don't have an SSRS server, I don't want to give you another project. However if you do, read Jason's article.
As usual Steve, I read the post so quick I "assumed" that's how the OP was doing it (SSRS). I really need to slow down. 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgViewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply