mespub

Hi, thank you for your awnser, though I didn't see it before. Finaly, I managed it in the while.

Hi, you can change the All parameter to String and give it the value 'All'. You can then use it in the Query like this : where shipcountry=$P{shipcountry1} or $P{All}='All' Regards

Hi, You must create an OLAP CONNECTION (wich type is : Analyses Client Connection) based on : - an OLAP schema (from the repository or from a file) - a data source (from the repository or as a direct connection) regards

Hi everybody, Can anybody tell me if there's a way, in a report, to get the current userid or username in a field or variable, because I need to filter the datas to display for each user only his own datas ? Tanks

ok thanks i'll renew my question in the ireport forum

any help ? thanks

Hello I'm using JasperServer 3.1 with hundreds of reports and I would like to know wich are uses or not. I'd like to kno who (and when) has launched the reports. Can somebody help me ? Thanks

hi when i'm using a subreport in a report, I usually get a blank page at the end of the report and I can't get it away. can somebody help me ? thanks

Hi, There,s a special way to install Mysql on Windows Server 2K8 (same with Vista and Seven). I got this on the web : To install MySQL Server 5.0.51a in Vista 1. Disable the UAC in Windows Control Panel->User Accounts 2. Use mysql-essential-5.0.51a-win32.msi 3. In the final step uncheck "Configure MySQL Server now" 4. Download and run Resource Hacker http://www.angusj.com/resourcehacker/ 5. Open ...\MySQL Server 5.0\bin\MySQLInstanceConfig.exe with Resource Hacker 6. Navigate to 24\1\1033 7. Change <requestedExecutionLevel level="asAdministrator" uiAccess="false"> to <requestedExecutionLevel level="requireAdministrator" uiAccess="false"> 8. Press "Compile script" 9. Exit Resource Hacker and save the result (overwrite the initial MySQLInstanceConfig.exe) 10. Now MySQLInstanceConfig.exe should start normally. 11. Configure the server. 12. Sometimes the server doesn't start: a) Check Windows Firewall settings (3306/TCP) b) Try changing the compability mode for the file ...\MySQL Server 5.0\bin\mysqld-nt.exe to Windows XP-SP2.

HI It works fine with this new jar. Thanks a lot.

Hi everybody, Can someone please help me ? I'm using JasperAnalysis 3.7.0. running under Windows XP. I can load the foodmart.xml demo shema in JasperAnalysis, and I can open an MDX query window, with a "Mondrain Connection Successfull" message. However when I want to generate the mdx by clicking at the MDX button, i got this message in the mondrian log window : Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException at org.olap4j.mdx.AxisNode.deepCopy(AxisNode.java:166) at org.olap4j.mdx.SelectNode.deepCopy(SelectNode.java:238) at mondrian.gui.MdxQuery.generateMDXMenuItemActionPerformed(MdxQuery.jav a:560) at mondrian.gui.MdxQuery.access$300(MdxQuery.java:91) at mondrian.gui.MdxQuery$4.actionPerformed(MdxQuery.java:274) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour ce) at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Post Edited by mespub at 02/18/2010 15:02

hello, When I schedule a report with JasperServer, the default output file format is always PDF. Is it possible to set this default output file format to XLS instead of PDF ? thanks

I didn't notice that. So, i'll install it again to get the admin user and password. Thanks

Hello everybody does anybody know how to connect to the sample dabatase with admin privilege (I thing it's called SUPER privilège) Thanks

Thanks for your answer, but it was the answer I was affraid to get : it is not easyly possible without a human intervention Unfortunatly, I don't know how to implement solution b Can anyone help me that way and give me tips to do this ?

It seems that I can't explain what I need. I try again : In fact, I have scheduled a report at 10 pm. and I need the result beeing saved as an xls file at C: without any user intervention. The xls will then be used by an other software scheduled at 10.30 PM Is that possible with JS ? thanks

Hi, thanks for your answer In fact, I would like to get the report saved as an xls file automaticly as soon as it is generated without any user needing to connect to jasperserver to export it. I would like an automat to use this xls file and the file needs to be generated in a windows directory. Thanks

Hy guys, I'm using Jasperserver 3.0 Does anybody know how to export a report as an XLS file automaticly when the report is run ? I couldn't find anything about this in the topics. thanks Post Edited by mes pub at 03/15/09 12:27

Hi, I've just got the same poblem did you solve it ? Thanks Ben