leeyuiwah

Hi, Here is the url for the add-on product "Template Exporter" http://www.jaspersoft.com/jaspersoft-template-exporter-jasperreports I want to know how well the quality this product has. I noticed on the said page that this product is not supported by JasperSoft and is sold AS IS. That makes me nervous. I would appreciate if someone can reply and say they are using it and are happy about it despite the fact it is not supported. Thanks!

When I ran a long query (e.g. when it takes more than 10 minutes), the webpage on JasperServer would return an error of \"Internal Server Error\" (* full message below). There was no error on the server log. In fact, if I went into mysql and use \"show processlist\", I would see the query was still running. So, it appears that JasperServer decided to time out even the query was still go on. Is there a way that I can 1. increase the timeout value ? 2. return a meaningful error page to users (e.g. "the query took too long to execute") ? 3. and if JS decides to time out, shouldn't it also terminate the query? (the equivalent of "kill" in mysql client) * Here is the full error message saw from a web browser Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log.

I researched a bit more on this issue. It seems that JFreeChart can present three types of labels for a timeseries chart (please see the attached PPT slide sd_2009_08_10.JFree.autoscaling.JasperSoft.ppt): 1. time-only (e.g. 12:00) Slide 1 2. date-time (e.g. 8-Aug, 00:00) Slide 2 3. date-only (e.g. 4-Aug) Slide 3 It picks a certain type of labels depends on how many days there are for the full range of the time axis (x-axis). They probably has some internal thresholds for these. I think if we can change the internal threshold such that Case 1 (time-only) never happens, then we should be good. But I don't know how to do that.

The time-series chart does auto-scaling on the time-axis (X-axis). It understands that a day has 24 hours, for example, and can render different time-axis tick labels with the appropriate units at different time scale (hours vs dates, for example). This is nice. [/code] [/code] However, when the overall time range is a few data points, the "date" information is lost in this auto-scaling. For example, when there are five days of data, and the time-axis only shows 0:00 0:60 12:00 18:00 0:00 ... (the first 0:00 is for Aug 2, the 2nd 0:00 is for Aug 3, etc, but the date were not shown in the chart) I wonder if there is a way to prevent this from happening.[/code]

Hi, I remember this is possible. I once had a multi-page report. Each page has more than one charts, each is a subreport of a "page" report. The page report is itself a subreport which is called by the top-level report (the master report). In other words, this multi-page report has this structure (A -> B means B is a subreport called by A) master report -> page report -> individual charts

js-import can add new reports or update existing reports (with --update). However, there are occasions that a report needs to be revoked (purged from JasperServer). This is most commonly used when a report is renamed (*). I want to be able to do this without using an interactive log in but using a special option of js-import (e.g. --revoke) * In our set up, we try to match the JRXML file name with the report unit name with the title (user-friendly name). So when the title change, the report unit has to be changed.

I think you can only return one value column, but this column can be a concatenation of multiple columns, and it does not have to be the same as the "visible" column. So, you may do something like select concat(id, "|", name, "|" , description) value_column, name, description from ... In your input control, define "value_column" to be the "value" column, and "name" and "description" to be your "visible" column When you get the return value in your prompt, you can use scriptlet to parse the string (delimited by "|") using something like java.util.StringTokenizer and get back id, name, description.

Try my set up as discussed in this post http://tinyurl.com/lo3o3a Also, Lucian's tip on #57533 (two posts later) may also be useful.

I could assign the return result of a subreport to a variable ($V) but not to a parameter ($P). I need it to be in a parameter because I need the value to drive a query.

Yes, there is a js-export and js-input facilities. It can transfer not only input controls, but also report units, permission, users, etc. Check out the Admin Guide (For JS-Pro 3.5 this is discussed in Chapter 4).

Hi, I now know how to get the return result of a subreport and assign it to a variable ($V). However, I need to use the result in the query (*) of the report. I wonder if I can assign the return result of a subreport to a report parameter ($P)? (* We split our table on a daily basis as it is so large. Each daily table is having the date as the suffix, so for a given day, we go to a given table. If the user specifies a range of dates (e.g. Jan 1 to Jan 31), I can run an SQL query to know what valid tables there are in the database. The result would be a collection of table names. Since each report can run only one SQL query, and I am not sure I can run a SQL subquery and use the result and make it a union of "select ... from tableJan1" "select ... from tableJan2" etc. So I came up with an idea to run a subreport to get this collection of table names.)

Sasi, Sorry I missed your post until. You cannot simply replace <barChart> by <ofc:barChart>. Instead, you will have to following the example in (Samples/Open Flash Charts Report) and then do the translation intelligently. I did this a while back ago and now I forgot what exactly were involved. In any case, the support of OFC is really limited. I would rather wait for the official support come up with FusionCharts. Hope this help!

Subj: Dynamic time values in scheduled reports / User-chosen time values in interactive reports For our scheduled report, we want to use dynamic start and end times (e.g. from 00:00:00 YESTERDAY to 00:00:00 TODAY). However the same report, when ran interactively, must also support user-chosen general start time and end time (e.g. 00:00:00 of 2009-07-01 to 00:00:00 of 2009-07-03) Any good hints on how we can do that? Thanks!

Is there a simiple way to show how long a query ran to generate a report? Granted the users can know about the execution time only after the fact. But at least this gives them some idea how expensive a query is. Also, for developers trying to tuning performance, this information is very useful.

Hi, I also want my input control queries to take parameters (not just $P{LoggedInUsername} but general parameters. Most likely these parameters are the results of some previous input controls. That is, we need some sort of "cascading input control". That is, selection of input control A will cascade down and affect the query in input control B. E.g. In A the user selected a state, and in B only the cities in the specified state will be presented to user in the pull-down menu. Based on this thread, I now know how I can change the query executed in input controls (i.e. not in the main report). However, an open question to me is how we can refresh the GET and submit the result of A so that B can see that result.