[how to use LoggedInUserAttribute_<attribute name>]

 hi

We have some users with several attributes defined in JIProfileAttribute, we would like to use them to filtre the input control

Having looked at the cascading input control, and find this

LoggedInUserAttribute_<attribute name>

String

Attribute value for matched attribute name (like "att1") on the user. Empty string if no match. Only provided if defined in a query or as a report parameter.

No

 

Does anyone know how can i use  this in my input controle query

 

 

I use like this :

select my_col from my_tab where my_attri=$P{LoggedInUserAttribute_my_attri},

but it didn't work

 

jasperserver version: 3.7.0 pro

Thanks

 

[Use Single Select Query with parameter ?]

 found the solution with cascading input controls

[Use Single Select Query with parameter ?]

 HI

I hava serveral input controls for a report, they are defined by Single Select Query

Is it passibale to do this :

pass the value of the first input (which user chose) to the second input, then the second input use this value as a parameter in the query to get the list of result

Sorry for my poor english,hope i've explained well.

 

Thanks

[how to avoid pre-execution of report with domain]

 hi,

I have a report with domain query , the problem is when I open de report(with jasper server), i found that the jasper server is going to execute de sql query which defined with the domain. I have to wait until the query finished,then the empty report showed.Sometimes it takes much time as my query is long.

I just want execute the report after i choose the parameters that i want

How can i avoid pre-execution of the query before i launch my report?

Thanks

[how to avoid pre-execution of report with domain]

hi,

I have a report with domain query , the problem is when I open de report(with jasper server), i found that the jasper server is going to execute de sql query which defined with the domain. I have to wait until the query finished,then the empty report showed.Sometimes it takes much time as my query is long.

I just want execute the report after i choose the parameters that i want

How can i avoid pre-execution of the query before i launch my report?

Thanks

[Color Scales]

Hi

In Execl we can apply the Color Scales to certains columns, can we get this done by iReport

If no,can i apply the color of cell in one colume dynamicly? ( by ex: the number less than X assign to RED).

 

Thanks,

frank

[The differences with Jasper Analysis]

thanks Kristen,that really helps!

[Can jasper analysis be integrated in Jboss portal]

As the title~~

Cheers

[The differences with Jasper Analysis]

thanks anandharaj

   clear explaination,but not too technique:)

   is that relation between them is just like the relation between JasperReport and iReport?
   what if i dont use jasperanalyse, can jasperServer do the analysis(I find that jpivot + mondrian do well the analysis already)?      So,what else jasperanlyse offer?

thank u again~

Post Edited by Lin Chun at 04/02/09 12:56

[The differences with Jasper Analysis]

Hi

   What I know about jasper  server is that it's a olap server base on Mondrian .

   From its datasheet I know it can do analysis and  reporting

   so comparing with jasper analysis, what's the differences between them?

thank you

 

Cheers