Search

1 to 7 of 7
Sort by

Discussion Post
Jasper Request and Target time Join does not work

#Hello, I would like to create a simply report of request (DB table: call req / casd object: cr) and ticket related service target(s) (DB table:usp target time / casd object: tgt time) using Jasper Studio. I used this SQL query directly on SQL DB server: SELECT cr.id as Req, cr.ref num as RefNum, cr.summary as Summary, cr.status as Status, tim1.sym as SymTmpl1, tim1.time left as TimeLeftTmpl1, tim1.target duration as DurationTmpl1, tim2.sym as SymTmpl2, tim2.time left as TimeLeftTmpl2, tim2.target duration as DurationTmpl2 FROM [mdb]


Discussion Thread 2
Jasper Request and Target time Join does not work

Focus Search - #Hello, I would like to create a simply report of request (DB table: call_req / casd object: cr) and ticket related service target(s) (DB table:usp_target_time / casd object: tgt_time) using Jasper Studio


Discussion Reply
RE: Jasper Request and Target time Join does not work

Hello Radek, As Jasper is a third party product it is always worth a general search on the internet for advice as well. I tried this search and got some good looking hits (I think!): jasper studio "The multi-part identifier" "could not be bound" This one here basically reckons it is...


Discussion Reply
Re: CA PPM Tech Tip: How to replace your Jaspersoft Database password so it remains encrypted

Nika Hadzhikidi Thank you so much for your contribution; very helpful! I realize this thread is nearly a year old, but since a few commentors and myself had issues updating the password when using configuration password encryption (Failed to Decrypt error when starting the jasper listener) I...




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

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) - P roject 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?