July 16, 2010 at 3:02 am
Hello Experts,
I have got SQL table which has data coming from datawarehouse, all the calculations has been done in the table now next challenge is to bring the data to excel/word in specific format. I have got sales commission data in the table and now i want to put each record as a individual sheet belong to customer.
Is there any way i can pull the data from SQL into Excel or Word in a specific format ? each row of SQL table need to be a individual sheet/statement.
please help experts !!!
July 16, 2010 at 6:59 am
Fairly sure you would have to create some vba code in order to achieve this, which would open the required record set and the loop through each record doing as you require - or you might be able to use words mail merge.
Unless you have a reporting tool which you have access to such as SSRS and then you could create the report in the format required
July 16, 2010 at 7:06 am
As dave said, you can use SSRS reports to get the results back in the excel and with also the format which is required...
You can subscribe the reports to get the excel in the shared folder or thru email
Prashant Bhatt
Sr Engineer - Application Programming
July 16, 2010 at 7:15 am
I had this idea,
I am i am not to sure about the strength of SSRS, the format would be pretty much like an invoice but we its like monthly statement. do you have it is possible through SSRS ?
table have few hundred records.. we query and select the relevant every month but then each column of the table can be brought in ?
one row of the table will make one statement.. please let me know if this can be achieved through SSRS ?
last question
i know this is possible through crystal reports but is SSRS is similar to crystal ?
July 19, 2010 at 11:42 pm
Hi,
You can write one stored procedure and Call it through SSRS.
In SSRS you can display the data easily. So I dont see any issue in that.
Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply