how to return value from the subreport

[alvintkl]

Hi all

How to return a value calculated at subreport and return back to main report to use

[shainaztamboli]

 hi,

create a variable In subreport  say returnValue

variable class type --> whatever u want

calculation type --> nothing

reset type and increment type -->none

variable expression --> value you want to return

In main report create variable with same name as returnValue

variable class type --> same as return type

calculation type --> nothing

reset type and increment type -->none

variable expression --> blank

In main report  Subreport --> properties -->Subreport(other)-->subreport return values-->add

Subreport variable--> variable name as returnValue(u want to return) 

local destination variable --> main report variable (returnValue)

calculation type --> nothing

and use that variable wherever u want .

one more thing use evaluation time of that variable as report

 

hope it will work for you

-Shainaz

[alvintkl]

thank a lot

[hasan14192010]

thank you for the solution ,but when i go to add no sub report variables are showed. only the basic ones are available. what do you suggest ?

[mo7medhosny]

same problem here

[mo7medhosny]

You have to write subreport variable name manually, jasper shows default variables only!!

[madhuri.thakur]

Hello,

 

I did everything as suggested in the post.

I have two sub reports and i am getting values from there.

till now i am going good, i am getting values from sub reports to main reports.

 

but the issue is, i am unable to do the total of two values, it is displaying null.

 

Please help me out.

 

Thanks & regards

Madhuri Thakur

[thierry.siraut]

Hello, I have a NULL value returned from the subreport despite suggested by Shainaz configuration. Can you help me please ?

[mauricio]

Hello, same issue here, two variables defined on each report and subreport, same name, multiple attempts with different configurations, always get null

 

using IReport4.1.3

 

thanks in advance for any help

[dasarishivasagar]

Hello, I am passing calculated variables from SubReport to MainReport

i am getting result in MainReport but my issue is

I am not getting exact value in my MainReport as like what my subreport calculated variable value is giving. it is giving -1th iterated value to main report.

for example:

i am calculating sum($F{Sal}) which need to sum 8 records of $F{Sal}

in my subreport i am getting sum($F{Sal}) for 8 iterations which is correct and expected

same variable i passed to my mainReport

but in my MainReport it's value printing sum($F{Sal}) for 7 iterations which is wrong, it is skipping 1 iteration i am not getting why it is happening

Please help me on this issue as soon as possible.

Thanks in advance,

Regards,

Shiva.

 

[dasarishivasagar]

Hello, I am passing calculated variables from SubReport to MainReport
i am getting result in MainReport but my issue is
I am not getting exact value in my MainReport as like what my subreport calculated variable value is giving. it is giving -1th iterated value to main report.
for example:
i am calculating sum($F{Sal}) which need to sum 8 records of $F{Sal} in my subreport and i need to pass it to mainreport
in my subreport that variable value i am getting sum($F{Sal}) for 8 iterations which is correct and expected
same variable i passed to my mainReport
but in my MainReport it's value printing sum($F{Sal}) for 7 iterations which is wrong, it is skipping 1 iteration i am not getting why it is happening
Please help me on this issue as soon as possible.
Thanks in advance,
Regards,
Shiva.

[kapidi.dileep]

Hi all ....

Can you please let me know....

i am also having same problem,and am getting null values

 

[jeanpierrepolnareff91]

Hello everyone,

I had a problem when following the solution of shainaztamboli, when I wanted to display the returned value of my subreport into my main report, the value displayed was null (but the variable weren't null in my subreport).

I managed to find a strange solution : Delete resetType = "None" from my main report JRXML file :

BEFORE :

<variable name="returnValue1" class="java.lang.Integer" resetType="None"/>

AFTER :

<variable name="returnValue1" class="java.lang.Integer"/>

Best regards.

[maxime.sonnetvinci-energi]

Hello everyone,

Just a small correction to add to Shainaz's post:

In the main report, the variable reset type should be REPORT and not NONE. Otherwise, you'll just have the "null" value.

[kubazap87]

Hello everyone

i have the problem that i always get only null values in the main report. in the subreport the variables are filled correctly but the transfer does not work. i have already set the rest type to none and report none of this works.
does anyone have any ideas?