renatomitsunami
-
Posts
8 -
Joined
-
Last visited
renatomitsunami's Achievements
-
Hi PEichelberg, I need to count the numbers of occurences in correct pattern format "XXXXXX/XXXX" = (6 characters before "/" and 4 characters after "/") >> IF $F{Ticket} contains a string with correct format THEN 1....Else 0. In this example, 2 corrects rows: Name TicketJohn123456/2017Mary564587/2017 Thanks again
-
Hi PEichelberg, I need to count the numbers of occurences in correct pattern format "XXXXXX/XXXX" = (6 characters before "/" and 4 characters after "/") >> IF $F{Ticket} contains a string with correct format THEN 1....Else 0. In this example, 2 corrects rows: Name TicketJohn123456/2017Mary564587/2017 Thanks again
-
Hi..I'm trying to use a mask filter in a field, like this example: Name TicketJohn123456/2017Mary564587/2017Anthony698/2017Peter1356/201After apply mask filter in "Ticket" field, the expected result is: Name TicketJohn123456/2017Mary564587/2017Ticket field with "######/####" format. How can I apply this filter ? Thanks.
-
Hi, I'm trying to count distinct rows with a conditional (IF)...example table: CityModelTicketSPHOS1234MTRTO1234SPHOS1234ESRTO5678PEHOS9630SPHOS1234In this script... IF $F{City}="SP" AND $F{Model}="HOS"... count rows where $F{Ticket} is distinct. I have 3 rows but only 1 row distinct (SP/HOS/1234)....Result of variable $V{COUNT_X} = 1. Thanks
-
Hi honeybakliwal I have Field1 = Timestamp, Field2 = String and Field3 = String How could I resolve this problem ? Thanks
-
Hi...I'm trying to construct a conditional script with many "OR" operators. I have a variable $V(TOTAL) counting numbers of rows... IF {Field1} not blank "OR" {Field2} not blank "OR" {Field3} not blank. Thanks a lot.
-
Hi reportdev. It works ...!! Thanks so much for your support !!
-
Hi...I'm new in Jaspersoft Studio and I have a question in my report: (Field1) = dd/mm/yy hh:mm:ss (this field contains Date and Time of ticket creation) IF (Field1) BETWEEN "19:00:00" AND "07:00:00" THEN "YES" ELSE "NO" YES=No business hour NO=Business hour Thanks
