Page 1 of 3
Field Blob
Posted: Fri Feb 12, 2016 8:08 pm
by lucas.ortolan
Hi,
How to use a field of type BLOB (Oracle) for letters?
Ty,
Re: Field Blob
Posted: Sat Feb 13, 2016 11:26 pm
by Jan
Hello, Lucas!
You can try to use DataColumn property of the RichText component if your BLOB field contains text in rich text format.
Please check attached image.
Thank you.
Re: Field Blob
Posted: Mon Feb 22, 2016 12:18 pm
by lucas.ortolan
Hello,
I tried to do as explained, but it does not return anything. My field is the image.

- BLOB.png (578 Bytes) Viewed 3892 times
What can I do?
Ty
Re: Field Blob
Posted: Mon Feb 22, 2016 1:21 pm
by Alex K.
Hello,
Can you please send us a sample report with test data which reproduce the issue for analysis.
Thank you.
Re: Field Blob
Posted: Tue Feb 23, 2016 4:42 pm
by lucas.ortolan
Hello,
The following script (txt) to create the tables along with an insert. Report also contains (MRT) as an example and results (pdf) to perform the same.
ty
Re: Field Blob
Posted: Tue Feb 23, 2016 5:43 pm
by Jan
Hello, Lucas!
If your blob field contains an image you can use "Image" component. Please select your data field in DataColumn property of the component.
Please check attached image. Please take into consideration that not all format of images can be recognized by our report engine.
Thank you.
Re: Field Blob
Posted: Wed Feb 24, 2016 5:23 pm
by lucas.ortolan
Hi,
Jan My problem is with the texts, when he tried to pick up the contents of a text blob. Please check attachments.
Ty,
Re: Field Blob
Posted: Thu Feb 25, 2016 10:02 am
by HighAley
Hello.
You are writing about an image but send us the report template with Rich Text component.
Furthermore your sample contains just zeroes and you try to use in in Rich Text component. But there should be right Rich Text. So you don't get anything in the PDF file.
Please, send us a sample with image that you try to use. We need to know the format of the image and it should be used in Image component but not in Rich Text.
If you have Rich Text, then we need to see a sample with correct Rich Text but not with zeroes.
Thank you.
Re: Field Blob
Posted: Thu Feb 25, 2016 12:51 pm
by lucas.ortolan
Good Morning friend
My problem is:
Within a BLOB field got a text however I can not show the text in the report using the Rich Text.
If you run the script sent, and run the report may notice that did not return the zeros that were inserted into the sample table.
Help me please.
Re: Field Blob
Posted: Fri Feb 26, 2016 6:52 am
by HighAley
Hello, Lucas.
Sorry, maybe we have gone in the wrong way.
What data do you have in the BLOB field? Plain text, Rich Text or Image?
Why do you use Rich Text component if you have plain text in the BLOB field?
Please, try to use Text component.
Thank you.