Gaby38

Hello, This functionnality had disappeared with the "NB" release of iReport. But it has been recently re-introduced. I use iReport 3.5.1 : this functionnality is included inside and I have already used it.

I must explicit a little more what I want to do. In fact, I have a scheduled report which is working well but the mail recipients are not always the same and I can get the right mail address by use of a query. So I wanted to insert these mail adresses directly in the right table (jireportjobmailrecipient) of jasperserver database before the report itself be executed. It was why I thought of a main report reading the involved mail adresses but displaying nothing containing sub reports to do the insert and generating the pdf to be joined to mails. I started with a first test report with only the insert query : as I said the insert query runs but after I get an error which seems normal according to the way jasperserver is working. Am I crazy willing doing that? Have you a better way? I know that I can do that perhaps more easily with specific development but I wished to use jasperserver because it is already in use at customer site. Thanks for your advices Post Edited by Gaby38 at 06/30/2009 11:41

Hi, I would use a report which, before displaying, runs,for instance, an insert query in a table. For that, my main report query is the insert query and then I have a sub report for the standard display. I get an exception saying that there is no data to display BUT the insert is executed before. I can understand this problem because my jasperserver utilisation is not very "orthodoxe". But is there any workaround to do what I want? Thanks for all suggestions Post Edited by Gaby38 at 06/29/2009 20:53

I think that your assumption is right . In this case, it would mean that the input data for your chart are not those returned by the query. Perhaps a problem in the mapping of these data? It's difficult to say : if you post your jrxml file on the forum, perhaps other people or me could see what is wrong.

In general you have three "objects" to configure in your chart and to map to the result fields of your Query : - one Category parameter - one Serie parameter - one Value parameter In your case one or more of these seem to be null. Check your query outside iReport to verify that you don't get null values

As for me, if fmcode (and $P{FMCODE}) is a numeric value, it is not possible to use "like" in the where clause. If it is a string, for the clause, as we are in the query, I would write : where fmcode LIKE '%$P!{FMCODE}' because we are not in regular expressions and "\'" , "+" are not valid operators.

I think you need to define an input control even if it seems crazy in this case; if not the parameter value will be 'null"

Hi, My understanding is a little different : you want to select an employee through a query as an input parameter and after use the id of this employee to run a report with data only for him. If my understanding is bad, please forget this post! As for me I would : - create a parameter named EmployId in the jrxml of the main report - in the main report define the wanted query with somewhere a clause like " where tab.id_employ=$P{EmployId}" - create an input control named EmployId with type "Single Select Query" and use your query : "Select name,id_employ from employ where country_id=755"and in the properties of the input control use the field "name" as "displayed value"and the "id_employ" field as "Value". This input control should fill the EmployId parameter with the selected value

In my case, I use the last released version of iReport and Jasperserver, that is 3.5.2 for iReport and 3.5.1 for jasperserver. If I use ireport 3.5.1 all is OK. For me, at least, there is an incompatibility issue between the generated jxrml and the ".xsd" definition file which is refered to at the beginning of the jrxml because it doesn't content the definition of the property "stretchType" in the object "band". So, for me, your recommendation doesn't fix my problem and I downgraded to iReport 3.5.1

Could you put your jrxml file here because with the only csv file it's not obvious

Hello, It's strange, because I already used the nodata band and I didn't get this behaviour. I have a scheduled report which queries a database to extract some events and make a log and which has a no data band with "No news to-day!". It works fine : on worked days, I get the list of events and on Sundays I get the "No news to-day" So I am surprised

Same thing for me : since I upgraded in 3.5.2 I am unable to run a report in Jasperserver due to the unrecognized "stretchType". For me 3.5.2 is unusable : I downgraded to 3.5.1.

I'm not a specialist of the subject, but it looks like it was a problem of line format. I don't know all the details, but I remember that the format of a text line is not the same in Linux and Windows : in a case it's a LF+CR and in the other case it's CR+LF or only LF. In particular, I'm obliged to use MFC Wordpad on Windows to see correctly linux text files and not Notepad. So for me it's not abnormal that a text file is displayed as you want on windows and not on linux if it has several lines. Perhaps is there a compatible format ? HTH

