bmorriso99
asked on
Trying to dynamically change .xls folder and file name on OLE object in report
I have a table in SQL Server
graphic_dir (table name)
foldername
filename
ordernumber
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?
graphic_dir (table name)
foldername
filename
ordernumber
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Suggest you accept your comment as the solution. My comment is not really a solution and you don't need to award the points
mlmcc
mlmcc
ASKER