yashdeep

hi anandharaj! Thanks for comments, can u tell me how to configure JRVirtualizer in application-context.xml, report-scheduling....xml etc. I would like to add one more point to Improve the Jasper Server. JS Should support Trigger/Condition Based report scheduling..... Thanks & Regarads, Yash

Hello! I am using mutli-axis chart (Line + Bar Chart) , when i set the Range Axis Min Value and Max Value and try ti upload it on jasper server it gives me error "The selected Jrxml could not be parsed." When i checked the log for this in Tomcat i find following : 11:23:41,843 ERROR Digester,http-8080-Processor21:1538 - Parse Error at line 178 column 35: cvc-complex-type.2.4.d: Invalid content was found starting with elem ent 'rangeAxisMinValueExpression'. No child element is expected at this point. org.xml.sax.SAXParseException: cvc-complex-type.2.4.d: Invalid content was found starting with element 'rangeAxisMinValueExpression'. No child element is expect ed at this point. at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Un known Source) at org.apache.xerces.util.ErrorHandlerWrapper.error(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.xs.XMLSchemaValidator$XSIErrorReporter.reportE rror(Unknown Source) at org.apache.xerces.impl.xs.XMLSchemaValidator.reportSchemaError(Unknow n Source) at org.apache.xerces.impl.xs.XMLSchemaValidator.handleStartElement(Unkno wn Source) at org.apache.xerces.impl.xs.XMLSchemaValidator.startElement(Unknown Sou rce) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unkn own Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContent Dispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Un known Source). ....................................... Please find the attached file for complete log. When i run the report in iReport(3.1.5) it works fine it gives me desired output. While uploadin it on JS it gives me above error. While trying some wrok around - when i remove the settings for Min and Max Value for Range axis and try to upload it on JS , it get uploaded and works fine. But i want to set the Mix and Max value for Range Axis its necessary for me. I think this a bug in jasperserver 3.5, i never tried this in other JS versions. If anyone knows how to solve this issue pls let me know ASAP...... Thanks & Regards, Yash

Hello! i have 2 reports (master and child), both reports are having prompt on date, i am able to run the reports individually, i set the default value by defining new date() in default value expression for the parameter. Now when i changed the value of date input control on individual report (using calender control)and run the report its works fine... if i want to drill from master to child report and want to pass changed date to the child report and want to set it as default in date input control of child report, but on child report the value assigned to date input control is in format :Sat Mar 28 18:35:54 IST 2009 and gives error specify the valid date value . i tried option like new SimpleDateFormat("dd-MM-yyy") etc........ but no luck..... Pls help me on this issue............. Thanks & Regards, Yash

Hello! i have 2 reports (master and child), both reports are having prompt on date, i am able to run the reports individually, i set the default value by defining new date() in default value expression for the parameter. Now when i changed the value of date input control on individual report (using calender control)and run the report its works fine... if i want to drill from master to child report and want to pass changed date to the child report and want to set it as default in date input control of child report, but on child report the value assigned to date input control is in format :Sat Mar 28 18:35:54 IST 2009 and gives error specify the valid date value . i tried option like new SimpleDateFormat("dd-MM-yyy") etc........ but no luck..... Pls help me on this issue............. Thanks & Regards, Yash

Hello! i would like to add to following to this list are: 1. Most importent Cascaded Input controls. 2. Pass Collection from Parent report to child in case of multi-select input controls. On parent report i have selected the some values from Multi-Select Control, now i want to drill to a child report with the options selected on parent report and wants to show values selected in Multi-Select control on child report. 3. Customized input control placing on report (by default it depends on the sequence of adding input controls to the report) 4. Cache option is also importent. Thanks & Regards, Yash

Hi njrfrens! For acheving this u have to set ur series expression for US/Asia etc and Month/Product Combination in Category Expression. This may help u.... Pls let me know if u find any other sol. for this. Thanks Yash

