I know how to create linked reports in Report Manager but I don't understand what you mean by creating a parameter for Badge or No Badge. How is that...

Yes, I can access the files and create a file of employee id number to compare outside of SQL. I was hoping for a solution that Report Manager based...

Thank you for the response! When I try the solution above using the expression example given, none of my pictures are showing up. I currently have the following...

I was hoping to have a report that our security department could run from Report Manager to show which employees do not have a security badge. Basically this report...

Thanks for the reply! The images are stored on a network drive that the badge system automatically stores them to. I am not having any problems getting the...

Since she is the only one that can even get to the folder and she only has Browser security, she can't make any changes to the Security settings.

bump

I am using embedded datasets in my report and your code worked perfectly.

Thank you!

Thank you for the clarification. I appreciate your help!

Thanks for the response! The example looks like it works for employees that would be associated with only one office. Mine will have multiple offices (departments). Am...

I get the following error message when I try to re-create the step:

An exception occurred wihile executing a Transact-SQL statement or batch.

(Microsoft.SqlServer.ConnectionInfo)

OLE DB provider "OraOLEDB.Oracle" for linked server "BUSINESS_LIVE" returned...

Yes, the connection is working. The 2 steps before this one connect to Oracle the same way without any issues.

Any way around that just to do an import? I do not have any control in the structure of the table. We are importing the data from our...