alexal

Hi! I am using 30-day trial of Simba O2X, but I have trouble connecting it to jasperserver. It seems that I just can't understand what URL of the XMLA data source I should use. Could you please give an adice what should I do to import, for example, standard foodmart pivot in excel? I hope it would be enough to understand how it all works. Thanks

I've downloaded Wharehouse Explorer and connected to ip:port/jasperserver/xmla. It shows only foodmart and shugar cubes. My own analysis views have only mondorian connections defined right now, so they can be viewed from the browser. What should I do on server-side to make whex see them too?

Hello. I have created a report, which looks like this: Group 1 a 5 /*5=$F{Count}*/ b 13 c 2 Sum: 20 /*20=$V{Count_1} aggregated as sum from $F{Count}*/ Group 2 d 2 e 8 Sum:10 I want to modify it to look like this: Group 1 a 5 25% b 13 65% c 2 10% Sum: 20 /*20=$V{Count_1} aggregated as sum from $F{Count}*/ Group 2 d 2 20% e 8 80% Sum:10 I tried to use $F{Count}/$V{Count_1} expression. The problem is, that sum is calculated for each row and so only final row's percentage displays correctly (c and e rows in my example). The first one (a, d) would always show 100%. How can i make this persentage to display correctly and use variable value wich is displayed in group footer?

OK, this was in faq http://jasperforge.org//uploads/publish/jasperreportswebsite/trunk/faq.html#FAQ9. From the first glance it was not an overlap situation, but it ended to be one.

I use reports with parameters (via input controls, parameter names are taken from DB). These reports are designed for call-centers and there can be lots of users (agents) there. It's painful to chek them manualy every time you generate a report. So, the question is: how do I create a checkbox with 'select all' feature?

I use reports with parameters (via input controls, parameter names are taken from DB). These reports are designed for call-centers and there can be lots of users (agents) there. It's painful to chek them manualy every time you generate a report. So, the question is: how do I create a checkbox with 'select all' feature?

Hi everyone! I have problems displaying report in JasperServer standard preview. I find some lines, titles and cells missing. Please check the attachments to understand what I mean. I want to see report with all its elements from the beggining and still been able to print/export it. It shows everething in pdf or flash view and was made in iReport.

Thank you for navigating!

Hi everyone! I am creating an OLAP cube scheme in JasperAlalysis Workbench. I have a calculated member wich calculates an average time (in seconds, double). I want to show it in hh:mm:ss format. What should I do to achieve it? In FormatString field I only understand (for now) how to show it as % and with any desired number of sibols after dot, but nothing else. So, once again. How to show double value in HH:MM:SS format using JasperAlalysis Workbench?

Hi everyone! Not exactly an iReport question, but it never hurts to try. I am creating an OLAP cube scheme in JasperAlalysis Workbench. I have a calculated member wich calculates an average time (in seconds, double). I want to show it in hh:mm:ss format. What should I do to achieve it? In FormatString field I only understand (for now) how to show it as % and with any desired number of sibols after dot, but nothing else. So, once again. How to show double value in HH:MM:SS format using JasperAlalysis Workbench?

Hello everyone! I have created a conditional style to use in a crosstab. In this crosstab I have service level data (in %). Conditions look something like this: $V{SERVICE_LEVELMeasure}>=0.8 When service level is more then 80% the cell appears blue, else - yellow. It works OK. Now I want to make 0.8 a parameter so I can vary the point of color change.So I created a double parameter in main report with default value 0.8 and printed $V{SERVICE_LEVELMeasure}>=$P{SLevel} But I get the following error: net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : 1. Parameter not found : SLevel at net.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:258) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:140) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:215) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:131) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:514) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) I also tried to create a crosstab parameter with the same name and $P{SLevel} value, but it changed nothing. Can you give me an advice how to handle it? Thanks in advamce!

This is the reason I love open source so much!

