Hexagon Geospatial
MENU

Support GeoMedia Smart Client

GeoMedia Smart Client community discussion board is where you can create, contribute and share information and knowledge in regards to configuring as well as working with GeoMedia Smart Client. Find your answers, share your knowledge and help build a strong GeoMedia Smart Client community.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Occasional Contributor
Posts: 11
Registered: ‎05-08-2016
Accepted Solution

Can not display image from database using telerik report

Hi All,

I had a problem when creating a report using telerik

the problem is that the report can not display images from the database

I've been reading this site http://smartclient.intergraph.at/documentation/FormReport_(How_To), but no clue how to display an image of the database

when I create a workflow form, the form can display the image, but can not display images in the report.

error is displayed in the report are:
An error has occurred while processing PictureBox 'FOTO_RUMAH':
Invalid image data.
InnerException ------------- -------------
Could not find a part of the path 'C: \ Program Files \ Intergraph \ GeoMedia
SmartClient \ Program \ Workflows \ form \ DownloadReport \ Pictures \ 63-71-040-006
\ Building \ null_rumah-0-458396283.jpg '

path from telerik: C: \ Program Files \ Intergraph \ GeoMediaSmartClient \ Program \ Workflows \ form \ DownloadReport
path from database: Photo \ 63-71-040-006\ Building \ null_rumah-0-458396283.jpg

Can I change the default path telerik report?
or do you have another solution?

 

Thanks & regards,

 

Yusof Zaky

Contributor
Posts: 38
Registered: ‎12-03-2015

Re: Can not display image from database using telerik report

Hi,

I have the same problem. I have lnik to pictures stored in the data base as "photo" atribute -  http link i.ex : http://62.87.200.137/mmw/Upload/Files/reper1.jpg . How to insert it in the report - detail report generated per each object?

I would like to have on detail report a map per object (already done as form map) and picture of ech object.

Thanks for your help.

Regards.

Staff
Posts: 764
Registered: ‎10-18-2015

Re: Can not display image from database using telerik report

Hi,

 

you should use a http link for the formfield of type image

<FormField name="Image" type="image" datatype="string" persisted="false" defaultvalue="http://localhost/WorkflowFiles/{FORM.APPLICATIONNUMBER}/{FORM.FileNameNew}"/>

 

and then set the value property of the picture box in the report accordingly. In my case:

=Fields.FORM_Image

 

HTH,

Stefano

Stefano Turcato
Presale Engineer
Hexagon Geospatial
Occasional Contributor
Posts: 11
Registered: ‎05-08-2016

Re: Can not display image from database using telerik report

Hi Stefano,

 

Thanks for your help,

 

now my report can display image from database

 

 

Regards,

 

Yusof Zaky

Contributor
Posts: 38
Registered: ‎12-03-2015

Re: Can not display image from database using telerik report

Stefano,

Thanks.

It works when I have http path in the table column. But when I have in the column GMSC upload path i.e

C:\GMSC_warehouse\WorkflowFiles\50\e88fc118-90d0-4fa3-aea1-b89653e99065_Opis topograficzny.tif

Should I change it in to http link? Ok. But how to select the filename. Is there an easy way? Of course I can extract the filename from uploadir in to a new column. Is it what you meant under "FORM.FileNameNew"?

 

Staff
Posts: 764
Registered: ‎10-18-2015

Re: Can not display image from database using telerik report

Yes that what I meant, and it is not needed to store it in the db, just use another formfield to build it:

 

<FormField name="FileNameNew" type="textfield" datatype="string" persisted="false" defaultvalue="SQL[SELECT reverse(left(reverse(FilePath), charindex('\', reverse(FilePath)) -1)) from BUILDINGEXT_ATTACHMENT mf where Master_Id = {FORM.ID}]"/>

 

ciao,

Stefano

Stefano Turcato
Presale Engineer
Hexagon Geospatial
Occasional Contributor
Posts: 10
Registered: ‎11-21-2015

Re: Can not display image from database using telerik report

Can we extend this maybe to read an image / bitmap output from a .dll or webservice. ?

We are looking at ways to integrate a dynamically generated QR code in the report.. ref the thread https://community.hexagongeospatial.com/t5/Support-GeoMedia-Smart-Client/QR-Code-in-GMSC-Telerik-rep...

Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.