biaggi

I recommend u to attach the cube definition. Best Reggards :)

There is a property named nameColumn where u can set the column will be shown in the drillthrough

tjava calling a class contained in code folder is the winner option ;)

The tjoin component support rejects, so i reccomend to use tjoin and later u can use a tmap to make the needed transformations in the data.

I would write a java pre-process for make an union of such lines, as far as i know there is no easy way.

Jasper is unther gnu license, so you can use it without remorse ;) For more information you can read the license.txt provided with jasperserver or directly this page: http://www.gnu.org/licenses/ Best regards

swood is working in that, so there is nothing more to do here :(

You can try to do it with css instead of hard coding ;)

Hi all, I have some cubes with Measures with a formatString like this: <Measure name="MeasureName" column="dbColumn" datatype="String" aggregator="sum" caption="MeasureCaption" visible="true" formatString="#,##0.00 €"> This works perfectly on Analisys views, and the FmtValue Property is correctly returned in XML/A <Cell CellOrdinal="0"> <Value xsi:type="xsd:string">37460.44793599999996518</Value> <FmtValue>37,460.45 €</FmtValue> <FormatString>#,##0.00 €</FormatString> </Cell> But I can't use the formatted value in the reports, i've tried with this field descriptions <field name="MeasureName" class="java.lang.String"> <fieldDescription><![CDATA[FormattedData([Measures].[MeasureName])]]></fieldDescription> </field> <field name="MeasureName" class="java.lang.String"> <fieldDescription><![CDATA[[Measures][MeasureName](FORMATTED_DATA)]]></fieldDescription> </field> <field name="MeasureName" class="java.lang.String"> <fieldDescription><![CDATA[[Measures][MeasureName](FmtValue)]]></fieldDescription> </field> And no one works, the output is allways the unformatted value. I've been searching for forums and internet, but i cant find any formatted field example, can someone provide an example?

What means that character in that position? :S i would just write "where field in ($P{Value})"

I'm a little perfectionist or i'm the only one who has noticed that avatar images are resized whithout keeping relation w/h ;) Anyway the new forum interface is very much better. Tks swood, good karma for u :D

So the workaround is to use frienly names in the attribute name. The other question is if mondrian 3.0 solves the drill down problem, drill down only works in final nodes and not in middle nodes who dont have any value asociated Thanks for your answer and for the new forum interface :D

The query you are executing is select emp_name from employee where emp_id = 111,222 So oracle fails, you should try using more than one parameter in your query.

Another solution is just to use a control input with a boolean and use that value in the value of the flag the xml :D is a good workaround if it works ;)

I've noticed that the problem come from Mondrian, from the MondrianDrillTrough class method drillthroug. I've tried to update the mondrian jar to the 3.0 version, but jasperserver dont works. There is any prevision in updating the mondrian jar in the future?

The patch works for me too :S

I've noticed that table headers in the drill down table comes from the sql query directly instead of the caption attribute from the cube. There is any way to change this fact?

Are you sure that in iReport you are using jasperadmin user?

Seems like there is an error in your applicationContext-security.xml, or just you dont have the acegi.jar in your classpath. Best reggards

I'll continue with this post at: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=44048

You need to copy the cincom and rex jars from ireport/lib to WEB-APP/lib and create a spring bean as data source for the report :) that bean will give the connection information to the report, but you must set the parameters as I explain in this post http://www.jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=42893 else youll keep getting the messages URL is null, catalog is null ... Thats works for me :)

I actually get ride of the window by just editing the acegi configuration in applicationcontext-security.xml, setting anonymous authentification for the xmla access and giving read-only access to anonymous users to the connection in jasperserver, but that didnt solved my problem, the script keeps loading forever in xmla reports (im surprised that sql reports works fine), next step i guess is try to use pja toolkit, but i cant even run the tests in java 1.5.0 (5.0) so im very discouraged. I feel like grasping at straws :(, cos' I have no error in tomcat neither in Xorg logs

Hi all, I've been testing reports in my ubuntu desktop distribution and all work's fine, but i have a big problem when i test the server in suse Linux enterprise server. First i get an error of awt, tring to launch the server exporting in CATALINA_OPTS the option headless does not solve the problem. Second option is to raise a Xvfb service in the SLES10, but the problem this time is that the "Enter Username and Password" window seems to appear in the Xvfb, so I cant authenticate the session and the page keeps loading for ever. So how can i get ride of that window, how can i propagate the username/password from the applicationcontext.xml to the xmla soap? By now my source in the bean is like this: <code> <bean id="xmla" class="com.jasperserver.beansFactory.XmlaBeanDataSourceFactory"> <property name="uri" value="http://localhost:8080/jasperserver/xmla?user=jasperadmin&password=jasperadmin" /> <property name="catalog" value="mycatalog" /> <property name="dataSource" value="Provider=Mondrian;DataSource=mydatasource;" /> <property name="username" value="jasperadmin" /> <property name="password" value="jasperadmin" /> </bean> </code> So the bean receives all the info correctly but i dont know the name of the constants where i should put the username/password to get ride of the window authentication. <code> parameterValues.put("QUERY_LANG", "xmla-mdx"); parameterValues.put("XMLA_DATA_URL", this.xmlaConnection.getURI()); parameterValues.put("XMLA_DATA_CATALOG", this.xmlaConnection.getCatalog()); parameterValues.put("XMLA_DATA_DATASOURCE", this.xmlaConnection.getDataSource()); parameterValues.put("XMLA_USERNAME", this.xmlaConnection.getUsername()); parameterValues.put("XMLA_PASSWORD", this.xmlaConnection.getPassword()); </code> So some one know any method to get ride of the mentioned window? Any hint will be appreciated :)

Sorry for the delay, Finally solved the problem, was a missconfiguration, This steps works for me 1.- configure and use a xmla connection 2.- write a bean to get the info from the applicationcontext (and configure it in the applicationcontext.xml) 3.- copy cincom and rex jars from ireports to the lib folder of jasper 4.- edit classes/jasperreports.properties and add the property net.sf.jasperreports.query.executer.factory.xmla-mdx=net.sf.jasperreports.engine.query.JRXmlaQueryExecuterFactory This do the job for me and now i can get reports using xmla connections, but my problem now is that i need to give the username/password to the connection or awt fails in the server without X-window. Using Xvfb dont solve the problem neither start the server with awt in headless mode, becaus with headless mode it fails and if i use xvfb i need to give the user/password in a small windows that no appears in xvfb, xhost + says that the display is up and open, so now my problem is to know the name of the parameters for username and password, the rest of the parameters seems to be well known parameterValues.put("QUERY_LANG", "xmla-mdx"); parameterValues.put("XMLA_DATA_URL", this.xmlaConnection.getURI()); parameterValues.put("XMLA_DATA_CATALOG", this.xmlaConnection.getCatalog()); parameterValues.put("XMLA_DATA_DATASOURCE", this.xmlaConnection.getDataSource()); So if someone knows the name of the xmla parameters to get the username and password directly to the xmla servlet the information would be apreciated. Maybe the solution is edit the JRXmlaQueryExecuterFactory, but i cant find a complete source of the class. As i said before, any help would be apreciated :) Sorry for my poor english :)

You can try to delete de ^M chars this way: cp workbench.sh workbench.sh.backup cat workbench.sh | tr -d 'r' > a mv a workbench.sh chmod 755 workbench.sh Now you can safely execute ./workbench.sh