umair

One note, ensure you data is sorted (can be done in with the JR sorting option, or in the SQL if your report has an SQL query) by date field to ensure the grouping is inclusive across your data. I am kinda new to Jasper, iReports... How do you sort them??:blush:

Well, i believe you do have a perfect explanation. I have a rectangle which displays a specific color. On that rectangle, i have the names of the columns being shown as Static Text. The handles of these statix text boxes are green. And i am not able to see the rectangle on HTML preview. So, how would i be able to have color on a whole row on the Column Names?

I appreciate your help. It works fine now. Thanx a lot

I cannot see the colors of the report in HTML preview. The same thing works fine if viewed in PDF or other viewers. It fails in HTML preview only.

I am using Jasper 3.0. I don't see any problem of Pagination in that. But here's a strange thing, The colors which i use in my report are not showing in HTML previews only. I can see the colors in all other views but they wont show in HTML. WHy is that ??

Hey guys! I have a scenario in which i want to display Sales for each day. On any specific day, there can be 1 or more then 1 sales. I thus need to show the SUM of sales on that particular date too. What i did was, i arranged the result on ireport as Grouped by on Date. But, i am confused as how would i show the total for each date. I would sure appreciate any help.

I made a custom report in iReport and uploaded it to Jasper Server. When the report is run in iReport, it runs fine, but when i run it in Jasper Reports, it only displays me the first page. I can see "Page 1 of 2" written at the bottom(which shows there are more then 1 pages), but i dont see any control to jump onto next page. When i view the report as pdf from within Jasper server, it shows me complete 2 pages. The HTML view is not showing all pages.

Heres what i did, View->Parameters->New ParameterName: LoggedInUser ClassType: String UseAsPrompt: checked Applied a Text Field with expression definition as "$P{LoggedInUser}.getFullName()". Saved the report, uploaded the jrxml file and ran to see the following errors: com.jaspersoft.jasperserver.api.JSExceptionWrapper: Errors were encountered when compiling report expressions class file: 1. The method getFullName() is undefined for the type String value = (java.lang.String)(((java.lang.String)parameter_LoggedInUser.getValue()).getFullName());//$JR_EXPR_ID=12$ <---------> 2. The method getFullName() is undefined for the type String value = (java.lang.String)(((java.lang.String)parameter_LoggedInUser.getValue()).getFullName());//$JR_EXPR_ID=12$ <---------> 3. The method getFullName() is undefined for the type String value = (java.lang.String)(((java.lang.String)parameter_LoggedInUser.getValue()).getFullName());//$JR_EXPR_ID=12$ <---------> 3 errors com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. The method getFullName() is undefined for the type String value = (java.lang.String)(((java.lang.String)parameter_LoggedInUser.getValue()).getFullName());//$JR_EXPR_ID=12$ <---------> 2. The method getFullName() is undefined for the type String value = (java.lang.String)(((java.lang.String)parameter_LoggedInUser.getValue()).getFullName());//$JR_EXPR_ID=12$ <---------> 3. The method getFullName() is undefined for the type String value = (java.lang.String)(((java.lang.String)parameter_LoggedInUser.getValue()).getFullName());//$JR_EXPR_ID=12$ <--------->

What i need is to transfer the user name of the user logged in Jasper Server to the report made by Jasper Reports. How would i achieve that ?

Is there any support for Global Variables in Jasper Reports? Like, if i want to retrieve the name of the user logged in.. Is this possible?

Hello! I have a situation in which i read the record of the country from a file and load them into MYSQL DB. The loading works just fine. The primary key 'country_id' has 'Auto_Increment' set to it which ensures that this column is automatically updated every time a new field is read from the file and loaded into the table. Now the problem is, this scenario works fine for the first run. Now, if i run the job second time, this would insert the same country data into the table with new primary key values. Thus resulting in duplication of records. What i need is that if the record needs to be updated, then the primary key should remain constant instead of incrementing. I tried using Update or Insert / Insert or Update but same results. Any workaround against this problem ?

I am using Jasper ETL 2.3.1. The operation i want to perform is very simple. Read from a CSV file and populate the corresponding record in MySQL Table, Country. The structure of Table 'Country' is: Country_Id Country_Name MCC CC I loaed a tFileInputDelimited and tMySQLInput component. I attached the two using a TMAP Component. When i ran the ETL tool, i received the following error: Exception in component tMysqlOutput_3 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'colname' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:353) at com.mysql.jdbc.Util.getInstance(Util.java:336) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710) at com.mysql.jdbc.Connection.execSQL(Connection.java:2436) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1402) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1694) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1608) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1593) at sample_etl.testjob_inkfish.TestJob_InkFish.tFileInputDelimited_1Process(TestJob_InkFish.java:453) at sample_etl.testjob_inkfish.TestJob_InkFish.runJobInTOS(TestJob_InkFish.java:678) at sample_etl.testjob_inkfish.TestJob_InkFish.main(TestJob_InkFish.java:597) This was strange. There was no column 'colname' in my DB. I tried debugging the problem and saw that when i changed the column name 'Country_Name' to anything other then 'Country_Name', it worked fine without any warnings or errors. The problem only occured when the DB field was named 'Country_Name'. I changed it to 'Country_Name2' and it worked fine. This is really strange. Can anyone help me in realizing the problem? Can it be a bug?