dpinfo
-
Posts
31 -
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 dpinfo
-
-
This is a bug of 1.2.5 You need to put in chart proprietise, in IncrementWhenExpression :
new Boolean("True")
For more information,please use the search forum
-
In the query you could do:
select .... from table
where
field_date = trunc(sysdate) - 1
This works in oracle
Bye
dpinfo
-
I think that a query might be the solution of your problem.
The query might be like this:
select a.field, b.firma AS FIRMA from a,b
where
a.id=b.id
In IReport you could show only $F{FIRMA} and not the key (a.id).
If you prefer you could create a view that shows all the field you need of table a and b.
The sintax is
create or replace view xxx as(
select a.field1 field1,a.field2, a.field3,b.firma
from a, b
where a.id=b.id)
and then you make all the queries on this view.
I hope that this help
Bye
dpinfo
-
You need only to select the static text box and then right click with mouse and choose Propierties.
Then choose the tab static text and change pre set text.
-
You have to create a variable for each one calculation and for each group. If for example you have group1 and group2 you need to create AVERAGE_TTD_GROUP1,AVERAGE_TTD_GROUP2,MAXIMUM_GROUP1, MAXIMUM GROUP2.
Configuration of AVERAGE_TTD_GROUP1
Variable name: AVERAGE_TTD_GROUP1
type: the same of the field with the value;
Calculation type : choose one of them. If you want for example to calculate the average choose average.
Reset type : choose group
Reset group : choose the group. If you have created 2 groups, you need to create 2 variables.
Variable expression : put the field on which you want to create the variable F{TTD}
Then click ok and drug and drop the variable in the group1_footer
Then make the same process for the average of group2 in order to create a variable AVERAGAE_TTD_GROUP2
For the maximun select in calculation tupe instead of average HIGHEST.
Bye
dpinfo
Dynamic field in sql
in Products
Posted
Hello,
I need to built a query where the field shown is composed with a parameter.
In oracle I do this with this sintax
select field&Num from table
and it works.
If I run the query Oracle ask me a value for the parameter Num.
In Jasper I have tried with :
select field$P{NUM} from table
but the error was : "SQL Problems : Ora-00923 : key word FROM don't found"
Please help me.
Bye
Dpinfo