[Parameterized Reports]

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

[How to find problem...]

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

[How to trigger with group by.....]

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

[Please help. MDX query problem or JasperServer?]

Hello,

 

How many rows in your Fact table?

 

David

[Multi-Select Parameters in JasperServer 3.0 Dashboards]

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

[Highlight sort-fields]

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

[Variable Expression Assistance]

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

[Report text doesn\'t display in Designer view]

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

[Bar chart horizonal axis is unreadable]

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

[Here\'s a question...]

...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...

[Am I Dealing with a Bug Here...?]

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

[Filtering DrillDown Results]

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

[Percentage Question]

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.

[URL to print PDF]

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

[URL to print PDF]

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

[URL to print PDF]

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

[How to do a chart like this case ?]

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

[how to calculate Totalsum of percentage in ireport]

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

[Printing group header at page top.]

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

[Sort and group records by field and print section]

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

[Using report elements questions]

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

[Schema Locations]

Hello to all,

Can anyone tell me where the heck the schema xml files are located on the JasperServer?

Thanks,

David

[using hyperlink with mdx query]

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

[3.7.2i. Sum calculating]

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

[Olap Connection Made--No Data]

Bump.