Jump to content
Changes to the Jaspersoft community edition download ×

Conditional report values


alba.ortega

Recommended Posts

Hi all, 

I hope you can help me. Let me explain this bug as well as I can:
 
1)I have a report sorted by parameters, the primary is the "Owner", the table looks like:

Capture(7).JPG.88465ad83a356bba7bf7a91cd8032ef4.JPG

 

As you can see, there's a "Pool" owner, this owner comes because this condition in Text Field:

IF($F{_id.Owner}==null,"Pool",$F{_id.Owner})

2)Clicking any value, they will pass to another report, with some parameters associated to each "Ticket (Creation date, due date, name of owner, description...) This report works perfectly except  when I try to drilldown this "Pool" Owner, when I drilldown it, the reports with details is returning all the repository, I mean, all the "tickets" associated to any owner, and what I want to see is all the "unassigned tickets", which could have the owner name as empty or null or white space...

I have a condition in the Dataset Table report parameter like: 

($P{Owner}==null || $P{Owner}.equals(""))?new String(""): ""OpnPrps.CurAgtNme":""+$P{Owner}+"","

I'm thinking that maybe the problem is the initial condition $P{Owner}==null || $P{Owner}.equals(""), and this equals("") is not getting correctly all the values but I'm not sure. 

Thanks & kind regards.

AlbaO.

 

Link to comment
Share on other sites

  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

Hi! 

Ok, I will try....

I have the table from Image 1, And when I click in "Pool" value, itdrilldown many details in other table, this drilldown is sorted by this Owner, however, when Pool (Pool means all the null/empty values), the reports is being sorted by any data (all the inventory) but I want to sort them with Owner == null. 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...