[condition sum (Compared row between them)]

I need to calculate how  much cars has been left parking and how many arrived.

How do you compare two lines between them? How do I write expression?

Example

date	occupied
	73
	74
	73

result

left car : 1

(73-74)

arrived: 1

(74-73)

thank you.

Best regards.

R.

[Linux-How is called running process of jasperserver?]

Hi, how can i find out the name of runnig process of jasperserver on Linux? I need to monitor if it is running. 

Best regards.

Radek

[Search result - data use to report]

Hi, i need create report from search result data.

for example

How many reports were automatically generated (today).

What was the most frequently report launch?

Do you know where I get this data from jasper?

Thanks.

Best regards.

Radek

[How to find a list of roles that have access to the report? (from external system)]

It is in JasperDB in table Jiobjectpermission .-)

radek

[Jasperserver language polish]

 

Hi,

Has anyone JasperServer translated into Polish language?

Thanks.

Radek

 

[How to find a list of roles that have access to the report? (from external system)]

Hi, thanks for your tip.:-) I was looking at it too. I need to return permissions for reports. For example.

Repot xy has a role ROLE_ADMINISTRATOR, ROLE_USER, ROLE_OPERATOR, etc...

Do you have any idea?

Thanks.

Radek

[How to find a list of roles that have access to the report? (from external system)]

Hi

I need to find a list of roles that have access to the report? 

Is it going to save the generated report? 

or is there some api for this?

or goes to read it straight from db Jasper?

I apologize for my English

Thank you.

Best regards

Radek

[How to create from colection array to psql]

solved!

array$P!{dayofweek}

[How to create from colection array to psql]

Hi, I have a problem insert the values of input in a SQL query.

Input: days of the week (Multi –select list of Values)

Table:

Name|value

Monday|1

Thuesday|2

….

SQl Qeury

select * from report_redlight_pr($P{FromDate}, $P{ToDate}, array[0,1,2,3,4,5,6] , $P{from_time}, $P{Czas_do});

I need create this: array[0,1,2,3,4,5,6]

Jasperserver return this: $P{dayofweek} = [0,1,2,3,4,5,6,]

 

Thank you for your advice.

Radek

[Time Input Control not working]

 I have the same probleme, too. Do you find solution?