Hello! I have a bar chart report with a multi-select input control (say on Country), it works fine. Problems comes when i am opening a report by passing values of multi-select input control to another report using link parameter and that report also contains a multi-select input control on it (on same Country ), here i want to show all those countries selected, those i already selected on main report. In other word i want to set default values for Multi-Selection input control on Child report with the values i selected in main report.(Both reports main and child has a multi-selection input control on Country) I used following syntax to set default value to County Multi-Select input control (of type java.util.Collection) on main report java.util.Arrays.asList(new string[] {"INDIA","USA"}) its working fine. Now how to do it for child report while calling child report from main report using link parameters If any one knows how to do it, pls let me know ASAP. It’s urgent..... Thanks & Regards, Yash

Hello! Is it possible to use the Marquee functionality in iReport (may be in Static Text Field).......................... * Marquee Functionality: Using this u can show text moving on Html page either Right to left , Top to Down................ etc... If anyone knows the solution of this pls let me know..... Thanks Yash

Hi All! i configured the Mondrian OLAP conn. successfully, MDX Query is fine, able to add the fields, after this when i put the fields on report and run the report m getting following error......... Opening Mondrian connection Closing Mondrian connection Error filling print... Mondrian Error:Internal error: Error while executing query [select {[Measures].[Revenue]} ON COLUMNS, {([Time].[All Time], [Geography].[All Geography])} ON ROWS from [Pharma] ] mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[Revenue]} ON COLUMNS, {([Time].[All Time], [Geography].[All Geography])} ON ROWS from [Pharma] ] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Util.newInternal(Util.java:1083) at mondrian.olap.Util.newError(Util.java:1099) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:438) at net.sf.jasperreports.olap.JRMondrianQueryExecuter.createDatasource(JRMondrianQueryExecuter.java:87) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:656) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:588) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1196) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:833) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:256) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:1037) at java.lang.Thread.run(Thread.java:595) Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select sum("SALES_FACT"."Sales_Amount") as "m0" from "dbo"."SALES_FACT" as "SALES_FACT"] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Util.newInternal(Util.java:1083) at mondrian.olap.Util.newError(Util.java:1099) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:204) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:138) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:285) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:246) at mondrian.rolap.agg.Segment.load(Segment.java:354) at mondrian.rolap.agg.Aggregation.load(Aggregation.java:164) at mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:81) at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:352) at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:178) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:772) at mondrian.rolap.RolapResult.<init>(RolapResult.java:390) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:410) ... 10 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'dbo.SALES_FACT'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:124) ... 20 more Print was not filled. Try using an EmptyDataSource....... If anyone has solution of this problem pls let me know. Pls find the attached file of QUERY. Thanks & Regards, Yash

Hello All! I want schedule a report run if a specified condtion is true. For ex. Run a Summary report if the Sales Prec goes less then 20%. If someone knows then pls reply........ Thanks in advance

Hello All! Can any one tell How to set the width of Static Text Field on the basis of Value of any other report column like Precentage. Thanks

Hi All! If someone knows how to authenticate users resides in database........pls let me know the config. needed I am maintaining users in database tables.... I am using jasperserver-pro 3.0 Sql-Server 2000 Thanks & Regards, yash

Hi All! i have created one dashboard with 2 to 3 reports, now i would like to show this dashboard after user login (as demo login)..... i already go through posts and made changes in the mentioned files ( like jasperserver-servlet.xml) but no luck.... one more issue 1. Folder Structure of Jasper ( Where can i find the Reports & Folders are created by me in the repository, suppose i created one report Test-Report in folder named MyReports in repository at UI whats the physical location of this folder as.......) If someone help me on these issues....... Thanks & Regards, yashdeep

Hi All! I made the changes the jasperserver-servlet.xml inorder to see my Own dashboard after the use login............... but still i am not able to my reports/dashboard after user login. Should i need to make some config. changes in another files too....