pjamack

I'm trying to build a report where the columns change depending on what cursor is called back from the function. One layout might have 4 columns like(name, number, address, zip) while another layout might have (customer_id, state, program, character_id) and so on... Is there a way to create dynamic columns without having to add on something like velocity or dynamicjasper?

I think it would be nice if there were a map of the US, a user click on the state of California, and they go to specific reports, etc for that state. Asking for zooming into cities is a bit much at this point. But if you just click on the whole map and get one big link to another page where then you can click on a state, it makes the map pointless.

I'm calling a function from my report(Oracle function) and the function works in Oracle and on Toad. It takes in a few variables, stores data in a temp table, opens and returns a cursor, etc. All the Parameters and Fields in my JasperReport are set properly. JasperReport (Worked on in IReports 4.01) doesn't run in IReports or on JasperReports Server 4.01. The same error comes up after I input the dates and info. Always the com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error executing SQL statement for : Test Report etc etc... What needs to be changed? I've written simple SQL Queries where I input some dates and returned fields. But with this function and other ones, I can't get any of them to work. They can't seem to execute the SQL. I write it as (?= call FUNCTION_GROUP.FUNCTION_NAME ( $P{REPORT_START_DATE}, $P{REPORT_END_DATE}, $P{REPORT_PARAM} ) not sure what I'm doing wrong.

I keep getting this error when trying to run a report on JasperServer. I'm not sure what the issue is. Are the parameters not correct? Are the return values wrong? I"m calling a function which throws the values in a cursor.. I made sure I had all the correct names, spelling, lower/upper case, etc. I'm at a loss at this point as to why the report won't run. Just throws this java.io.NotSerializableException: net.sf.jasperreports.engine.design.JRValidationFault Error.

Quick question. I need to create a date parameter but need to limit the date ranges. Say the user can only click from May 1 to May 7 or something, I would I force them to only pick certain ranges of dates. How would you go about setting that up? Post Edited by pjamack at 07/13/2011 16:29 Post Edited by pjamack at 07/13/2011 16:29

I'm getting this error when trying to preview a Report in IReports 4 java.sql.SQLException: Missing IN or OUT parameter at index:: 5 I'm calling a Stored Procedure in Oracle, passing in parameters, returning a cursor with data. The Stored Proc works and executes in Oracle. I put in dates and data and can query the data in the Temp table. So it works as a Stored Procedure within Oracle, the data is stored temporarily in a Temp table and I can display it, view it, etc. But when I'm running a Report in JasperReports and trying to Preview with the same exact data, it comes back with that Missing Parameters. Makes no sense since it's the exact same call and works on one but not the other.

I'm trying to call a Stored Proc , Pass parameters into it, and read data back from that Stored Proc to populate the Report. Running into a few issues. Any help would be appreciated.