Anybody knows how to retrieve subreport value without displaying subreport?

[mlopez_1]

I have a subreport that the only thing needed is one value. This value will be used in a Text Field.

I'm not  interested y visualize that subreport but if it is not printed the values is not calculated.

Everything works fine but always displaying subreport.

I've tried to make subreport very small and setting Overflow type to No stretch, but then the report unit keeps querying and don't ends the report.

Environment:
Jaspersoft Studio 6.2.1 Win10 Pro x64 against Jaspersoft Server 6.2.0 Compilation 20151123_1853 Redhat 6.6x64 JDK 1.8.0_51-b16

Regards,

 

Mariano

[kkriplani]

Hi,
Why not calculate the text field within the subreport and display the subreport containing only that calculated text field? I am not sure if that meets the requirement but give it a try.

Hope this helps,
KKriplani

[hozawa]

What's the purpose of having a subreport that doesn't print anything? If it's empty, it's not a report!
If you just want to do some calculation, use "scriplet" instead.

[mlopez_1]

Hi guys, thanks for your replies.

KKriplani: this exactly what i have did but i have to deal with formatting subreport page and i think this very hard when i just like to get variable value. But this is my current solution and works. ;)

Hozawa: the purpose is that the value that i need is a grouping value from another query, I dont't have another option to ge this value inside this Report Unit. I was thinking in something like HTML does with components that renderized them but don't show. It's very much easer deal with text field with variable value than dealing with subreports.

Thanks to both,

Mariano

[hozawa]

>I was thinking in something like HTML does with components that renderized them but don't show

That's what scriptlets do.

[plambert_1]

Why dont you create a variable and return it. 
Pay attention : 

• Try to set the calculation type as System in the main report mapped variable.
• If the variable is received from the subreport in one band, it can be used in the main report in the next band only

  

[kkriplani]

Hi,
The purpose of the subreport is just to return a result from the query?
If thats the only point, add a dataset in the main report and just use the field value.

That should help.

Regards,
KKriplani

[mlopez_1]

Thanks to all of you.

I will give a try to scriptles and datasets and will see if this helps.

Will tell you about it.

Regards,

Mariano

[mlopez_1]

Hi all, I just proved with subdataset and table component and works perfectly for my needs, even avoid subreport use.

The only thing that cann't do is change textfield size inside table cell, it says that resize cannot change inside container layout, resized container and check Fit columns to table element property. In Width make it well but in height is more than table container and so is like is displayed in navigator.

Any ideas ?

Thank you very much for all of your helps.

 

Mariano

[mlopez_1]

Sorry, I found the answer in Table -> Column  -> Cell properties Height.

Now everything is right

REgards,

 

Mariano