mrssnowy123

Hiie, i tried to show my output in a excel format. But all other information can be output in the excel format but not the graph. May i know where is my error? I wanna show the graph when i output it in an CSV view. Thanks for any help. =)

Hiie, i have a question. How do i write the SQL in such a way that when the user key in a value, i will be able to plot the line graph with the value that the user have juz input? Plaese help me with this. Thanks ALOT. =)

Hiie, i have a question here. i need to create a report with a line graph. inside the line graph, i need to have a bar/bar chart as well. is this possible? Please guide me along. Thanks alot. =)

Hiie, im new to Jasper, so i have a few questions to ask. First thing first, I have a field that is case_no, inside this case number, when i run the program, it will gives me many different case_no. From so many case_no, when i wanna click on a particular case_no. It will open up the a report in "website" view. I have tried right click on the case_no field, hyperlink type = reference. And how do i set the Hyperlink Reference Expression? I tried using: ($F{case_no}.equals("A04122008_80000429"))?"http://www.google.com":"http://www.google.com" It works, but all case_no opens up the website, where i already specifies that i wan this particular case_no to open up the URL only. Can anybody please help me. Thanks alot. =)

Hiie, im new to iReport and i need to do this task. I have information that i need to display onto the line graph by having 2 lines. one line is for Year07/08 and the other line for Year08/09. so its actually an overlap line graph, but i have to show them into 2 different seperate lines. How do i do that? Has it got to do with SQL statements? This is the SQL i have: select day,case when sum(complaint)>0 then sum(compliment)/sum(complaint) else 0 end) as 'cnt'from ( select day(case_date) as day, 'compliment' when =case feedback_type='COMPLIMENT' then 1else 0 end ,'complaint' when =case feedback_type='COMPLAINT' and ltrim(rtrim(merit))<>'' and cast(ltrim(rtrim(merit)) as int) < 0 then 1else from 0 end view_report_mainwhere case_date between '01-dec-08' and '31-dec-08') kgroup by day I would appreciate any help. Thanks in advanced! =) (

Thanks for the reply. But i have another question. is it true that i need to have 2 reports, one master report and another 'sub-report', so that when i click on the case number, it will open up the 'sub-report' right? Instead of that, is it possible not to have a already created 'sub-report' and when i click on the case number, it will generate the report itself? Thanks for any help. =)

Thanks for the reply. I actually threw some jar. files into my iReport version 2.0.4 which what JasperSoft have taught. Now i need to get started. Where should i start? I already have a master report with different case number. Thanks in advance. =D

Hiie, im veri new to jasper report. Im learning from scratch. so do pardon me if i ask stupid questions. First, currently im using iReport version 2.0.4 My requirement now is, i have a whole list of case number. So whenever i wanna look at the details of a certain particular case number, i will click on the hyperlink of that specific case number. and all details related to this case number will be displayed in another report. From what i know is, i have to make use of Jasper server in order to do that. As iReport is only a tool for designin. May i know, first step first. Do i download Jasper Server? And how will it works? Thanks in advance for any help. =)

Hi, i have a question here. Im currently using iReport Version 2.0.4 and i need to generate reports using hyperlinks. Meaning, when i click on a certain particular case number, whaterver information that is related to this case number will be generated. Is there a way i can do this? Please help if you can. Thanks in advance. =)