PPM - JasperSoft - How can I hide the projects that have the value of the “X” field empty?

[kacevedo_extensionsa]

I have 3 custom fields of type "number" within the project object

"Costo Final" - "Costo Planeado" = "Diferencia"

Ex. 10,000 - 5,000 = 5,000

Each project must fill the values of the two fields (Costo Final y Costo Planeado) to obtain the result of the third (Diferencia)

 

I need to show only the total of projects that do not have the "Costo Planeado" field empty & projects Name

 

In the green box, you should only show 3 projects

Project 1 (10,000) - Project Name ***
Project 2 ( 61,100) - Project Name "Complemento a proyectos BANXICO"

Project 3 (440,000) - Project Name ZZZ

 

Example: Project "Prueba 29 sept" has the field "Costo Planeado" empty, so it should not be shown in the report query

 

Any idea please?

 

Thanks

 

#askcappm

#jasperreporting

#customizingreports

#clarityreportgeneration

#formatchart

#filterfunctions

#ppm

[Suman Pramanik]

You can go for a cross tab and group by project count. Adhoc reports have very limited formatting options so you may wish you take a look at Studio report 

[kacevedo_extensionsa]

Hi Suman,

Unfortunately I have to do it with this format  (Chart)

 

I require that the Project name be shown only if the "Costo Planeado" field is not null

 

Is it possible with some Formula or Functions?

 

Example

 

Project Name = Where "Costo Planeado" is not NULL

 

Or something like that

 

Thank you

[Roland Parrotte]

Suggestion - default both attributes to be zero, and then search for '!= zero'.  SQL statements can handle nulls, but I don't think adhoc reports can.

[kacevedo_extensionsa]

Hi Roland

 

I have already set both attributes as the default zero value.

What would be the syntax for this "formula"?

 

Project Name = Where "Costo Planeado" is != zero

 

Thanks

[kacevedo_extensionsa]

Hi roland.parrotte SumanPramanik

Any idea?

Please help me  

Its my firts time with JasperSoft & Clarity

Thanks a lot

[Suman Pramanik]

I guess we need to manage these scenario with studio report, Adhoc report there is no much you can achieve

[Legacy User]

If the attributes are defaulted to zero and one wants to exclude projects where zeros exists, is this not a matter of filtering, rather than calculated fields?

 

Below, I show all the Investment IDs where Total ETC Labor cost is non-zero.  Any investments that are zero do not show in chart (tough to see as there are so many investments in chart, below, that their labels become a blur on x-axis).

 

Here, I'm filtering on "Stage" is not Null and is "Total ETC Labor Cost" greater than zero.

 

 

Filtering, not calculations.

 

Regarding display of "Total Project Count," I've yet to figure out a way to do this in Jaspersoft, except by maybe creating another ad-hoc view/report that just displays total count and putting the two reports onto a Dashboard with a common filter.  When writing SQL based Jaspersoft Studio views, I understand that it is possible to put more than one view onto a single report.  With ad-hoc, its one view per one report, thus the need to go to Dashboards to combine ad-hoc views.

 

Jaspersoft has a long way to go to catch up to Tableau, MS PowerBI...

[kacevedo_extensionsa]

Hi Dale_Stockman

 

I want to use a filter, but it should not be modified by the end user

 

How can I assign a specific value that can not be modified?