Re: Jasper report

[Mahendar Reddy]

I hace designed jasper report in jasper studio and preview is working succesfully,

but when i created process and attatched to print report, it is displaying as null

 

[Jesús Castillo]

Hi,

Maybe it's a problem with parameters.

 

Atte: Jesus Castillo.

Remitente notificado con Mailtrack

07/13/23, 07:37:56 AM

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/46e0cd2c-94d3-4d59-aa71-126a3a6288ccn%40googlegroups.com.

[Mahendar Reddy]

but it is woring in jasper soft view

[Jesús Castillo]

Ok, Well, no build the report is a common error, did you compile it? I look at the pic, and i see the jasper file. check that.

 

Atte: Jesus Castillo.

Remitente notificado con Mailtrack

07/13/23, 09:02:21 AM

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/551bb5bd-1b67-48d6-9b95-f52494c97110n%40googlegroups.com.

[Alan Lescano]

Hi, check the letter case of the filename.

Alan

--

[Mahendar Reddy]

when i hardcoded $P{C_Invoice_Id} report is generating,  it is not taking paramater value directly

[Jesús Castillo]

Hi, 

Check C_Invoice_ID parameter in the process definition, Check DB Column, It must be exactly the parameter name in the jasper report. 

For example, according your jasper, if DB Column is   C_Invoice_Id is a problem because the last D must be upper case.

 

Atte: Jesus Castillo.

Remitente notificado con Mailtrack

07/14/23, 08:15:14 AM

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/1b4bc65f-8084-4f11-83a3-ecfa40a34a51n%40googlegroups.com.

[Carlos Antonio Ruiz Gomez]

If you are running the report from the Print button on Invoice window, then the parameter must be RECORD_ID

El 14/7/23 a las 13:18, Mahendar Reddy escribió:

when i hardcoded $P{C_Invoice_Id} report is generating,  it is not taking paramater value directly

[Alejandro Jesus Guerra]

Good morning, what type of data is ${C_Invoice_ID}?? 

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CAFAT%3DLRgObQFQsb_baHQcouZKb7dMh%3DiZKCyiLQz_9ouBRqYnQ%40mail.gmail.com.

[Gaurav Sontakke]

Hi 

In the jasper report its integer $P{C_Invoice_ID}

Regards 

Gaurav

Gaurav

Sent from my iPad

On 14 Jul 2023, at 3:31 PM, Alejandro Jesus Guerra <aguer...@gmail.com> wrote:



To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CAFbB-_e5eeainHYRxNKXUDf9b15cSrVKPdn6-4dmmXV65o1L%2BA%40mail.gmail.com.

[Mahendar Reddy]

my queries is

main table query:-

child table query:

mapped parameter Record_Id and invoice_id

in jasper studio preview it is working

created report and process in idempiere

created pint customization and added jasper report

in idempiere it is coming as empty paper but it is working in jasper studio

[Mahendar Reddy]

i had tried with this also, but this record id is not mapping witth child table, only main table is working

[Carlos Antonio Ruiz Gomez]

Record_ID must be in uppercase -> RECORD_ID

and type must be Integer

El 17/7/23 a las 9:24, Mahendar Reddy escribió:

[Mahendar Reddy]

i had changed to RECORD_ID, child table data is not rendering

[Mahendar Reddy]

this is my jrxml file, if any one can  help with this, please help!

[Diego Ruiz]

If mahe.jasper is your subreport. 

Maje sure that the Subreport expression in the main report is: $P{SUBREPORT_DIR}+"mahe.jasper" (and the same for every subreport you have)

Regards,

Diego

[Mahendar Reddy]

i didnt understood, can you please explain briefly, im new to this

thanks

mahe

[Diego Ruiz]

In Jasper Studio make sure the master report is pointing to $P{SUBREPORT_DIR}+"mahe.jasper" instead of only mahe.jasper.

Regards,

Diego

[Carlos Antonio Ruiz Gomez]

Did you make it uppercase also in the child report?

El 17/7/23 a las 12:47, Mahendar Reddy escribió:

[Mahendar Reddy]

I am actually using just table element in main report itself. I am not using subreport. Sorry fairly new to to terms in jasper studio.

I am using RECORD_ID from main report in table element. Works fine in Jasper studio but not in idempiere application.

thanks

mahe

[Mahendar Reddy]

yes i kept same for table also