#1 2018-05-18 16:03:51

Sai Prasad
Member
Registered: 2017-09-14

Jasper Report Scheduling by using Parameters

Hi,

First I need to thank ReportServer for providing community edition for our basic needs.

We are testing some of Jasper reports in report server and working as expected. Now we had issues in scheduling Jasper reports using Parameters.

I want to schedule Jasper report based on parameters and send this report via email.  Please share step by step process to do this.

Example:

P_obj_id has 1-100 range

Parameter Name: p_obj_id = 22

send this obj=22 to user 'test' via email as test@test.com


Thanks ,
Sai

Offline

#2 2018-05-22 07:18:47

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Jasper Report Scheduling by using Parameters

Hi Sai,

what do you mean exactly by "schedule based on parameters " ? what is P_obj_id ? What is the range you describe ?

Regards,
Eduardo

Offline

#3 2018-05-22 15:22:39

Sai Prasad
Member
Registered: 2017-09-14

Re: Jasper Report Scheduling by using Parameters

HI Eduardo

I Created Jasper report which as Parameters/ Filters. When I preview report based on parameters report runs well.

Example: Parameter Name =22 then report shows with ID = 22.

But when I schedule report , I'm receiving an email attachment with complete data.

Example: Report attachment has ID= 1, 2 , 3 ........22, 24, 25

Now I want to email report based on Parameters /Filters.

Last edited by Sai Prasad (2018-05-22 15:24:31)

Offline

#4 2018-05-23 06:44:53

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Jasper Report Scheduling by using Parameters

Hi Sai,

why don't you just save a variant with all parameters, columns and filters set, and schedule this variant? In this way, the exact configuration you save will be sent per email. In this case, you can save the Parameter Name = 22 and your filters along with your variant. Then schedule this variant, *not* the parent report.

Regards,
Eduardo

Offline

#5 2018-05-25 13:25:34

Sai Prasad
Member
Registered: 2017-09-14

Re: Jasper Report Scheduling by using Parameters

Thanks Eduardo, Issues solved.

Offline

Board footer

Powered by FluxBB