基于查询结果从server2拉出动态外部图像......等等！ [英] Dynamic external images pulling from server2 based on query result ...and more!

问题描述

有人指出我正确的方向。我正在努力解决这个问题。

我销售的产品与他们有关联的cad图纸。我希望我的用户能够上拉或内联查看该项目的唯一绘图。 

所以我的表格看起来像 

<强>物品＃&NBSP; &NBSP; &NBSP;产品与NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;绘图

100  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;玩具&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;   {玩具绘图jpg}

200  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;锤&NBSP; &NBSP; &NBSP; &NBSP; {Hammer Drawing jpg}

300  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;麦克风&NBSP; &NBSP; {麦克风绘图jpg}   

或者看起来像

项目＃  &NBSP; &NBSP;产品与NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;绘图

100  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;玩具&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;   点击查看图纸

200  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;锤&NBSP; &NBSP; &NBSP; &NBSP;
点击查看图纸

300  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;麦克风&NBSP; &NBSP;
点击查看图纸

解决方案

嗨Mr.Adam

根据您的描述，您似乎想要在报告中添加外部图像。

图像是否存储在同一服务器中报告服务器。

如果图像存储在其他文件服务器中，您是否可以尝试检查是否可以通过图像属性访问文件服务器：

如果看不到文件服务器，似乎它无法支持文件服务器，您最好尝试将
  所有图像上传到报表服务器，然后您可以在报表中添加外部图像。 / p>

然后使用表达式如=" / folder1\4 " &安培; First（Fields！item.Value，" DataSet2"）& " 5.jpg"

希望它可以帮助你。

最好的问候，

Eric Liu

Someone point me in the right direction please. I'm struggling on this one.

I sell items that have cad drawings associated to them. I want my user to be able to pull up, or inline view the unique drawing to the item. 

so my table would look like 

Item#     Product            Drawing

100             Toy               {Toy Drawing jpg}

200             Hammer        {Hammer Drawing jpg}

300             Microphone    {Microphone Drawing jpg}   

Or could look like

Item#     Product            Drawing

100             Toy               Click to View Drawing

200             Hammer        Click to View Drawing

300             Microphone    Click to View Drawing

解决方案

Hi Mr.Adam

According to your description , seems you want to add the external image in your report .

Does the image are stored in the same server with the report server .

If the image are stored in other file server , could you try to check if you could access the file server via the image properties:

If you could not see the file server , seems it could not support the file server , you’d better try to upload  all the image to the report server ,and the you could add the external image in the report .

Then use the expression like ="/folder1\4" & First(Fields!item.Value, "DataSet2") & "5.jpg"

Hope it can help you.

Best Regards,

Eric Liu

这篇关于基于查询结果从server2拉出动态外部图像......等等！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！