[Missing 'Link an Existing Input Control' iR-nb]

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.

[Can we use other than select queries in a report]

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

[Can we use other than select queries in a report]

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

[Category Series Name Is Null]

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.

[Category Series Name Is Null]

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

[SQL -- LIKE Statement]

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.

 

[drill down]

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"

[Choose input parameter in report]

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

[Can't run report from Jasper Server repository]

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

[need help in noData,when there is no Data,but ..]

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

[need help in noData,when there is no Data,but ..]

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

[Can't run report from Jasper Server repository]

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.

[windows vs. linux - renders differently]

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

[Risk overwriting reports on server]

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.

[Change Rectangle Color using Scriptlet]

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

[JAAS and Jasperserver -- AutoLogin]

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.

[ClassCastException using subreport - Wasted Hours!]

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.

[Trouble using ROLES in Jasper Server]

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.

[how to color a box in the table??]

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

[how to get rid of nulls in a concatenated string?]

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

[How make it appear in a single line????]

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

[switching across subreport]

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

[combine field issue]

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

[iReport 3.1.3: No Report Inspector Window]

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.

[about SQL statement with parameter query]

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