ajorgensen

chill_work wrote: Hello, This is possible but you will have to implement this in your own application. I am not aware of a way to do it from running inside of iReport. So, I guess the first question I would ask; Are you running your reports under a webapp? If so, then your webapp would need to capture the link (with any necessary parameters) and then call back down to a different report or even the same report. I guess the different query is under a different report. This is the high level view of what we did. Thanks, Calvin we are running them under a webapp... that was the decision to go to further down the road. for now we just have them split into 2 separate reports with a filter screen for each. Thanks guys!

I have an oddball situation and was curious if there was a solution to it other than obviously splitting the reports: I have a summary report written, with the "issue#" field as the key, shown in the summary. What I want to is make "issue#" a link. when the link is clicked, kick off another report that shows all the details for this issue, using a different query. Is this possible? Thanks much... Alex

Post edited by: ajorgensen, at: 2007/02/09 13:29

bklawans wrote: ajorgensen wrote: Giulio- I see that, but the problem is the fields that are returned from the "Report Query" all have the same name (no aliases are used in the stored procedure). when I click OK on Report Query, only the first field is added in the object library under "Fields". The fields are recognized as unique in "Report Query" by field type (by pressing "Read Fields") but are not given different names in that list. If I add the list of fields manually under "Fields" and set the appropriate "Field class type", as soon as I change the query and press ok the list of fields is blown away and replaced with the original single first field. Are you saying that the columns don't come back with unique names? If so, that sounds like a bug in the Informix JDBC driver. I haven't used Informix for many, many years, but I remember that their C API gave columns coming back from a stored procedure unique (but meaningless) names. The C API was a very thin level above their wire protocol, so I'm guessing for some reason the JDBC driver is ignorning them and giving every column the same name. I did a quick scan through a copy of the Informix JDBC driver manual and found a section on where their driver behaves "differently than specified by the JavaSoft specification", a nice way of saying "spec violation". Amoungh the differences is that DatabaseMetaData.getProcedureColumns() ignores column names. Sounds like a big problem with stored procedure column names in the driver to me. The doc I was looking at was over 6 years old - is there a newer version of the driver available? -Barry<br><br>Post edited by: bklawans, at: 2006/08/25 17:05 Yes, thats it... the column names don't come back unique. The driver sends the same name for each field and iReport only recognizes unique names, so it only makes the first field available.

Got it, thanks!!

Hello- I have been unable to find an example of how to make every other line of the detail band a different color. Is there an example somewhere or can someone provide details? Thanks...

Giulio- I see that, but the problem is the fields that are returned from the "Report Query" all have the same name (no aliases are used in the stored procedure). when I click OK on Report Query, only the first field is added in the object library under "Fields". The fields are recognized as unique in "Report Query" by field type (by pressing "Read Fields") but are not given different names in that list. If I add the list of fields manually under "Fields" and set the appropriate "Field class type", as soon as I change the query and press ok the list of fields is blown away and replaced with the original single first field.

Post edited by: ajorgensen, at: 2006/08/08 18:25

Giulio, thanks for your help. We are using an Informix database. How do I specify a different name for each field in the query tool? i tried the statement: "execute procedure webagnsales('2005-07-01','2005-08-01',1,'','') as f1, f2, f3... f13" (and various other syntaxes) but "syntax error" was returned. We modified the stored procedure to include column aliases, and it works. now, I guess my question is how to use aliases in the iReport query instead of having to modify all our old stored procedures. Thanks again... Post edited by: ajorgensen, at: 2006/08/08 19:08

That will suffice. I was looking to do something like you can do in Excel, sum a column of percentages. name | time | % of total time project 1 | 1 hrs | 25% project 2 | 3 hrs | 75% total time | 4 hrs | 100% to get the "100%" I can divide total time by sum of the project times, but was curious about the possiblity to sum the percentage of the projects. Thanks!

In the iReport 1.2.4 doc, the only thing mentioned about stored procedures is that they can only be used by way of a temp table. When I "execute" one of our stored procedures in the query builder though, all the fields are grabbed, but only the first one is available to be added to the report. When the report is run with this one "expression" the first column of the result is correctly displayed. I'm curious why iReport doesn't recognize each field as unique to be used in the report... Thanks! size=399]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/stored_proc.jpg

Thanks Giulio... that was the only database that I hadn't checked that box. I think the problem I'm having is actually connecting to the database. Although the "Test" completes sucessfully, "table not found" is displayed.

Hello. Is there a way to sum percentages? Thanks!

Hello- I'm trying to use the northwind xml database that comes with ireports 1.2.5. I can test the connection, but when trying to do a report query, it asks for a "SmartCard PIN"... I've tried various things, what do I enter for this? Thanks!! size=398]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/smartcard_pin.gif Post edited by: ajorgensen, at: 2006/08/03 17:23 Post edited by: ajorgensen, at: 2006/08/03 17:24

Thanks... that worked for me too :)