umair
-
Posts
37 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by umair
-
-
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?
How to calculate SUM ??
in Products
Posted
I am kinda new to Jasper, iReports...
How do you sort them??:blush: