nicholas

Thank you for this information, it will be useful to us. Nick

Hi, We'd like to allow some of our JasperServer 2.1.0 users the ability to create new report definitions (uploading new jrxml files, etc.) You need to use the 'manage' repository page do to this. It appears that this page is only accessible by users with the ROLE_ADMINISTRATOR role. Is there a mechanism to allow limited amounts of administration? To manage (areas of ?) the repository, but not to create/remote users, for example. Much thanks, Nick

Sometimes when changing the MDX query (either through the JPivot OLAP explorer or the MDX 'text editor') JPivot stops showing the results. Code: Mondrian still asks MySQL for some data: Code: and this returns data: Code: but the table shown by JPivot has no values in the cells. size=400]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/jpivot_blank.png How do I discover what is wrong? Much thanks, Nick Post edited by: nicholas, at: 2008/01/28 14:16

Dear Forum, With respect to charts in the analysis view, is it possible to either: - Create a new default chart style (vertical line, particular font sizes, chart width etc.) or - Save with an Analysis View the state of the chart, so that the next time it is opened (by the same or different user) the chart has the selected settings? Also, is it possible to set the analysis view so that the chart always appears by default? Much thanks, Nick

Ok, thank you.

Thanks for the confirmation.

Thank you for this detailed answer.

Thank you for your response.

Thanks for trying this out and confirming the problem.

Thanks, that (commas, even with spaces after the comma) works. I didn't notice because of another usability problem - if the scheduled report isn't able to save the report output (set not to overwrite files, yet the file already exists) it appears not simply not save at all, nor send email. I'll create another forum post to discuss this. Thanks, Nick (EDIT: This does cause a message to appear in the 'Messages' list though, but these currently don't get emailed to me.) Post edited by: nicholas, at: 2007/12/31 10:14

Thanks for this confirmation. Do you know where I could find more information? I'd like to know how to monitor this cache, how long items last for, how large it could get, how to flush it early, etc. Much thanks, Nick

I was unsure if this was best posted here, or over at a JPivot forum. I selected here to start with, as if I can achieve this with editing some code maybe it is JasperServer specific help that I might need. I have this MDX query shown in the chart: Code:select {[Measures].[unit Sales]} ON COLUMNS, {[Time].[2006].[Q1].[1]} ON ROWS from [sales] I've done this to see what happens to the chart when it has only a single data point to show, and Vertical Line is set as the Chart Type. We're testing to see if single points are still shown at all, or they get hidden. It looks like nothing is drawn at all, because the line needs at least two points. My client says that Excel (their current application) would draw a small cross if a line wasn't possible. Could JPivot/JasperServer Pro 2.1 do this? If not, what might I need to do to make this happen? Much thanks, Nick

I'm sure this must come up regularly, but I've searched the forum and JS-Ultimate-Guide.2.0.0.pdf with nothing found. Please do just direct me at the last time someone asked if I just missed it! Are database results cached? There is no mention in the JasperServer Pro 2.1 interface, as far as I can tell. The question specifically relates to when this happens: View a report 'Export' the report as a PDF or CSV, etc.[/ol] During that export, is the SQL query run again? What if the query takes a long time to run? I've tried to find out myself with wireshark, watching the SQL traffic, but I don't see clear results. Thanks! Nick

Is there a roadmap item for allowing someone to right click on a field in the Ad Hoc editor and specify a criteria for filtering on the data in that field? This would then go into the SQL query as a 'where' clause. An example would be to right click on "date of birth" and let someone then specify a filter that selects only dates after 1970-1-1. I've tried to separate my questions into different posts so that they are a better resource for Google in the future, but this next one is related so I'll keep it here: Is there a plan for allowing 'SQL level' group-by in the Ad Hoc editor? At the moment, the grouping is done at the presentation layer, so that if we wanted to group the results by country, then show the average shipping cost per country, we apparently must be shown every individual item that is shipped. If the group-by clause went into the SQL query as well as the average() aggregation function, then the report would be able to show only the summary data. More importantly, the database would do the aggregation - we have millons of rows of data so this is important. Is there a better way for me to go about getting that information? My client needs to be able to ask questions such as "what is the maximum shipping cost for each country", etc. without having to create a report with iReport for every type of question they want to ask.

With JasperServer Pro 2.1, it appears that you can only write a single email address into the 'scheduling/output' page until "Email Notification". I've tried comma and semi-colon separated addresses in case this works. Is there a roadmap item or already a feature request to allow several addresses to be entered? (Or better, for a searchable checklist created from an LDAP query or similar...) Regards, Nick

I'm evaluating JasperServer Professional 2.1, and we have a question about filtering with the Analysis/JPivot view. For 'Foodmart Sample Analysis View', as it opens by default, how would you then adjust the configuration so that it included data from all stores except Beverly Hills? I don't see how to use Filter to do this, because there is no option to select all-except-one as they are radio buttons. If I put Store into the Rows section, I can click down and select 'All' and then uncheck 'Beverly Hills', but that doesn't appear to change the numbers at all - it just hides that store from display, still counting them in the totals at the top line. Thanks for any help, Nick

Is it possible to schedule exports to PDF/XLS/email the results of an Analysis View report? (Such as the example 'Foodmart Sample Analysis View') The Analysis view which shows the list of Analysis reports, does not show the little 'schedule' icon. Thanks and regards, (I'm evaluating the Professional JasperServer 2.1) Nick

Is it possible to bypass the Ad Hoc Editor entirely? So that we can have a sequence like this: User selects "New SQL Query Report" They are shown a text box to type an SQL query into. This page also has a drop down list of data sources They click 'run' and the report is run - they don't need to select which columns to show, all available columns are presented. They can click 'back' and edit the query, or save it.[/ul] Maybe we can't avoid seeing the Ad Hoc editor, but is it possible for our 'custom ad hoc launcher' to pre-fill the report so that it contains all available columns? (It might have to run the SQL query in order to find them, though... and it could be a very slow query.) We're trying to have this very simple feature: A text box a user an type an SQL query into, and then they can see the results. They want to be able to then schedule that query to run again later. Thanks, Nick

Yes, I can create new custom adhoc reports, and run them without problem. It's only editing after saving that doesn't work - and thank you for noticing that it works ok from the 'repository admin' view. That helped me track down what was missing from listReportsFlow.xml . This part: Code: <subflow-state id="editAdhoc" flow="adhocFlow"> <attribute-mapper> <input-mapper> <mapping source="requestParameters.reportUnit" target="adhocReport"/> </input-mapper> </attribute-mapper> <transition on="done" to="listReports"/> </subflow-state> needs changing to Code:[code] <subflow-state id="editAdhoc" flow="adhocFlow"> <attribute-mapper> <input-mapper> <mapping source="requestParameters.reportUnit" target="adhocReport"/> </input-mapper> <output-mapper> <output-attribute name="editorURI"/> </output-mapper> </attribute-mapper> <transition on="done" to="listReports"/> <transition on="customEdit" to="redirCustomEditor"/> </subflow-state> <end-state id="redirCustomEditor" view="externalRedirect:${flowScope.editorURI}"/> Then the custom editor is launched without trouble from the standard repository view. This also needs doing to repositoryFlow.xml, but take care that the on="done" transition differs, so don't just copy and paste. Thank you for your help, Nick

When I attempt to edit a custom Ad Hoc report, this error appears: org.springframework.webflow.engine.NoMatchingTransitionException: No transition found on occurence of event 'customEdit' in state 'editAdhoc' of flow 'listReportsFlow' -- valid transitional criteria are array<TransitionCriteria>[[eventId = 'done']] -- likely programmer error, check the set of TransitionCriteria for this state I believe I need to add something to listReportsFlow.xml in this part: Code: <subflow-state id="editAdhoc" flow="adhocFlow"> <attribute-mapper> <input-mapper> <mapping source="requestParameters.reportUnit" target="adhocReport"/> </input-mapper> </attribute-mapper> <transition on="done" to="listReports"/> </subflow-state> Probably something specific to the custom editor used, so that I knows where to transfer the user to browseDB/browseDB.html?action=displayTables ? I'm using an evaluation license for jasperserver-pro-2.1 Thanks, Nick

I've found how to invoke it - http://localhost:8080/jasperserver-pro/browseDB/browseDB.html?action=pickDatasource As far as I can tell, this example allows me to select which table to use, but not specify any other filter-type 'where' clauses. I see I can read launchAdHoc() to learn how to allow the user to type in an arbitrary SQL query. Thanks for your help.

That sounds good, I'll check it out. Thanks! --- I've built and deployed it (according to ant), but I'm afraid I don't see how to invoke this functionality. I've read jasperserver-adhoc-custom.xml and applicationContext-adhoc-custom.xml for clues, but I'm still not sure. I've started tomcat since I deployed the new code. I've also grepped the jasperserver-pro-2.1 directory for anything which mentions customAdHoc in case this is documented somewhere. I'm logged in as Administrator (jasperadmin). Post edited by: nicholas, at: 2007/12/10 21:30

I'm evaluating some reporting products, such as JasperServer and OpenReports. OpenReports lacks some of the things we need, but has one feature JasperServer appears to miss: Being able to enter an arbitrary SQL query and have a simple table report generated. Is this possible with JasperServer? I've been playing with the Professional version (we don't mind paying for features) but haven't figured out how to achieve this. It looks like I could let users enter SQL queries, but I'd have to already have generated a suitable JRXML file? I'd like to do this from within JasperServer so that we can use the scheduling, PDF, CSV etc. export features. Regards, Nick