swood

While not straightforward, it can be done. Create cascading controls that use a dimension table in the underlying OLAP database. Pass those parameters into the report. With a default expression or by direct substitution into the report query string, you can get the parameters to effect the query. Like: select [Measures].AllMembers on columns [Location].[$P!{Country}].[$P!{State}].[$P!{City}].Members on rows from Sales You may need to do some additional massaging of the parameters to make them conform to MDX syntax. Sherman Jaspersoft

Logged as an enhancement request http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4583 Sherman Jaspersoft

Have you checked out the JasperServer Liferay portlet? It has a configuration that allows the user logged into Liferay to pass through to JasperServer without a separate login. Sherman Jaspersoft

JasperServer Professional comes with a configuration tool "builomatic" that does the install with SQL Server (amongst many other things). Can you use that to set up the server? If you have existing configurations in your MySQL repository, you can export them from the MySQL repository and then import them into the new SQL Server repository. Sherman Jaspersoft

A fun question to answer... You can get the data from a query, but there is a roundabout way to do it. Create an query based input control in the server. Then you can access is via web services and get the data. In the JasperServer binary distribution, there is an example PHP app that uses web services to access JasperServer. In runReport.php, there is a section that does the web services call to get the data and create a HTML select field. See below. As you will see, you need the URIs of the input control and the data source in the repository in order to make the web services call. I was also thinking about how to run a report and extract data from it, which allows you to get the report to the calculations. You can get a CSV export via web services. The CSV will contain the values of any textFieldExpressions defined in the JRXML. Sherman Jaspersoft Code: <select name="<?php echo "PARAM_".$rd['name']; ?>"> <?php // Get the list of entries.... $result = ws_get($rd['uri'], array( IC_GET_QUERY_DATA => $dsUri ) ); $rds = getResourceDescriptors($result); $rd =$rds[0]; $datarows = $rd['properties'][PROP_QUERY_DATA]['properties']; foreach ($datarows AS $datarow) { $row_value = $datarow['value']; $row_label = ""; $k = 0; foreach ($datarow['properties'] AS $datacolumn) { if ($k > 0) $row_label .= " | "; $row_label .= $datacolumn['value']; $k++; } ?> <option value="<?php echo htmlspecialchars($row_value); ?>"><?php echo htmlspecialchars($row_label); ?></option> <?php } ?> </select>

What you did was try to configure JasperServer to use a SQL Server database as the repository. Is this what you intended? Or are you trying to report or analyze data in a SQL Server database? Sherman Jaspersoft

From download-llnw.oracle.com/docs/cd/E15051_01/wls/docs103/notes/new.html it looks like WebLogic Portal integrates with Spring Security, but I don't know the details. You will need to update the JasperServer Spring Security configuration (WEB-INF/applicationContext-security.xml) to do the integration. Sherman Jaspersoft

You can add resource bundles as resources to the JasperServer report unit. The bundles will be included when the report is run on the server. Also there is a Localization Guide included in the documentation which outlines all you have to do. Sherman Jaspersoft Post Edited by swood at 02/17/2010 02:25

For the version 3.1 to 3.5 upgrade, did you follow the procedure in the Install Guide - Section 7? Did you do any customizations of the code in 3.1? Can you show us the output of the import? Sherman Jaspersoft Post Edited by swood at 02/17/2010 02:20

How are your users authenticated? Is there something in the environment that indicates that a user is logged in, like a cookie? Sherman Jaspersoft

It looks like a JavaScript error, which is why you see nothing in the server logs. Were there any error messages in the JavaScript log in the browser? Sherman Jaspersoft

The default is 10,000. You can change the setting by logging in as the superuser and going to the menu option Manage > Ad Hoc Options. The Ad Hoc Filter List of Values Row Limit is the value to set in this screen. This is documented in the JasperSerer Professional Administration Guide (though it is not immmediately obvious). Sherman Jaspersoft

You said "I have access to those reports in my JasperServer". What user did you use to put those in JasperServer? Do those reports run in JasperServer? As suedonne123 said, you will need to create a user or set of users for your management, and give them at least the ROLE_USER role, which will allow them to login and run reports. Sherman Jaspersoft

There is no way to rename a resource like a report or data source through the browser user interface. We should add this. Sherman Jaspersoft

When running a report interactively, the locale used for internationalization will be what was set when the used logged in. It looks like you can override this by setting a "reportLocale" string parameter (input control), that has to be encoded with language and country codes, like "en", "en_US". You can also set the locale when scheduling reports. Sherman Jaspersoft

What’s New With Version 3.7 Webinar Language: English February 16, 2010 10 AM US Pacific 1 PM US Eastern 6PM UK 10PM India Jaspersoft spent the summer building new features into all of its community projects culminating in the recent 3.7 release. Join Jaspersoft Architect Sherman Wood as he showcases enhancements spanning our JasperReports, iReport, JasperServer and JasperETL projects. Register Now: https://admin.na6.acrobat.com/_a858705741/community_webinar_feb2010_event/event/event_info.html?preview=true. A recording of the webinar will be on jaspersoft.com after the presentation.

Ahh, sorry. Try flow.html?_flowId=removedListReportsFlow Sherman Jaspersoft

The old screens etc are there, just disabled. I don't know whether they still work, but you can try a URL like: flow.html?_flowId=removedReportsList This can go into a menu, or you can set it as the home page (say). Sherman Jaspersoft

That Javascript is defined dynamically by DWR when the server starts. It is defined by the following config in WEB-INF/applicationContext-cascade.xml: <dwr:remote javascript="RemoteCascadeDirector"> <dwr:include method="initialize" /> <dwr:include method="handleEvents" /> <dwr:include method="autoPopulate" /> </dwr:remote> So it looks like something is failing to start properly. It looks like a Glassfish issue. Maybe look at http://weblogs.java.net/blog/kalali/archive/2006/04/testing_some_fr_5.html for some advice? Sherman Jaspersoft

In addition to Mark's questions, have you got an XML/A Analysis View created on the server that uses your connections etc? Sherman Jaspersoft

Were you using the version of iReport that came with the JS 3.7 Pro installation? Are the exceptions on the server or on the iReport side? Where are you previewing the reports? In iReport? Via the JasperServer plugin? Sherman Jaspersoft

Can you show us the JRXML and the input control definitions: queries, display columns, multi vs single selects? Sherman Jaspersoft Post Edited by swood at 01/24/2010 20:06

It looks like MySQL is not started or has the wrong set up. Can you check that MySQL is available? Sherman Jaspersoft

I will ask Lucian about this, but from what I can see, the Fields in a Mondrian report was expected to be String, Number etc. It looks like in the move from Mondrian 3.0 to 3.1 the API might have tightened up. Can you show the full stack trace? Sherman Jaspersoft

Show us your JRXML and the input control definitions. Sherman Jaspersoft