Date field parameters

[paauwtje]

 Hi Guys,

We created a query in iReport designer which is working.

The report should display the activities within a certain period.

We would like to fill in this period ourselfes.

In iReport designer it is working.

On Jasper Server it wil ask for 2 dates but after that it sin't showing anythin at all.

But in iReport designer it is showing the correct info.

 

Does someone has an idea what goes wrong overhere?

I attached the code we are using right now.

 

Code:

SELECT     DateDiff(MINUTE,work_report.from_time,work_report.to_time) AS TotalMIN,     work_report."service_req_id",     company."company_name",     service_req."request_user",     service_req."problem_type" AS First_lvl_category,     service_req."problem_sub_type" AS second_lvl_category,     service_req."third_level_category",     service_req."title" AS second_lvl_category,     service_req."solution" AS second_lvl_category,     work_report."from_time" AS second_lvl_category,     work_report."to_time" AS second_lvl_category,     work_report."description" AS Activity_descrFROM     "work_report" work_report INNER JOIN "service_req" service_req ON work_report."service_req_id" = service_req."id"     INNER JOIN "sysaid_user" sysaid_user ON service_req."request_user" = sysaid_user."user_name"     INNER JOIN "company" company ON sysaid_user."company" = company."company_id"WHERE     work_report.from_time BETWEEN $P{StartDate} AND $P{EndDate}

[bereure1]

having a similar issue here as well, I am hoping someone has a answer on this?

Post Edited by bereure1 at 02/29/2012 14:25

[mennei]

 Parameters are take effect in jasper server when they place as "input controls".

How do implement this in the server?

[paauwtje]

 Hi Mennei,

 

I'm sorry but I don't understand your question.

Would you like to know how to do it?

 

[mennei]

 When you configure the server to generate report, one of the requiered steps is to define "input control", that componant will prompt you to specify value when you choose the report.

Do you have a documention for the jasper server? (user guide or admin guide)

[nasha]

hi i m the be student we r doing automaded attendance system project in that we have to create report in jasper report using mysql database and apache tomcat bt we dnt find any way how to create that and how to connect mysql,tomcat and jasper report if u know plz help us...

[bereure1]

mennei
Wrote:

Do you have a documention for the jasper server? (user guide or admin guide)

I do not have this documentation, could you point me in the direction where I could find it? thanks in advance,

 

[mennei]

 try this:

http://jasperforge.org/plugins/mwiki/index.php/Jasperserver/Documentation