SQL Reports that need to go to different people but each person's report has different

Question

SQL Reports that need to go to different people but each person's report has different

krisna

SSC Enthusiast

Points: 106
More actions
April 25, 2012 at 10:19 pm

#392114

I have table like this.
Name email product state country
1.sam, sam12@gmail.com, chain, TX, U.S.
2.sam, sam12@gmail.com, bolt, TX, u.s
3.Krish, krish13@gmail.com, wire, GA , u.s
4.Krish, krish13@gmail.com, pen GA, u.s
I need to send report to sam
product state country
chain, TX, U.S.
bolt, TX, u.s
i need send report to krish
product state country
wire, GA, u.s
pen, GA, u.s
Same thing i need repeat nearly 200 different nmes. As example i shown we not suppose send one person data to another, please help me to generate report and how to subscribe to individual person email.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Mark Fitzgerald-331224 SSCrazy Eights Points: 8489 More actions · Answer 1

kishore.sqlbi (4/25/2012)
I have table like this.
Name email product state country
1.sam, sam12@gmail.com, chain, TX, U.S.
2.sam, sam12@gmail.com, bolt, TX, u.s
3.Krish, krish13@gmail.com, wire, GA , u.s
4.Krish, krish13@gmail.com, pen GA, u.s
I need to send report to sam
product state country
chain, TX, U.S.
bolt, TX, u.s
i need send report to krish
product state country
wire, GA, u.s
pen, GA, u.s
Same thing i need repeat nearly 200 different nmes. As example i shown we not suppose send one person data to another, please help me to generate report and how to subscribe to individual person email.

Which licence of SQL server do you have? If Enterprise then create a report with parameters and then create data driven subscriptions.

http://msdn.microsoft.com/en-us/library/ms159150.aspx

http://msdn.microsoft.com/en-us/library/ms169673.aspx

Fitz

Andy Hyslop SSCrazy Eights Points: 9198 More actions · Answer 2

Mark Fitzgerald-331224 (4/26/2012)
kishore.sqlbi (4/25/2012)
I have table like this.
Name email product state country
1.sam, sam12@gmail.com, chain, TX, U.S.
2.sam, sam12@gmail.com, bolt, TX, u.s
3.Krish, krish13@gmail.com, wire, GA , u.s
4.Krish, krish13@gmail.com, pen GA, u.s
I need to send report to sam
product state country
chain, TX, U.S.
bolt, TX, u.s
i need send report to krish
product state country
wire, GA, u.s
pen, GA, u.s
Same thing i need repeat nearly 200 different nmes. As example i shown we not suppose send one person data to another, please help me to generate report and how to subscribe to individual person email.
Which licence of SQL server do you have? If Enterprise then create a report with parameters and then create data driven subscriptions.
http://msdn.microsoft.com/en-us/library/ms159150.aspx
http://msdn.microsoft.com/en-us/library/ms169673.aspx
Fitz

Yep

And if you don't have enterprise your out of luck I'm afraid - to my knowledge you will have to set them all up individually..

Andy

==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

krisna SSC Enthusiast Points: 106 More actions · Answer 3

yes, i am using enterprise only, can give me query to get particular person data, main problem with sending email to particular person, can you provide detail query to send email.

Mark Fitzgerald-331224 SSCrazy Eights Points: 8489 More actions · Answer 4

kishore.sqlbi (4/26/2012)
yes, i am using enterprise only, can give me query to get particular person data, main problem with sending email to particular person, can you provide detail query to send email.

Follow the links provided in the first response. One of them is a walkthrough of data driven subscriptions including creating the table and setting up the subscription itself.

Fitz

krisna SSC Enthusiast Points: 106 More actions · Answer 5

Thank you, by the end of day i got result with data driven subscription.