1. Jochen Peters
  2. Valentina Reports ADK
  3. Четверг, Январь 25 2018, 09:38 AM
  4.  Подписаться через email
Hello.

I am a xojo developer and I use Valentina Studio Pro to make reports.
I want to make a report on which I want to display an image. I use mssql.
On the report I use the control "Picture" and I choose to display the field from a column (type:image) of my table.
The image contains binary data. It didn't display anything. Then i retry with a column type: varbinary. Again it didn't display anything. (I don't want to display the image from a path [URL])

Any idea about this?

Thank you very much.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello George,

Does the Data Editor show this image?
What format of the image and the size?
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
Hello mr Sergey,

the data editor shows the image only when i send the path and no the binary data.
The format of the image is 'png' and the size is 23,3 and the dimensions are 280x80.
In the same table I have saved the based 64 decode too. I show the image on my program from this column ( I just encode this column)
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Found the problem, by default the data size returned by the SQL Server is limited to 4 Kb.
In the Valentina Studio we change it, and also there is an option, but for reports, it was left on the default level.

Of course, we'll fix it in the next version, but also there is a fast workaround - you can set the desired data size in the pre_build SQL script of the report, like I did (on the screenshot)
Вложения
Ссылки
  1. http://valentina-db.com/bt/view.php?id=8167
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
I made this change but now when I choose the "mode preview" i have this result (check out the screenshot).
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
What version of SQL Server is used?
Could you please add a screenshot of the pre_build script window?
Вложения
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
I have Valentina Studio Pro 6.6.9. (just for info).
I use mssql 2008 r2.
I didn't set up the report yet, because i want first to display an image.
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Thanks, now it's clear, in the version 6.6.9 there were only the SQL scripts, so you should write just
SET TEXTSIZE 65000;
(without [SQL] part)
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
It doesn't show any image yet, but I can see my report now . I changed the pre_build like you said.
:/
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
About the Data Editor it wasn't clear to me.
If you open this table in the Data Editor or execute the query in the SQL Editor, can you see the image?
Вложения
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
Here, i have some screenshots.

I really thank you for your support!!
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Is it possible to update at least to the next version?
http://valentina-db.com/download/prev_releases/7.0.4/

The workaround doesn't help in 6.6.9, but only in the next, 7.0.4.
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
I think i cannot.
My license is only for 6.6.9 so i cannot update to 7.0.4.
So, there is no way to display the images from mssql?

The other way, is to save the images on a path (temp folder) and display them from this.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Yes, no direct way before 7.0.4
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories