Trying to dynamically change .xls folder and file name on OLE object in report
Posted on 2008-10-10
I have a table in SQL Server
graphic_dir (table name)
I want the user to enter an order number as a parameter and the report reads this table and pulls in the excell spreadsheet that is the foldername + filename.
I have the report reading the table correctly because I am currently displaying the foldername and filename and they are correct. I have an OLE object inserted that points to an existing .xls file and then I went into Format graphic onto the picture tab and then put a formula in the graphic location button. I tried putting in the foldername + filename and also tried putting in just the foldername. Neither one seemed to work.
I read that there was a bug in release 2 that you could not read in a word document location dynamically from a database. Does that include .xls? Does anybody know if it was fixed in the latest service pack or even where I could go to see if it was reported / fixed?