Jasperserver report dynamic select query according to scheduled report recievers

Hi,

I have some data as the table below. I want to send report to owner of  each data by email which displayed  at the "Email" column . So , is  there any way to prepare report for each  User and then, run a scheduled job for that report and send email to that User. ( I am using Jasperserver 6.0.3 )

MY RAW DATA:

Data Usage(MB) User Email Date
550 Alice alice@alice.com 16.01.2017
860 Bob bob@bob.com 16.01.2017
1450 Charlie charlie@charlie.com 16.01.2017
230 Dave dave@dave.com 16.01.2017
475 Evelyn evelyn@evelyn.com 16.01.2017
900 Alice alice@alice.com 17.01.2017
160 Bob bob@bob.com 17.01.2017
340 Charlie charlie@charlie.com 17.01.2017
2560 Dave dave@dave.com 17.01.2017
1175 Evelyn evelyn@evelyn.com 17.01.2017

 

RESULT FOR ALICE:

Data Usage(MB) User       Email         Date
550 Alice        alice@alice.com     16.01.2017
900 Alice alice@alice.com 17.01.2017

 

omer.tasci's picture
Joined: Mar 13 2017 - 12:15am
Last seen: 5 years 1 month ago

0 Answers:

No answers yet
Feedback
randomness