lisacbeaton

Can you post the errors? (Posting this as an answer, because I don't see a way to leave comments)

http://community.jaspersoft.com/documentation?version=8446 Here is the link to the documentation page. Scroll down to the bottom for the iReport Ultimate Guide. What have you tried?

You could try a regular expression (formatted for Oracle here -- the 'i' makes it case insensitive -- format to suit your own database): REGEXP_LIKE(COLUMN_NAME, 'seach term', 'i')

http://tenlittlebigendians.blogspot.com/2011/10/how-to-interface-jasperreports-server.html Yes, if you enable LDAP authentication you can still create local JasperReports Server users, and your superuser/administrator accounts are still valid. See the linked article above -- to enable LDAP authentication, you uncomment a bean in a security file. If the user is not find in the LDAP hierarchy, then the security process looks for a local user (unless you comment out the bean that does that part). Your LDAP users need to be created in your LDAP tool. If you get this working I hope you'll write about your experience so we have more documentation!

Does this work for you? My reports all show up in one list, regardless of what folder they're in, because their type is "Report".

Try ordering them by the value that determines the top 5. Set "Max number of slices to show" to 5 and set "Min slice percentage" to 0.

Hi, Niza, I found something that might help you here: https://forums.oracle.com/forums/thread.jspa?threadID=400623 (I use Oracle, so adjust to suit your RDBMS). In that thread, they suggest creating a table of X rows from dual and then left joining your data table to that.

Is your data in order by value?

Also - what kind of data source are you using? Maybe this could be done in SQL if not in the report template.

Are you looking to take the average of the averages?

I don't have an answer, but I have the same problem and I'm eager to solve it. I have a few top-level reports that hyperlink to other secondary and tertiary reports. "Execute Only" doesn't work when the report is a fully-functioning, free-standing report, and you're passing variables to it via hyperlink.

Can you post your XML file? And in response to 2, yes, order the data by your grouping field.

Unfortunately, anything placed in your detail band will be repeated with every detail band output row, unless you use a "Print When" expression to limit the output to a certain row number. What if the left-side portion was actually a subreport, and you dropped that into an outer wrapper report. In the outer report, you could split the detail band into 2 columns and display the subreport with the data on the left. In that subreport, calculate your averages in the report footer but don't display them. Pass them back to the outer report as return values. You would be doing all of this with the goal of having only one row in the outer wrapper report's detail band. Maybe someone else will have a better solution. I have had to get creative sometimes to achieve the layouts I'm looking for. For example, if you know you're always going to have X number of rows in your data table (I do a lot of "this month, last month, and the month before that" in my reports), you could use something like Oracle's decode function (not sure what kind of database you're using) to get all of the data in one row, and then you can arrange your text fields as you please within the single output row.

Matt - are you displaying the results of these calculations in your detail band? Try moving them to your Summary band.

Double-check your parameters. An input control's ID must match your parameter's name exactly. Also, you don't say if this is in iReport or JasperServer. If this is in JasperServer, did you create input controls there to match your iReport parameters?

If you know the device locations and their corresponding state options, I would do the following: - create a parameterized report that will accept $P{location}. In that report, create another parameter called $P{state_select_sql}. Create a definition for $P{state_select_sql} to build your A.device_state IN clause. For example -- $P{location} == 'UK' ? "('Test', 'Maintenance'...)" : ($P{location} == 'ITALY' ? "do this" : keep going until you get them all) Insert $P!{state_select_sql} into your query in the WHERE clause. Then you'll have a report that can work for any location. Next, create an outer "wrapper" report. Create 6 detail bands and add your parameterized report to each detail band. Pass in the location to each as a parameter. The outer wrapper report will run the parameterized report for each location in one final report.

Hi, Aubrey, In the iReport Report Inspector window, try right-clicking on the report name. You might be able to add a report group there.

Do you have your input controls set to "always prompt"? Try turning that off and see if it helps.

Hi, Ripon, Place your chart in the summary band of your report.

I am using iReport and JasperReports Server 4.7, professional edition. Is there something I can add to my log4j properties file to help me time how long it takes a report to be generated in JasperReports Server? I'm looking for any basic metric so that after we tune our queries and the back-end database, we can re-time the reports and look for improvement. Several of my reports have multiple input controls and subreports, so using the compilation running time and report fill running time displayed in iReport are not an option.

What type of field is DoctorID? Is it a string? Why would you want to sum them? What would a sum mean for you in regards to DoctorID?

I apologize for the formatting... I hope you get what I'm getting at there.

Could you try something like: SELECT * FROM ( SELECT left(columnname,4) as NewColumn ) WHERE $X{IN, NewColumn, paramname}

Does this only happen when you export to Excel, or does it happen in iReport/JasperReports Server also?

Anand, is this a collection parameter? You can use $X instead of $P. For example, SELECT * FROM billing.business_tool WHERE $X{IN, insurance_plan, insurance_plan} The formatting is $X{IN, database_column, your_parameter}. If you don't input a value for your parameter, the statement will default to something like 1=1 or 0=0 and no filter will be applied.