lee.owens

Hello, I am building a crosstab report in JRS and I'm trying to calculate a daily average sales figure for each month. The report looks like the below The trading days calculation is set up dynamically for the last 3 months as a derived table, so i have 3 values for each of the previous months. I'm now trying to set up some logic, so that if the column header = 3 months ago, then divide the value by "Trading Days 3 Months Ago". If the column header = 2 months ago, then divide the value by "Trading Days 2 Months Ago" respectively. I have tried to play around with the IF and CASE WHEN functions in the cacluated field options, but I can't seem to make it work. Any ideas? Thank you

Hi Erickdel's That's worked perfectly. Thanks for your help erickdelsocorro

Hi Hozawa, That's worked perfectly. Thanks! Just one more thing to add, if I want to look at the previous month, where do I add the arguments for last month, 2 months ago etc? I've added a -1 in the Date() section but this shows January, not Feb. Thanks

Hi Hozawa, That's worked perfectly. Thanks! Just one more thing to add, if I want to look at the previous month, where do I add the arguments for last month, 2 months ago etc? I've added a -1 in the Date() section but this shows January, not Feb. Thanks

Hi all, I want to be able to use an expression inside a colum header to show the month name for previous 6 months for example. So instead of Month -1, Month -2, the expression would convert the month number to the month name. I've seen this function available in Crystal Reports and I've used it heavily, however the only thing I can see similar here is a Java expression. Is it possible in either JS Server or JS Studio? Thanks

Hi everyone, A couple of employees have complained about this one and I never thought it to be a problem. When you refresh a report in JasperReports Server, the page will automatically jump to Page 1. My question is: Can I set the "Current" report page to default when refreshing? Is it possible to extend the report size so that all the data appears on one page, in the same way that it does in a Ad Hoc View? Thanks

Thanks for the answers, guys. I'll try them out and see what works best. Thanks

Hi, I think you're talking about Excel... I'm trying to achieve the same result, but in Jaspersoft

Hi Forum, Is it possible to format values conditionally when comparing data between 2 columns? For example, IF Column A > Column B THEN Column C = "Yellow" It appears as if you can only conditionally format data with static values - Column A > 20 THEN "Red" for example. Thanks