justin.brown11

FYI For anyone who stumbles across this. The fix is relatively simply, Just treat each line seperately. WHERE (START_DATE >= $P{REPORT_START_DATE} OR $P{REPORT_START_DATE} IS NULL)AND (START_DATE <= $P{REPORT_END_DATE} OR $P{REPORT_END_DATE} IS NULL)

@Sad H - Can you elaborate? Adding "!" Just to the $P's just gives me errors and went breaking it down to just: (D552M.CODE_START_DATE >= $P!{1.REPORT_START_DATE} AND D552M.CODE_START_DATE <= $P!{2.REPORT_END_DATE}) Doesn't help either..

Hi all, I've got a simple SQL query that I'm trying to get optional between date parameters working for. At the moment, I've got this working: SQL-wise it should simply just be: WHERE START_DATE BETWEEN START_DATE AND END_DATE Jaspersoft-wise the input controls need to be optional WHERE (START_DATE >= $P{REPORT_START_DATE} OR $P{REPORT_START_DATE} IS NULLAND START_DATE <= $P{REPORT_END_DATE} OR $P{REPORT_END_DATE} IS NULL)Problem is, whilst I'm getting no errors when both the REPORT_START_DATE and REPORT_END_DATE are populated I'm seeing start dates that are greater than the report end date? Edit: Adding AND ($X{BETWEEN, CODE_START_DATE, $P{1.REPORT_START_DATE}, $P{2.REPORT_END_DATE}}) to the end of the SQL Script gives me an "Unrecognized SQL ecape 'Between'" error. :(

Good afternoon, So I'm slowly making progress with charting, I've managed to get my bars in order (finally!) and starting to muck about with the bar colours but one main issue remains. Now that I've got my bars in order (IE. Jan-18, Jan-17) I need to be able to group these columns together into just 'January' in the legend. So far: Each month is a seperate field, so $F{Jan-17} and $F{Jan-18} would need to be grouped together to simply form 'January' but I've not clue where to do this? (Category ? Series ?) Any help is much appreciated.

I've managed to work this out myself (Thanks for the tip about the summary). My workaround for this appears to work for only bar charts (but nonetheless). What I've done is alter my SQL output slightly to output everything to one line, in my dataset I've only dealing with two specified years ($P{YEAR} and $P{YEAR}-1). The ordering of the bars as mentioned below appears to order the fields from left to right meaning I can use field names such as Jan-18 and Jan-17 in order to correct the ordering. https://community.jaspersoft.com/wiki/how-change-order-bars-html5-column-chartHowever, because the years are user-specified I've simply used the label expression: "Jan-" + $F{CURR} and "Jan-" + $F{PREV}. The drawbacks are: I've had to add each month twiceThis only appears to work for bar-chart type charts.

Hi prusyn, I've added the chart into the summary band and you are indeed correct, Now I'm only seeing one chart. The issue now is that both the 2018 and the 2017 results are added together as if the chart isn't grouping on the year. What am i doing wrong? :( Here is what the "Year" category looks like:

Hello there, I'm having a problem displaying a small table as a bar chart using the HTML5 Pro tool in Jaspersoft Studio Pro 6.2.0. Here is what my SQL output looks like: In Jaspersoft I'm ending up with two charts, with both 2018 and 2018 figures added together (Essentially a duplicated chart). My chart configuration looks like this: I've already checked the following: https://communities.ca.com/thread/241761121-jaspersoft-studio-561-html-chart-multi-value-parameterhttps://community.jaspersoft.com/questions/801726/how-use-html5-chartsAnd the iReports manualThe report is located in the details band, the evaluation time is set to "Report", The "Reset Type" is set to "Report" under the Dataset tab, and I can't set a "Increment Type" because there are no groups. The chart (after adding it to the summary band) looks like this: I'm trying to group the months from 18/17 side by side. Please help? :c