[Max up for PageFooter]

Hi,

 

Can we tell to PageFooter to be on the max up, juste after the end of "Detail" ?

 

Because, actually, Page Footer, is always on the bottom, even if Detail take a little height, so there is a big "blank" on the page between the end of detail and the begin of PageFooter.

 

(column Footer is to 0 height)

 

There is an option for column footer to tell it to go up max (floating column), but i have not found for PageFooter.

 

Thanks

 

(excuse my english)

[Error in SQL Query with Parameters in clause FROM]

I think i've find the solution.

 

... FROM $P!{PARAM_1} ...

 

(the "!")

 

Can you confirm me it is the correct option, that put "!" always remove quotes ?

 

Thanks

[Error in SQL Query with Parameters in clause FROM]

Hi,

 

I have a problem.

 

I want to pass a Parameter in clause FROM. But there is a probleme during the execution.

 

... FROM $P{PARAM_1} ...

 

My parameter is type of String (exemple value : param), so when i execute the program, it make automatically quotes like this :

 

... FROM 'param' ...

 

So it make a SQL error.

 

How can i do for not automatically make quote during the execution ?