vsabbu

Post edited by: vsabbu, at: 2007/10/29 08:48

Hi All, Iam using jasper server 2.0.1 and ireport2.0.0 for my jasper reports. when i run the jasper report from the server directly iam not able to view PDF report. when i click on pdf(icon) then only i am able to view my report in pdf format. now my requirement is,when i run the report automatically i want to view my jasper report in PDF format.Iam not using any java code. Do I need to change any settings in ireport?? Please help me.its really urgent!!! Thanks for any reply. Post edited by: vsabbu, at: 2007/10/24 08:38 Post edited by: vsabbu, at: 2007/10/24 09:44

Iam also looking for the similar feature..any answers?

Hi All, Iam using ireport2.0.0 and jasper server 2.0.1.Using jasper server iam generating a report.My jasper report gives list of customers and their details. Now my question is when i run the jasper report iam able to generate a report for all the customers in a single pdf. i want to generate the pdf report based on customer.say now i have 3 customers in my db,3 pdfs should generated.My problem is i cant use any javacode. i have searched the forum but i didnt get any answer. Please anyone tell me is there any way to achieve this? Thanks Post edited by: vsabbu, at: 2007/10/23 09:25

Thanks mdahlman

Hi All I am looking for a way to let jasperserver create seperate pdfs while running just one report in order to send them as email attachement. For instance to split the Sample Report 'AllAccounts' into seperate files each for one country (or a file for each employee). Thanks for any help

Hi All my jasper report contains all the customers data from the database.If i select each customer individually iam able generate pdf for that particular customer. now my question is i want to generate a report for all the customers.it gives me single PDF.i cant send one customer details to other customer,soi want to generate/save my pdf based on the customer.iam not using any java code. can any one help me in resolving this issue? thanks for any reply

Hi All my jasper report contains all the customers data from the database.If i select each customer individually iam able generate pdf for that particular customer. now my question is i want to generate a report for all the customers.it gives me single PDF.i cant send one customer details to other customer,soi want to generate/save my pdf based on the customer.iam not using any java code. can any one help me in resolving this issue? thanks for any reply

Hi All.. My jasper report has one Customer input control(single select query-type)(select cust_name from customers). If i select any customer iam able get data from db for that particular customer..now my problem is i want to display data for all the customers... Please any one has answer reply me.. Thanks a lot for any reply..

Hi All.. My jasper report has one Customer input control(single select query-type)(select cust_name from customers). If i select any customer iam able get data from db for that particular customer..now my problem is i want to display data for all the customers... Please any one has answer reply me.. Thanks a lot for any reply..

Hi jimheng Thanks a lot for the reply. but iam not able to locate jasper.targetfile.Iam new to jasper reports infact this is my first jasper report.iam not writing any java code.iam using ireport2.0.0. and jasper server 2.0.1. where do i set jasper.targetfile in ireport or jasperserver?? please reply me? Thanks

Thankq for the answer swood

hi swood thanks for the reply.. I passed the date parameters to all the 4 subreports. But Iam getting sql exception. my first sub report has query is like this.. SELECT cust_name,tkt_cust_id,CUST_ID,SUM(CASE WHEN UPPER(tkt_notified) = 'Y' AND Tickets_Proc.Tic_Cust_Dev_Func_Rep(tkt_id) <>4 AND tkt_status <> 'R' THEN 1 ELSE 0 END) AS ack_met_open , SUM(CASE WHEN UPPER(tkt_notified) = 'Y' AND Tickets_Proc.Tic_Cust_Dev_Func_Rep(tkt_id) <>4 AND tkt_status = 'R' THEN 1 ELSE 0 END) AS ack_met_closed ,SUM(CASE WHEN UPPER(tkt_notified) = 'Y' AND Tickets_Proc.Tic_Cust_Dev_Func_Rep(tkt_id) =4 AND UPPER(tkt_status) <> 'R' THEN 1 ELSE 0 END) AS ack_brc_open , SUM(CASE WHEN UPPER(tkt_notified) = 'Y' AND Tickets_Proc.Tic_Cust_Dev_Func_Rep(tkt_id) =4 AND UPPER(tkt_status) = 'R' THEN 1 ELSE 0 END) AS ack_brc_closed ,SUM(CASE WHEN tkt_notified IS NULL AND Tickets_Proc.Tic_Cust_Dev_Func_Rep(tkt_id) =4 AND UPPER(tkt_status) <> 'R' THEN 1 ELSE 0 END) AS not_ack_brc_open ,SUM(CASE WHEN tkt_notified IS NULL AND Tickets_Proc.Tic_Cust_Dev_Func_Rep(tkt_id) =4 AND UPPER(tkt_status) = 'R' THEN 1 ELSE 0 END) AS not_ack_brc_closed , SUM(CASE WHEN tkt_notified IS NULL AND Tickets_Proc.Tic_Cust_Dev_Func_Rep(tkt_id) <> 4 AND tkt_status <> 'R' THEN 1 ELSE 0 END) AS not_ack_not_brc_yet_open ,SUM(CASE WHEN tkt_notified IS NULL AND Tickets_Proc.Tic_Cust_Dev_Func_Rep(tkt_id) <> 4 AND tkt_status = 'R' THEN 1 ELSE 0 END) AS not_ack_not_brc_yet_closed FROM TICKETS,customers WHERE tkt_cust_id=cust_id AND TRUNC(tkt_created_date) BETWEEN DATE($P{FromDate}) AND DATE($P{ToDate}) AND tkt_cust_id = CUST_ID AND tkt_cust_id=$P{CUST_ID} GROUP BY tkt_cust_id ,cust_name,cust_id FromDate and ToDate are the two input date controls.. Is this is the way of Passing parameters to the query? Please reply me. Thanks a lot

If anyone knows answer Please respond...i have deadline

Hi iam using jasper server 2.0.1.My jasper server report has 4 sub reports.when i run the reports it works fine. but all my 4 subreports queries have From date and Todate parameters.i manually gave the dates to generate the report and it works fine. i have added from date and todate input controls. Now problem is..all the 4 sub reports queries has to take these input dates and accordingly data should display from database. Please anyone spent some time and reply me. thanks a lot.