Is there any way to prevent the downloading of JRXML from JS? I've created several reports in iReport and I don't want to share them with the client. The server will be located on client's side. Thanks in advance!

I use conditional styles to have different background colors for cells in crosstab. The color depends on the value of the cell. There is a certan breakpoint (if value>=breakpoint the color is blue, else - red). I whant to make this breakpoint a parameter. But if I define it in "Parameters" section, I get the following error: net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : 1. Parameter not found : BREAKPOINT at net.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:258) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:140) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:215) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:131) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:514) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Compilation running time: 37 I also tried to ad a param. into the crosstab, but the error was: net.sf.jasperreports.engine.JRException: Error compiling report design. at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:229) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:215) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:131) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:514) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: net.sf.jasperreports.engine.JRRuntimeException: Expression ID not found for expression <<$P{BREAKPOINT}>>. at net.sf.jasperreports.engine.base.JRBaseObjectFactory.getCollectedExpressionId(JRBaseObjectFactory.java:480) at net.sf.jasperreports.engine.base.JRBaseObjectFactory.getExpression(JRBaseObjectFactory.java:457) at net.sf.jasperreports.engine.JRAbstractObjectFactory.getExpression(JRAbstractObjectFactory.java:238) at net.sf.jasperreports.engine.base.JRBaseParameter.<init>(JRBaseParameter.java:99) at net.sf.jasperreports.crosstabs.base.JRBaseCrosstabParameter.<init>(JRBaseCrosstabParameter.java:50) at net.sf.jasperreports.engine.base.JRBaseObjectFactory.getCrosstabParameter(JRBaseObjectFactory.java:1593) at net.sf.jasperreports.crosstabs.base.JRBaseCrosstab.copyParameters(JRBaseCrosstab.java:125) at net.sf.jasperreports.crosstabs.base.JRBaseCrosstab.<init>(JRBaseCrosstab.java:98) at net.sf.jasperreports.engine.base.JRBaseObjectFactory.visitCrosstab(JRBaseObjectFactory.java:1508) at net.sf.jasperreports.crosstabs.design.JRDesignCrosstab.visit(JRDesignCrosstab.java:285) at net.sf.jasperreports.engine.JRAbstractObjectFactory.getVisitResult(JRAbstractObjectFactory.java:88) at net.sf.jasperreports.engine.base.JRBaseElementGroup.<init>(JRBaseElementGroup.java:83) at net.sf.jasperreports.engine.base.JRBaseBand.<init>(JRBaseBand.java:80) at net.sf.jasperreports.engine.base.JRBaseObjectFactory.getBand(JRBaseObjectFactory.java:560) at net.sf.jasperreports.engine.base.JRBaseSection.<init>(JRBaseSection.java:87) at net.sf.jasperreports.engine.base.JRBaseObjectFactory.getSection(JRBaseObjectFactory.java:540) at net.sf.jasperreports.engine.base.JRBaseGroup.<init>(JRBaseGroup.java:117) at net.sf.jasperreports.engine.base.JRBaseObjectFactory.getGroup(JRBaseObjectFactory.java:520) at net.sf.jasperreports.engine.base.JRBaseVariable.<init>(JRBaseVariable.java:105) at net.sf.jasperreports.engine.base.JRBaseObjectFactory.getVariable(JRBaseObjectFactory.java:440) at net.sf.jasperreports.engine.base.JRBaseDataset.<init>(JRBaseDataset.java:148) at net.sf.jasperreports.engine.base.JRBaseObjectFactory.getDataset(JRBaseObjectFactory.java:1525) at net.sf.jasperreports.engine.base.JRBaseReport.<init>(JRBaseReport.java:220) at net.sf.jasperreports.engine.base.JRBaseReport.<init>(JRBaseReport.java:148) at net.sf.jasperreports.engine.JasperReport.<init>(JasperReport.java:83) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:212) ... 5 more Could you please guide me through this?

And can I color cell respectivly to its content? i.e. if value is less then 10, backgroung color should be white, else - red.