[How to hide column in JasperServer]

Hi,

I use JasperServer 5.0 and want to hide column Type and Creation Date in the right panel, can someone help me to do that,

 

thks

[PLSQL iReport HELP!]

I made that few months ago, I create 2 types in Oracle (EXTR_ELEC_TYPE_TABLE and EXTR_ELEC_TYPE) and a temporary table 

In iReport, I made a select using funcion (extr_elec_func is function) and using a parameter :

select * from table(extr_elec_func($P{LIST_DOSS}))

 

The script function :

 

CREATE OR REPLACE FUNCTION TDQS."EXTR_ELEC_FUNC" (

 list_doss VARCHAR

)

return EXTR_ELEC_TYPE_TABLE pipelined

is

  PRAGMA AUTONOMOUS_TRANSACTION;

 

  TYPE ref0 is REF CURSOR;

  myCursor ref0;

  out_rec EXTR_ELEC_TYPE := EXTR_ELEC_TYPE(null, null, null, null, null, null, null);

 

BEGIN

PRC_EXTR_ELEC(list_doss);

 

open myCursor for

select

name,

firstname,

birthdate,

accessnumber,

reqdate,

testcode,

result

from TEMP_EXTR_ELEC

order by name,firstname,reqdate asc;

 

LOOP FETCH myCursor into

out_rec.NAME,

out_rec.FIRSTNAME,

out_rec.BIRTHDATE,

out_rec.ACCESSNUMBER,

out_rec.REQDATE,

out_rec.TESTCODE,

out_rec.RESULT;

 

EXIT WHEN myCursor%NOTFOUND;

PIPE ROW(out_rec);

END LOOP;

CLOSE myCursor;

 

RETURN;

END;

/

 

 

call a procedure PRC_EXTR_ELEC which write raws in the temporary table TEMP_EXTR_ELEC

 

[Change separator caracter of a collection]

Hi,

 

I have a collection and want to transform it into String, I use the toList method but I want a string with a "|" separator and not a ",", how can I obtain this ?

 

Thks for your answer.

[Collection and dynamic query]

Solve by using toList method.

Thks

[Collection and dynamic query]

I solve this by using methad .toList

Thks

[Collection and dynamic query]

Hello,

 

I create a query with one dynamic parameter : select nom,prenom from patient $P!{COND2}

I've a parameter COND1 (String) use as a prompt, COND2 is not promptable, the default value expression is : ( $P{COND1}==null ? "" : " where nom ='"+$P{COND1}+"'")

COND2 as string, it works

Now, I want transform COND1 as a collection, i try with a in clause in COND2 parameter, it didn't work, please, help me to solve this.

[Error using JDBC Oracle Driver -- SqlServer Driver]

Hi,

First, excuse me for my english.

Since I installed iReport 3.5.0 (I use iReport 2.1 before and it works fine) today, I've the error :

Exception d'E/S: The Network Adapter could not establish the connection when using Oracle Jdbc driver (JDBC URL : jdbc:oracle:thin:@xd008:1521:tdre)

[Microsoft][sqlServer 2000 Driver for JDBC]Error establishing socket. when using SQLServer Jdbc driver (JDBC URL : jdbc:microsoft:sqlserver://sa026:1433;DatabaseName=remisol)

 

I put my jar into a directory and add them in the classpath in iReport.

It work fine by testing connection with odbc with the correct parameters.

 

Can you help me, please ???? Thks a lot !

 

Post Edited by dec at 04/17/09 14:41