kurky17

Hi all, I have a table like the one below: tablename: daily_totals packageID total_bytes date 0123 10 2009-01-01 0123 20 2009-01-02 0124 10 2009-01-01 0124 20 2009-01-02 0125 10 2009-01-01 0125 20 2009-01-02 I need to create a chart based on what package ID the user wants to show with the date as the Xaxis and the total_bytes as the Y-axis. He can choose one, or many packages. He also has the option to choose ALL. Which means, my chart legend can be the one below if he chooses to show everything: Package 0123 Package 0124 Package 0125 All*The ALL option is simply summing up the total_bytes of all packageIDs in a given date. My sql query for per package will be something like: SELECT packageID, total_bytes, date FROM daily_totals WHERE packageID = 0123 Result: packageID total_bytes date 0123 10 2009-01-01 0123 20 2009-01-02 My sql query for All Packages will be something like: SELECT sum(total_bytes), date FROM daily_totals GROUP BY date Result: total_bytes date 30 2009-01-01 60 2009-01-02 No, I can't do a UNION because i don't think i can do away with the packageID field for the first query. How can I show these data on a chart? My chart legend should have packageID 123 and ALL. Please help me. Thanks, Michelle

Hi, I'm going to use the direct URL to generate my report and as much as possible, I only want the charts to show. I already managed to remove the heading by doing decorate=no. Now I want to get rid of the small buttons for PDF, XLS etc on the upper left corner of the page. Anybody knows how to do it? Ideally it would be just be another URL parameter like buttons=no. Thanks, Michelle

Hi sorry for being so noobish about this, but can you pls explain a little how i'm supposed to use the code? I saw a chunk of code commented out, should i separately paste it in a different php file? Thanks.

Hi, I am having problems with multiple value query (checkbox) input control type. In my jrxml file, I have this parameter: <parameter name="PackageID" class="java.util.String" isForPrompting="true" /> and I want to produce checkboxes with corresponding PackageID values for my input control. Now, when I preview my report on jasperserver, it does indeed show the checkboxes, but after I choose a few and run my report, it gives me the ff error: Unknown parameter type java.lang.String for multiple value input I have read from old forum posts about using java.util.Collection and it gives me a different error. And this time, it doesn't even display the checkbox interface. Anybody who can help me with this? Thanks, Michelle EDIT: Nevermind about this question, I was able to solve it using: java.util.Collection as my parameter type and $X{IN, table_fieldname, parameter_name} in my WHERE statement. Post Edited by kurky17 at 06/21/2010 09:04

I'm also having the same problem. I'm using fedora core 12. There is no ireport.sh, only ireport.

Can anybody who's running JasperReports on Linux paste his/her environment variables settings here? I just want to have an idea. Thanks

Hi, I'm very new to JasperReports and Java and I'm currently following the book Jasper Reports for Java developers. I created a FirstReportCompile.java which is suppose to compile FirstReport.jrxml. WHen I try to compile the java file like this: # javac FirstReportCompile.java It returns the ff errors: 1. ERROR in FirstReportCompile.java (at line 2) import net.sf.jasperreports.engine.JRException; ^^^^^^ The import net.sf cannot be resolved ---------- 2. ERROR in FirstReportCompile.java (at line 3) import net.sf.jasperreports.engine.JasperCompileManager; ^^^^^^ The import net.sf cannot be resolved ---------- 3. ERROR in FirstReportCompile.java (at line 11) JasperCompileManager.compileReportToFile( ^^^^^^^^^^^^^^^^^^^^ JasperCompileManager cannot be resolved ---------- 4. ERROR in FirstReportCompile.java (at line 15) catch (JRException e) ^^^^^^^^^^^ JRException cannot be resolved to a type ---------- 4 problems (4 errors) Anybody who can help? This might be a problem with installation. I am on Fedora 12, running JDK 1.6.0_20. My jasperreports directory is: /opt/jasperreports My jasper project files directory is: /home/username/JasperFiles/first My java dir is: /usr/java/jkd1.6.0_20 Thanks, Michelle