RDLC reporting (2013R2) - Read picture/image from external SQL DB

mtlmonk

Hi,

I would like to know if it's possible to have a nav rdlc report read an image/picture from an external sql database?

Example: A report that would print the list of items (from NAV) but display the picture obtained from an external sql database?

We would call that external SQL DB with the item no. from NAV.

Thank you.

txeriff

Hi mate,

I don't have sample code here but there is a way. In the development ive got it downloads image to tmp file from url and then loads into a blob again.
Sadly it was in nav 2015 and in my current job they run older version.
I suggest following:

Create a linked object type of that table from external database ( make sql view and then link to nav or something like this)


Read that table as normal nav object and work with that image, maybe you need to copy to temp blob .
Work wuth this a bit around.

txeriff

Hi Mate,

I mean this:
https://msdn.microsoft.com/en-us/library/dd339076.aspx

then, when youve got your external database data in your NAV, you can read that image I suppose, place it into temporary blob with each get.
This view would be: item no, item image.
So on each aftergetrecord() you go to your linked object, find the image by item no. and pass variable to report.

txeriff

Hi mate,

I don't have sample code here but there is a way. In the development ive got it downloads image to tmp file from url and then loads into a blob again.
Sadly it was in nav 2015 and in my current job they run older version.
I suggest following:

Create a linked object type of that table from external database ( make sql view and then link to nav or something like this)


Read that table as normal nav object and work with that image, maybe you need to copy to temp blob .
Work wuth this a bit around.

mtlmonk

Hi, thanks for the reply.

What do you mean by "make sql view and then link to nav or something like this"?

txeriff

Hi Mate,

I mean this:
https://msdn.microsoft.com/en-us/library/dd339076.aspx

then, when youve got your external database data in your NAV, you can read that image I suppose, place it into temporary blob with each get.
This view would be: item no, item image.
So on each aftergetrecord() you go to your linked object, find the image by item no. and pass variable to report.

mtlmonk

Never mind. I used LinkedObject feature with Distributor Transaction Coordinator setup (Allow Inbound/Outbound)