You didn't miss anything!! It's true! You can easily overwrite one jrxml by another. Some times it's practical but dangerous. In fact, if it happens, you can reload from the temp local directory the good file (not obvious!!) and re overwrite with it. But if it is after 2 or 3 weeks, as the filenames are not very significant, it's impossible to retrieve it. I suggest that, at least, a warning be popped up.

Hello, If I were you, I would use a conditionnal style. I already used that to have a list with alternate colors. You define a style for your report and add conditionnal styles triggered by the value of your test field having adequate background color properties. And you attach this style to your rectangle. I do it with iReport. Hope this helps

Hello, I suppose you are aware of the jasperserver "facility" consisting in giving the username and password through the URL to access the report. it's not good from security point of view but perhaps it can suggest you other ways to use that. In the solution I put in place at a customer site, I use windows shortcuts on the desktop to access directly the reports without authentication from the user, but username and password are in clear in the shortcut.

Hello, One thing about which I wasted hours also was to forget to put the reference expression for subreport between double quotes : in fact it must be a string. For the connection, it seems normal to provide to the subreport the mandatory parameters, as the connection. If you use the wizard to integrate a subreport, this is asked for during installation.

Raman, I think the way you suggest is the simpliest. If you don't want to use the "ROLE_USER" role, it is possible (I did it) but you have to edit the "applicationContext-security.xml" file and add your new role at the right place in order to have rights to load and execute the jsp files like login,flow*, and so on.

I never tested for this use, but perhaps is it also possible to use conditionnal style, that is to set the background color for example according to a boolean expression. It's more "light" to manipulate than several boxes and "print when". I have already used that for alternate color stripes in the detail section, by putting the text fields inside a frame which has a conditionnal style driven by the value of "report_count modulo 2". I don't know if it is possible with a crosstab object Post Edited by Gabriel Entressangle at 03/29/09 17:39 Post Edited by Gabriel Entressangle at 03/29/09 17:40 PS : there is also a "style" property in a crosstab "box", so I think that the conditionnal style may be used to have different background colors. Post Edited by Gabriel Entressangle at 03/29/09 17:49

Hello, I am not sure to well understand your problem, but, as for me, everytime I have to concatenate strings with some of them possibly null, I do that in the sql query with the nvl function. In your case (oracle syntax) : select nvl(to_char(Amount1),'')||nvl(to_char(Amount2),'')||nvl(to_char(Amount3),'') as Field1 .... Hope this helps Gaby

I don't know if I well understand your case, but it looks like if you have put your sub report in the detail band, so there are as many lines as records. Put it in the summary band to have the result in one time. PS: but it will be called only once. Post Edited by Gabriel Entressangle at 02/17/09 15:51

Why don't you use the "nodata" band of the subreport? I already tested that in a main report : I put a static text in the nodata band and I changed the default configuration of the report for the behaviour when no data found. I presume that if you do the same in your sub-report, it would work but I never tested. HTH Gaby

As Svenn suggests, I would do that in the query by using the nvl() sql function. I already did that for an address,and in my database for the address I may have : - the number in the street - a suffix - a flat number - a complement of address and so on and I use : "SELECT nvl(streetnumber,'')||nvl(suffix,'')||nvl(flatnumber,'')|| ......." If you don't know, the nvl fiunction tests if the field is null : if not it returns the field itself, if null it returns the second parameter (in my case a null string) Hope this will help you

I got the same problem : the report inspector window have disapeared and so I had to re-display it through the "Window" iReport menu. But to have something in the report inspector you must have a jrxml loaded in the editor window and, often , the report inspector window wants to "dock" itself in the same window than the editor : so , if you click on the jrxml file, your inspector window is empty. At the beginning, I used an "undocked" Report Inspector window (see the window menu of iReport at the middle bottom) bur this was not very convenient to switch from one window to the other. I succeeded to dock the inspector window in the left pane, just above the repository tree, and like this it's OK for me.

For me you are right : you create a report with a query like you siad : " select * from customer_info where id=$P{customer_id}". You must define a parameter "customer_id" inside your jrxml (as for me I use iReport) and you must create an input control to read your parameter. I already created a lot of reports according to this model and no problem : they are all working. Hope this will help you