mnovosel

Figured it out. In the Series Expression, I set one as "On Time" and one as "Late". The Category Expression I set to the "Cycle" (date) and converted to string. The value expression was set for the Yes variable count for one of the bars and then I created another Dataset Item and did the same thing for the 'No' variable.

Here's what I tried to enter so far... /sites/default/files/images/Untitled(11).png

I thought I did this correctly, but the chart comes up with incorrect results. Here are the details... Value to display: Count of Y and count of N in the STRING field 'MISSED_SLA_FLAG' Horizontal Axis: Field 'CYCLE' (it is a Big Decimal but gives the date as YYYYMMDD). There should be two bars for each CYCLE (day). Day 20141121 could have 1 for 'N' and 9 for 'Y'. Those two bars should display together over that date. Then next to it would be the next day. Using parameters I will limit the report to just the last 7 days so space should not be a problem. What I currently have are two variables that I wrote, one to count the Y's and one to count the N's. The two differen variables look like this: $V(SLA Count Yes) = $F{IVUSER_IBC_CONFIG_FILE_CONTROLDATA.MISSED_SLA_FLAG} == 'N' ? 1 : 0 $V(SLA Count No) = $F{IVUSER_IBC_CONFIG_FILE_CONTROLDATA.MISSED_SLA_FLAG} == 'Y' ? 1 : 0 The counts in the variables are accurate. Is it possible to get each of these to display the sum for the day in bar form?

Greetings! I have a query which I will paste below. It's one of many and they all differ from one another but they relate to a series of reports. There are 15 reports in total which are complete. Each of these 15 reports (Jasper) is currently developed to run for one specific model in one specific region. Now that the design has been approved for each of them, I must replicate them for other models and other regions. There are 3 regions and 4 models for each report. The only thing that changes are the table names. For example I have a table called MAS_CFUS // CF is the model and US is the region. I can duplicate the report and simply change the name of the table to be MAS_CFEM (Europe) and do the same for our Japan region and I would end up with 3 reports that are almost identical except the table(s) names would be. MAS_CFUS MAS_CFJA MAS_CFEM Multiply that by the 4 different models (CF) and I would end up with 12 copies of essentially the same report. Then I would have to do this for all 15 of the reports and we're talking 170 reports. The reports are triggered automatically so it's not an issue from the maintenance of them, but in general is there a way to write the query over again in the same report and run one query or another based on an input parameter which I can pass along from the Jasper Reports? I'll post one of the queries below as a sample. Can anyone assist with how to package it for example to have a version for each of the regions above but in the same report? I've selected in bold in this example the two table names that I would need to change to read MAS_CFJA...and then again MAS_CFEM. Again the rest of the fields and data will remain identical. The back end of the tool I'm using splits the data into various tables this way which is beyond my control. **I'm also restricted from writing any temporary tables** SELECT CONCAT(KEYCON.CF_MODEL_NAME, ' - Input Values') as REPORT_NAME, TO_CHAR(TO_DATE(CF_APPLIED_ACCOUNTING_PERIOD, 'MON-yy'),'MON') as MONTH, TO_CHAR(TO_DATE(CF_APPLIED_ACCOUNTING_PERIOD, 'MON-yy'),'YYYY') as YEAR, KEYCON.CF_ENTITY as ENTITY, KEYCON.CF_CURRENCY as CURRENCY, 'Rec Prepared' as STATUS, KEYCON.CF_KEYWORD_ID as KEYWORD_ID, CONCAT(CONCAT(CONCAT(KEYCON.CF_PRODUCT, '('), KEYCON.CF_SUB_PRODUCT), ')') as PRODUCT, KEYCON.CF_MODEL_ID as MODEL_ID, KEYCON.CF_CCID as CCID, KEYCON.CF_BALANCE_TYPE as BALANCE_TYPE, KEYCON.CF_SOURCE_TYPE as SYSTEM_SOURCE, CASE WHEN KEYCON.CF_BALANCE_TYPE = 'Differential-YTD' THEN KEYCON.CF_CURRENT_YTD_VALUE - KEYCON.CF_PREVIOUS_YTD_VALUE ELSE KEYCON.CF_VALUE END AS CURRENT_MONTH, CASE WHEN KEYCON.CF_BALANCE_TYPE = 'Differential-YTD' THEN KEYCON.CF_CURRENT_YTD_VALUE ELSE KEYCON.CF_VALUE END AS CURRENT_YTD_MTD, CASE WHEN KEYCON.CF_BALANCE_TYPE = 'Differential-YTD' THEN KEYCON.CF_PREVIOUS_YTD_VALUE ELSE 0 END AS PREVIOUS_MONTH FROM ( SELECT KEYCON.* FROM (SELECT CF_MODEL_ID, CF_KEYWORD_ID, CF_CCID, CF_APPLIED_ACCOUNTING_PERIOD, MAX(UPDATETIME) AS MAX_UPDATETIME FROM MAS_CFUS_KEYCON_CONTROLDATA WHERE CF_MODEL_ID = $P{CF_MODEL_ID} AND CF_KEYWORD_TYPE = 'Input' AND CF_APPLIED_ACCOUNTING_PERIOD = $P{PERIOD} GROUP BY CF_MODEL_ID, CF_KEYWORD_ID, CF_CCID, CF_APPLIED_ACCOUNTING_PERIOD) MAX_KEY JOIN MAS_CFUS_KEYCON_CONTROLDATA KEYCON ON MAX_KEY.CF_MODEL_ID = KEYCON.CF_MODEL_ID AND MAX_KEY.CF_KEYWORD_ID = KEYCON.CF_KEYWORD_ID AND MAX_KEY.CF_CCID = KEYCON.CF_CCID AND MAX_KEY.CF_APPLIED_ACCOUNTING_PERIOD = KEYCON.CF_APPLIED_ACCOUNTING_PERIOD AND MAX_KEY.MAX_UPDATETIME = KEYCON.UPDATETIME ) KEYCON