despec

There is a special parameter symbol in Ireport--the $X parameter as described in this excerpt from the Ultimate guide: 6.2.2 IN and NOT IN clause JasperReports provides a special syntax to use with a where condition: the clause IN and NOT IN. The clause is used to check whether a particular value is present in a discrete set of values. Here is an example: SELECT * FROM ORDERS WHERE SHIPCOUNTRY IS IN ('USA','Italy','Germany') The set here is defined by the countries USA, Italy and Germany. Assuming we are passing the set of countries in a list (or better a java.util.Collection) or in an array, the syntax to make the previous query dynamic in reference to the set of countries is: SELECT * FROM ORDERS WHERE $X{IN, SHIPCOUNTRY, myCountries} where myCountries is the name of the parameter that contains the set of country names. The $X{} clause recognizes three parameters: Type of function to apply (IN or NOT IN) Field name to be evaluated Parameter name JasperReports will handle special characters in each value. If the parameter is null or contains an empty list, meaning no value has been set for the parameter, the entire $X{} clause is evaluated as the always true statement “0 = 0â€. Hope this helps, David

More than likely, your object is refrencing a style that is no longer available. I had this issue when I coped a text label that had a style attached to another report I was working on. Even though the "properties" look said I had no style assigned to the label, I was still getting an error. I simply deleted the copied label and created a new one. David

In Ireport you can set up a group using your "user" field and then select to have the next group print on a new page. David

Hello, How many rows in your Fact table? David

Hello to all, I've created a multi-select parameter to allow users to select more than one "market" for a report. This report is also included in the Dashboard. When I try to add this parameter (a java.util.Collection param), I get the following message: "Parameter type class java.util.Arrays$ArrayList not yet supported". Does this actually mean what it says, that JasperServer 3.0 does not support multi-select parameters on a dashboard? Thanks, David

Hello, In Ireport, you can apply styles based on some kind of conditional. Check that out and see if you can come up with something. David

Hello, How about instead of giving this control to Ireport, do this within your SQL statement--something like: "Select inv_item, qty_stocked, qty_needed, shortfall from db_table where (qty_stocked - qty_needed) <= 0" David

I notice there are green points within the field frame...Just a guess, but that means the field is riding over another field...Try moving the field until those green points turn grey and you may be able to see the text. David

Your axis labels must be too big, so you need to rotate them...I'm using Ireport 3.0, so it's an earlier version, but I believe the most current version has a "Label Rotation" property in the Chart Properties...In my version, it's a bit imperfect, but if you set the rotation to say 80, this will cause the labels to display vertically instead of horizontally...Try it out. Hope this helps, David

...Can anyone answer a question on this forum? Seems a bit pointless to have a forum when there are no learned JasperAnalysis people answering questions...

Hello to all, We're using JasperServer 3.0 and I'm having a problem working with Analysis Views. I hyperlink from reports to use a specific Analysis View, but no matter what the view name is, the last Analysis View I ran always pops up. For example, if I run a view from the repository (let's say it's called "My First View"), then run a report that links to view "My Second View", the "My First View" pops up! If I go back and run the "My Second View" and re-run the report, the "My Second View" pops up. If I try to run another report that selects a different view, that same, "My Second View" pops up. Is this a bug in the older JasperServer versions? Thanks, David

Hello to all, Is there any way possible to filter the measure drilldown in the Jasper Analysis view? For example, we have a Gross Adds measure and when you drill down into the records that make up the summed gross adds, there are plenty of records whose Gross Adds are zero (0). We don't want to include these in the drilldown. Is there anyway to achieve this though XML cxonfiguration of the Jasper OLAP process, or our we stuck? Thanks, David

I had a similar situation and wrote up help document for myself...Hopefuly, it will be of some help to you: Calculating a Percent Using a Report Total -- First, define a variable that sums a field in your table. Set the "Reset Type" to REPORT and the "Increment Type" to NONE. -- Now add a text field to the detail line to calculate the percentage. Set the "Evaluation Time" to AUTO. Create the expression, for example: new java.math.BigDecimal($F{AP_PAYMENT_COUNT_TOT}.doubleValue() / $V{ap_payment_count_rpt_tot}.doubleValue()) -- With the evaluation time set to auto, the field value is NOW and the variable value is REPORT to allow for the right calculation.

For those that are interested, I found the answer to how you can send a report directly to a report format via a URL: .../flow.html?_flowId=viewReportFlow&reportUnit=<report_unit_URI>[&output=pdf|excel|rtf|csv]&<param_1>=<val_1>&<param_2>=<value_2>... An example would be: http://datawarehouse-dev.revol.com:8080/jasperserver-pro/flow.html?_flowId=viewReportFlow&reportUnit=repo%3A%2FRevol%2FDashboards%2FRoaming%2Freport_panels%2Fkey_financials_by_month_1_1&output=csv&day_month_year=01-AUG-10&for_market=All+Markets&viewAsDashboardFrame=true&_eventId_drillReport=&_flowExecutionKey=_c1C1D7352-0B57-C335-1B15-DE7769B9B1BD_kF3119034-7422-AB78-2494-622081D480AD&reportLocale=en_US Hope this helps others as well... David

Having absolutely no experience putting together a JSP page, would it be possible for you or anyone to provide a sample JSP that gives me an idea on how I should put mine together? David Post Edited by despec at 08/31/2010 20:25

Hello to all, I was wondering if it were possible in Ireport to set up a hyperlink that would immediately export your report to a PDF document, rather than just running the report? Thanks, David

Hello, What exactly are you trying to count in fields a, b and c...Whatever the case, to make your chart come out right, you need to SQL "group by" something. Further information would be appreciated. David

Hello, This is something I jotted down when I needed to do something similar to what you're doing. Perhaps this will help you find your answer as well: Calculating a Percent Using a Report Total -- First, define a variable that sums a field in your table. Set the "Reset Type" to REPORT and the "Increment Type" to NONE. -- Now add a text field to the detail line to calculate the percentage. Set the "Evaluation Time" to AUTO. Create the expression, for example: new java.math.BigDecimal($F{AP_PAYMENT_COUNT_TOT}.doubleValue() / $V{ap_payment_count_rpt_tot}.doubleValue()) -- With the evaluation time set to auto, the field value is NOW and the variable value is REPORT to allow for the right calculation. David

I'm using an older Ireport, where you can VIEW-->REPORT GROUPS and set the option to print the header on each page, so perhaps look around in Ireport and you'll see the same. David

Well, you need to build a query with a "group by" clause. For example: select arrival_date, sum(squid) as squid total, sum(fish) as fish_total from (your db table) group by arrival_date Hope this helps, David Post Edited by despec at 08/18/2010 20:25

Hello, Add the Table of Contents to the title band. Separate it from the other title info with a page break if you like. Hope this helps, David

Hello to all, Can anyone tell me where the heck the schema xml files are located on the JasperServer? Thanks, David

Hello, Just for the heck, make sure the MDX query is not throwing an error. If it is, the default query you saved on the Jasper Server is used. David

Hello, I would take care of it in the query. For example: select USER, Q1+Q2+Q3 as user_total from (your table name) Hope this helps, David Post Edited by despec at 07/21/2010 20:29

Bump.