Field Blob

Stimulsoft Reports.NET discussion
lucas.ortolan
Posts: 24
Joined: Fri Dec 18, 2015 11:55 am

Field Blob

Post by lucas.ortolan »

Hi,

How to use a field of type BLOB (Oracle) for letters?


Ty,
Jan
Posts: 1265
Joined: Thu Feb 19, 2009 8:19 am

Re: Field Blob

Post 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.
Attachments
RichText.png
RichText.png (37.47 KiB) Viewed 3890 times
lucas.ortolan
Posts: 24
Joined: Fri Dec 18, 2015 11:55 am

Re: Field Blob

Post by lucas.ortolan »

Hello,

I tried to do as explained, but it does not return anything. My field is the image.
BLOB.png
BLOB.png (578 Bytes) Viewed 3885 times

What can I do?

Ty
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Field Blob

Post by Alex K. »

Hello,

Can you please send us a sample report with test data which reproduce the issue for analysis.

Thank you.
lucas.ortolan
Posts: 24
Joined: Fri Dec 18, 2015 11:55 am

Re: Field Blob

Post 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
Attachments
teste.pdf
(81.88 KiB) Downloaded 323 times
teste.mrt
(7.21 KiB) Downloaded 260 times
Script.txt
(2.02 KiB) Downloaded 294 times
Jan
Posts: 1265
Joined: Thu Feb 19, 2009 8:19 am

Re: Field Blob

Post 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.
Attachments
Image.png
Image.png (233.33 KiB) Viewed 3873 times
lucas.ortolan
Posts: 24
Joined: Fri Dec 18, 2015 11:55 am

Re: Field Blob

Post 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,
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Field Blob

Post 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.
lucas.ortolan
Posts: 24
Joined: Fri Dec 18, 2015 11:55 am

Re: Field Blob

Post 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.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Field Blob

Post 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.
Post Reply