Sponsors

Show BLOB Image in iReport

Sunday, November 30, 2008

BLOB (Binary Large Object) is the data type of a column in an RDBMS table which can store large image or textual data as attributes.[1]

This tutorial shows how to show the image stored in a database as BLOB in iReport.




The tutorial is loading below...please wait...














References:

1. Environmental Systems Research Institute, Inc. , The GIS Glossary , http://www.geocities.com/mapref/terms/esri_gloss.html , Date Accessed 2nd December 2008

10 comments:

Fidelio said...
This comment has been removed by the author.
Fidelio said...

Hi, i'm trying to make a report using a condition i just need to see if a parameter is null or not:

if(parameter == null)
print("The parameter is: " + parameter)
else
print ("parameter is not initialized");

can you help me, i can't make the condition

Shamsuddin Ahammad said...

Where do you want it? In Java application or in iReport?

Fidelio said...

in ireport, i just don't know how to do it, we can't use the if statement in ireport, can we?

Shamsuddin Ahammad said...

There is 'Blank when null' option in Properties | Text Field of a field

alternatively

You mat check

Edit | Report Properties | More... | When no data

is it OK for your requirements?

Fidelio said...

Great! thanks, let me prove it and i'll tell you what happens. Thanks again

Fidelio said...

Hi again! i checked your suggest, it was great for another issue i had. But i could get the solution to the one i asked you before by using the: "condition" in the Text Field Expression.

it's something like this: (<*condition*>?<*what if it's true*>: <*what if it's false*>)

Mine is:
( $F{comprobantes_pago_solicitud} == null ? "Solicitud escrita" : "Solicitud: " +$F{comprobantes_pago_solicitud} )


Thanks for your help

Shamsuddin Ahammad said...

Thanks Fidelio

Fidelio said...

Hi Shamsuddin, it's me again.. i got another issue with the ireport, maybe you can help me again.

look, i have a multipage report. one of the columns in the report is an amount, at the end of the page the report have to indicate the total sum for all the entries in that column for that page (i did it already) and the beginning of every page (starting from the second ) i must put the total from the previous page.

for example:
page 1

....
TOTAL 1234
---BREAK
page 2
TOTAL 1: 1234
....
TOTAL 2345

i don't know how to put the total from the previous page, can you help me? thanks

Shamsuddin Ahammad said...

If you want like below:

Page 1
...
...
...
Page Total 5

Page 2
Previous Total 5
...
...
...
Page Total 7

Page 3
Previous Total 12
...
...
...
Page Total 3

That is if you want to show the total of all previous pages, create a variable total that sums the amount and show this variable on the page header