klennon

I have an ireport that has a couple of input controls - that I am attempting to sort the values within the input pulling from a domain (this report is a domain sourced report). The following query will populate a 2 column input:, <?xml version="1.0" encoding="UTF-8"?><query xmlns="http://www.jaspersoft.com/2007/SL/XMLSchema"> <grouplist> <group columnname="newSet1.dim_course1.dim_category1.parent_name2"/> </grouplist> <queryFields> <queryField id="newSet1.dim_course1.dim_category1.parent_name2"/> <queryField id="newSet1.dim_course1.dim_category1.category_name"/> </queryFields> <queryFilterString> contains (newSet1.dim_course1.dim_category1.parent_name2,'PC Level') </queryFilterString></query>[/code]Here is what I see (based on the above code): I would like to sort the listing displayed to the end user by the field "parent_name2".

I am using 3.7.1 (Pro) and when creating / editing a crosstab report via Ad Hoc Editor you can right mouse click a row and exclude it (same thing with a column) from the report output. Once you select to exclude the data, the editor will list the field and data value as a filter for the report.

Are you saying that if I have a domain that have 6 tables and each table has 100 fields, that even though I only am putting 20 of the 600 fields as ouput on a report, through Ad Hoc reports, the system is trying to pull all 600 fields and I could encounter performance issues such as the error "method evaluateOld(int) is exceeding the 65535 bytes limit public". Is there a configuration setting I can extend that value to something larger?

Thanks - that was perfect (I was including a second expression and it wasn't working out).

Thanks for the response. With the filter expression that you supplied it only supports the data at time of input (parameter side). With a startsWith comparator - if the database has data in any of the 4 fields the expression will validate for false and skip the record. What I am looking for is similar code that supports skipping if the field is null (including it) or validating against the value supplied by the parameter. If bureau from the DB is null, automatically include the field - otherwise validate the field against the parameter.

Very new to Jasper and ultimately iReport. I've created standard ad hoc (template reports) but am now dipping my feet into iReport and have struggled with something that I feel should be very simple but for the life of me can't seem to figure it out.... As a SAAS company we've leverage the domain logic and it works great! My challenge is that everything I've read (from manuals to forum posts and the like all have to do with SQL, yet I only have access to SL query language using QueryFields and QueryFilterString. Issue: I have 4 input controls as parameters for a report that may or may not contain data. I need to be able to have end users either enter data (or not) for an input control that looks at a database (through domain) that either will contain data in one or all of those fields or it will not. Data is only returning to the report if there is data in the database (skipping where a record has a null value). Example (the following user would not show on the report because Bureau is null): Fist Name = John Last Name = Smith Emp Type = Manager Bureau = null I have set the default value expression for the parameters to "%", to be a wildcard to grab everything if nothing is submitted by the user running the report. My filter string: <queryFilterString> startsWith (newSet1.dim_lms_user1.first_name,first_name) and startsWith (newSet1.dim_lms_user1.last_name,last_name) and startsWith (newSet1.dim_lms_user1.cua122,emp_type) and startsWith (newSet1.dim_lms_user1.cua42, bureau) </queryFilterString> Each of the 4 fields have the following expression (similar to the following): (($F{newSet1.dim_lms_user1.cua122}!=null && $F{newSet1.dim_lms_user1.cua122}.length()>0)?$F{newSet1.dim_lms_user1.cua122}:"") My dilemma is that the report will only display data where there is a value (non null) in all of the 4 fields. Any help would be greatly appreciated as this will be the foundation for 90% of the reports that will be created using iReport.

I received this error while adding fields to a report. I added a field when I went to add another field i am getting the box with the spinning dial and "Retrieving ..." displayed. Attached both screenshots - adding the Assignment Type took literally no time.

While i've noted a few posts indicating that java.sql.time is supported in jasper reports, I am getting an unsupported column type error when trying to add the field with this data type to an ad hoc report.

Just installed JasperServer Pro 3.5 and using iReport 3.5. I was able to create an iReport report with a pie chart face (summary information) and depending on the slice of the pie chart you click, a separate report (drill down) would display listing detailed data relating to the slice selected from the summary (graphical) report. I then added the report to a dashboard within jasperserver.

Running iRport and Jasperserver 3.5. I also get that message when I add an iReport that has a paramater to a dashboard. For my version you can correct that message by going into Special Content and under Single Report Controls at the top, add the necessary input that goes with the report you've added to the dashboard to the dashboard as well.

So is there a defined threshold for how many values is to many (100, 1000, 100000)? I have customer's that do not have a limit at point of entry but they may change their design for the data if on the back end in reporting there is a known limit. Sometimes this can not be avoided and I think the limit avaiable information filter is a great functional piece to this area. Post Edited by klennon at 02/16/2010 14:46

Is there a limit to the number of email recipients when scheduling a job?

I see that Central Standard Time (CST) is covered as a timezone when logging in. Does Jasperserver recognize Central Daylight Time (CDT)?

I am trying to reference an object (image) in a multi-tenant platform. I can repo to objects in a public folder, but with multi-tenant the organization is always different at the time the report is executed. How do i include ogranizations in the repo-string if they are dynamic?