HOW TO SEPARATE OBS AND LOCATION IN JASPERSOFT FILTERS??

[kacevedo_extensionsa]

I'm doing a report on Jaspersoft, but I just want to filter by OBS.

In the "OBS Path" filter it is shown together (OBS and Location) .

How can I separate or filter it so that it only shows me the values of OBS?

 

 

 

#clarityreportgeneration

#cappmclarity

#jaspersotreport

#jaspersoftchart

#lookupfilter

#obspath

[kacevedo_extensionsa]

Rodrigo.gregoriodelasheras

My friend, I have not received help by this way
Please help me

Saludos

[Rodrigo.gregoriodelasheras]

Hi Karlos,

 

What you could do is ask CA Mexico Pre sales o CA Mexico Services, if they know anything

 

Saludos 

[kacevedo_extensionsa]

Hi Rodrigo,

Could you send me the CA Mexico Pre sales o CA Mexico Services contact information?
Please

 

Thanks

[Georg Schmid]

Hi Karlo,

 

 

I am afraid that this is not possible OOTB due to the design of the domains:

For each OBS Type (e.g. Department or Location), you will get one piece of information, e.g. the ETC hours on a project.

E.g.:

Project Name	ETC Hours	OBS Type	OBS Unit
Project A	140	Department	Sales
Project A	140	Location	London
Project B	42	Department	Sales
Project B	42	Location	Berlin

 

If you filter for Department Sales and Location London, you will get the first 3 rows which adds up the 140 hours twice.

If you only want to fitler for either Department or Location, just add the OBS Type to your filter.

If you want to filter both Department and Location, you have to transpose both values to columns using Calculated Fields:

Name "Department Path": IF("OBS Type" == 'Department', "OBS Path", null)

Name "Location Path": IF("OBS Type" == 'Location', "OBS Path", null)

 

Now, you can filter by both fields

 

I hope I could help!

 

Regards

Georg

[Adam Jobbins]

Reviving an old thread, but I'm having a similar issue. I have two 'OBS Type's I want to have included in a single row returned in a Jaspersoft report.

I followed the advised from Georg above, but that still results in one result row per OBS Type, with the calculated field for the other OBS type showing as blank.

Using the above as an example, with calculated fields exactly as this, returns the following

Name "Department Path": IF("OBS Type" == 'Department', "OBS Path", null)

Name "Location Path": IF("OBS Type" == 'Location', "OBS Path", null)

Project Name	ETC Hours	Department	Location
Project A	140	Sales
Project A	140		London
Project B	42	Sales
Project B	42		Berlin

The output I'm trying to achieve would be:

Project Name	ETC Hours	Department	Location
Project A	140	Sales	London
Project B	42	Sales	Berlin

Surely this must be possible?