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

mtlmonk · 2018-01-22

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 · 2018-01-22

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 · 2018-01-23

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 · 2018-01-22

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 · 2018-01-22

Hi, thanks for the reply.

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

txeriff · 2018-01-23

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 · 2018-03-06

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

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

Best Answers

Answers

Categories