gchansc - Wednesday, September 23, 2015 8:27 AM:
Hi,
Is there any way I can get Report Builder to display images stored in the Aras Vault for a PDF output document?
I can only see the "vault:///?fileID=xxx" in PDF output document.
Appreciate any pointers that can lead me to the right path.
Many thanks!
tstickel - Friday, October 9, 2015 10:03 AM:
gchansc
The following works for me:
1. In SSRS, I define the image field with "Select the image source" = External. I also set "Use this image" as an expression, such as = 'localhost/.../vaultserver.aspx
Notice that you must replace YOURDBNAME, YOURFILENAME, YOURFILEID with values appropriate for your needs. I am not sure that the most recent releases of Innovator require both the image's filename and fileid, but when I wrote this for Innovator 6 or 7, they both were required.
2. In my Innovator vaultserverconfig.xml file, I added the following:
<enforce_user_credentials>0</enforce_user_credentials>
Again, I am not sure that the most recent releases of Innovator require this. I have a vague recollection that there were some vault security ramifications of adding this setting, but I do not recall what they are.
gchansc - Monday, October 19, 2015 8:09 AM:
Hi tstickel,
Your methods works. But one question in mind is:
Is there any other way without enforce_user_credientials set to '0'?
This will be a security concern. Cuz once set to 0, unanthorized users can (if they really wanted to) view other files in the Vault folder by manually typing in the html link and then edit the filename and and fileid, even if the file item has set 'can view' permission for only authorized users can see the file.
Thanks for your reply!
tstickel - Tuesday, October 20, 2015 9:56 AM:
gchansc,
You could try the following to access the vault from SSRS without enforce_user_credentials set to '0'. I have not actually tried this, but it could work:
- Write a C# Class that utilizes the Innovator IOM to directly access the vault. The Developers Forum includes several examples of this which you might use as a guide. See www.aras.comhttp:/.../508.aspx for one example. This example is several years old and may need to be modified for more recent versions of Innovator. The C# code must include the Innovator user name and password for a user that has 'can view' permission for the file.
- Modify your SSRS Report Properties to be able to access the .dll of the C# Class. Modify the expression for the external file reference to invoke your C# class. See davidgiard.com/.../CallingAnExternalAssemblyFromSSRS.aspx for an example of how to do this.
Again, it is only my guess that this approach will work.
