zh3ntil
-
Posts
122 -
Joined
-
Last visited
Community Answers
-
zh3ntil's post in my jrxml just can find only one row was marked as the answer
You should use group bands or detail band for fetching data not column bands.
-
zh3ntil's post in Having a problem with variables and the IF function was marked as the answer
IF($F{partnumber}=="90000013",$F{qty},0.00)
or
IF($F{partnumber}.equals("90000013"),$F{qty},0.00)
-
zh3ntil's post in How to create query based on parameter value? was marked as the answer
You should use param1 with exclamation mark and param2 would be defined before param1 on the parameters list. Because param1 should be proccessed after param2 to be generated properly.
SELECT * FROM mytable WHERE $P!{param1}
-
zh3ntil's post in Error when trying to use relative dates was marked as the answer
Try this:
<parameter class="net.sf.jasperreports.types.date.DateRange" name="BeginDate"> <defaultValueExpression> <![CDATA[new net.sf.jasperreports.types.DATE.DateRangeBuilder("WEEK-14").toDateRange()]]> </defaultValueExpression></parameter><parameter class="net.sf.jasperreports.types.date.DateRange" name="EndDate"> <defaultValueExpression> <![CDATA[new net.sf.jasperreports.types.DATE.DateRangeBuilder("WEEK-1").toDateRange()]]> </defaultValueExpression></parameter>[/code] -
zh3ntil's post in How to create extrapolation in line graph in jasper? was marked as the answer
You can do that using highcharts (HTML5 Charts) api.
http://jsfiddle.net/gh/get/jquery/1.7.2/highslide-software/highcharts.com/tree/master/samples/highcharts/series/color-zones-dashstyle-dot/
-
zh3ntil's post in Groups with subtotals, is there an esier way? was marked as the answer
you don't need to give an increment type for this case. Try 'None' for increment type.
-
zh3ntil's post in Subreports Not Displaying was marked as the answer
Hi,
<subreportExpression><![CDATA["repo:Sub.jrxml"]]></subreportExpression>
-
zh3ntil's post in how to group records in table which are not in order was marked as the answer
First, Create a sort field in outline window on studio and sort column. Then create a group for that column. Use group header and footer for grouped field.
-
zh3ntil's post in The job failed to execute. Review its parameters was marked as the answer
javax.mail.internet.AddressException: Illegal address in string ``'' at org.springframework.mail.javamail.MimeMessageHelper.parseAddress(MimeMessageHelper.java:708)
check the mail address in scheduler. it seems there are some invalid characters.
-
zh3ntil's post in Use an input control to determine which fields are selected in query was marked as the answer
Hi,
You should use dynamic queries for that kind of report.
Create a parameter named 'chosenField' and its type will be 'java.Lang.String'. And its default expression would be sth like:
IF($P{InputList} = ="country","s.country",IF($P{InputList} = ="state","s.state",IF($P{InputList} = ="city","s.city","s.district")))
So, this parameter holds a string according to selected value. Like If you choose country than that parameter holds "s.country". That means your field is ready to use in query :)
After that your dataset should be :
SELECT$P!{chosenField} AS locality,SUM(s.sales) AS sales FROM sales_table sGROUP BY $P!{chosenField} So your field is generated according to chosen value. You should create your parameter after the parameter that holds your input control value not before it is important because input control's parameter should get the value before chosenField parameter is generated. Take care. -
zh3ntil's post in User Access in Jaspersoft was marked as the answer
Login as superuser and go to repository. Right click on folder and go permissions.
-
zh3ntil's post in SubReport with a Different Data Adapter was marked as the answer
Try this. It will solve your problem.
http://community.jaspersoft.com/questions/951636/subreport-close-connection
-
zh3ntil's post in Error publishing report with Sub Reports to JasperReports Server from Jaspersoft Studio was marked as the answer
Hi,
There is no *.jasper file in your repo. Change the the subreport path to "repo:ActiveUserRatio.jrxml" and try again. Probably it will work.
