alphabin

can anyone help me to get the percentage of a field to show in value expression of time series graph. If my values are 2,4,3,1 I want 20%,40%,30%,10% to show in my graph.Now I am getting like 100%,66%,33%,10%. Pls help

Thanks a lot.You really saved my life.

Hi,I am trying with crosstab with iReport 1.2.5. I have some problems in my printout.The same values are printing repeatedly.I am beginner in Jasper.Can u tell m e what must have went wrong.

giulio wrote: alphabin: It's not clear to me what you want to do. If you need to set a value for parameters in your app, you have to fill the parameters Map passed to the fillReport method of JasperReports. If you need to set a parameter value using your own code when running a report inside ireport, you can modify the parameter default expression using something like: new MyValueProvider().getValue() Where MyValueProvider is an utility class you can write with the method getValue(). Code: public class MyValueProvider { public MyStrangeType getValue() { // ... create my strange default... return my strange default } } loyalman: Your approach is fine. Please note that if you want the query: select * from orders where order_name='test' the value of $P{order_name} must be test and NOT 'test' Giulio The problem not solved yet.I will explain the thing clearly. I want to pass a value "E17" as parameter to SQL query String. My query is select flno,psta FROM AFTTAB where PSTA=$P{PSTA} My HashMap parameter is ("PSTA","E17") But I cannot get the corresponding pages. But If I eneter query select flno,psta FROM AFTTAB where PSTA='E17' I m getting output. My DB is Oracle.Please help.

Ok,I am a starter in Jasper Reports.I will explain clearly. I am using iReports for designing.I added a parameter which is of string type and in the report query I made the query as select * from orders where order_name=$P{order_name} when I run the report I entered test when the prompt came for order_name.But it is telling no documents found.But if I replace my query with select * from orders where order_name='test' I am getting output.when I tested with numbers the output is coming.I tried select * from orders where order_name="'"+$P{order_name}+"'" But binding variable error is coming. My database is Oracle.

Hi, I want to know how to pass string parameter to query string for Oracle.I did select * from orders where order_name=$P{order_name} I passed the value thru the prompt.But it is not showing any records.But if I replace same directly in SQL query,it works.can u help me on this.