jay411

Hi, I have a report with a crosstab in the details band. The cells in the crosstab include hyperlinks to a linked detail report which receives parameters from the first report. What I like to do now is to send both reports by email as PDF file. The problem is, they musst still be linked together and be readable offline. Is this possible? Maybe there is a way to append all reports into one big PDF, by using some kind of generator to run through all links of the first report and colleting and linking the results?! I know that there a other (proprietary) bi software that does something like that. If not, is there a way to achieve something that comes close to my goal? Thanks, Jay Post Edited by Jan Eberle at 01/27/09 13:11

you can use the jasperserver plugin in iReport to save and export reports.

yep, that was the problem. thank you again! i had to remove 'non empty' from columns ...

Hi Jens, thank you for that perfect explanation! ... i did't know that ON PAGES does exist. Now, my report ist working great and shows dynamically generated columns. I have to admit that dynamic columns from olap sources is working fine! but I have another question... I tried to add parameters to the report and get this error when my subdataset returns no data: No Such Tuple ([Measures].[VALUE1] on Axis 0. I have passed the parameters from the main report to the subdataset the same way as the MONDRIAN_CONNECTION. My subdataset query has a Where condition that looks like: ....where ([Area].[$P{PARAM}]) there are 2 cases: 1) i fill PARAM with a value that gives me result data -----> fine 2) i fill PARAM with a value that gives NO result data -----> error msg I know there are possibilites to catch empty results, but with subdataset queries ...i dont know how. anybody can help? -Jay

by now I think its impossible to create any kind of dynamic columns in iReport based on OLAP data. a solution would be to create a report "by scratch" with java code without using iReport and generate the JRXML at runtime. so, unless anyone can prove me wrong, I guess it's just like that.

Hi, I created a analysis view with mondrian connection, that works well. If I use an xml/a connection based on the mondrian, i get following error when i collapse the rows hierarchy: org.springframework.context.NoSuchMessageException: No message found under code 'null' for locale 'de_DE'.my dimension schema is: <Dimension name="Z_SPMSECT" caption="Superior Section"> <Hierarchy hasAll="true"> <Level name="SuperiorSection" column="Z_SPMSECT" type="String" uniqueMembers="true"/> <Level name="SectionofQuestionnaire" column="Z_SPMQSEC" type="String" uniqueMembers="false"/> <Level name="Criterion" column="Z_SPMCRT" type="String" uniqueMembers="false"/> </Hierarchy> </Dimension> what could be wrong? Thanks, Jay Code:org.springframework.context.NoSuchMessageException: No message found under code 'null' for locale 'de_DE'. at org.springframework.context.support.AbstractMessageSource.getMessage(AbstractMessageSource.java:179) at com.tonbeller.tbutils.res.Resources.getOptionalString(Resources.java:114) at com.tonbeller.jpivot.xmla.XMLA_OlapItem.getCaption(XMLA_OlapItem.java:70) at com.tonbeller.jpivot.xmla.XMLA_Model.evaluateMembers(XMLA_Model.java:1312) at com.tonbeller.jpivot.xmla.XMLA_Model.completeLevel(XMLA_Model.java:1100) at com.tonbeller.jpivot.xmla.XMLA_Level.getMembers(XMLA_Level.java:436) at com.tonbeller.jpivot.core.ExtensionSupport.setDrilling(ExtensionSupport.java:266) at com.tonbeller.jpivot.core.ExtensionSupport.collapsePosition(ExtensionSupport.java:622) at com.tonbeller.jpivot.olap.query.DrillExpandPositionExt.collapse(DrillExpandPositionExt.java:96) at com.tonbeller.jpivot.table.navi.DrillExpandPositionUI.collapse(DrillExpandPositionUI.java:63) at com.tonbeller.jpivot.table.navi.DrillExpandUI$CollapseHandler.request(DrillExpandUI.java:439) at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167) at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167) at com.tonbeller.wcf.component.ComponentSupport.request(ComponentSupport.java:110) at com.tonbeller.jpivot.table.TableComponent.request(TableComponent.java:241) at com.tonbeller.wcf.controller.WcfController.request(WcfController.java:71) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:121) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:281) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:107) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)

Thank you for that hint with XML/A. Now i receive the required measure fields in iReport. But it still doesn't work, as i get no data. nsdanstatt, how do you build your grouped columns in MDX? with crossjoin()? That's how I create my columns: SELECT NON EMPTY Crossjoin({[DIM_ONE].Children}, {[Measures].[MEAS_ONE]}) ON COLUMNS etc.....

Hi Lian, can you please create another topic for your question? You will get more answers if you have your own thread. Jay So, back to my problem, is there anybody that made an MDX query with grouped columns work in iReport?

Matt, I think i found the report "FoodmartSalesMondrianReport" and attached it here. there are grouped rows, but i am searching for grouped columns. Do you have an example where this done? Thanks, Jay

Hello, what i have is a MDX query that works fine as analysis view. now i want to create the same result within a jasper report by using the same olap data source. mdx query: select Crossjoin({[sUPPLIER].[All SUPPLIERs].children}, {[Measures].[VALUE1], [Measures].[VALUE2]}) ON COLUMNS, NON EMPTY {[PRODUCTS].Members} ON ROWS from [sPM] i used a crossjoin to create a result with 6 columns and 3 column groups, like: supplier1#supplier2#supplier3 value1,value2#value1,value2#value1,value2 to make it even more complicated .....the number of columns is dynamic! when inserting this mdx into ireport report query, it does not show me the measures. all i see is: COLUMNS #SUPPLIER #-#(All) #-#SUPPLIER #Measures #-#MeasuresLevel ROWS #..... how can i use grouped column data from olap sources in jasper reports? i guess, another way would be to simply access the relational data and create a crosstab. but the olap should have better performance and is made for such calculations. Thanks for all answers and thoughts, Jay Post Edited by Jan Eberle at 01/14/09 16:04