Greg, 'once they have run the report' where?...

I have edited the attachment and reuploaded.

Thank you for helping me through this. I was never clear on the free text area, tho in my mind I...

True. I didn't mention it.

OK. so that is the crux of why I don't believe SSRS is the solution.

I believe the solution is either Add-In (application specific) or...

If you insist on not using something like this, I would eliminate Word and just use Excel.

But then what triggers it to run? Maybe a form on Auto_Open to fill...

I need the query generated in response to the parameters and delivered back to the UI (in this case Word) that the end user is using. That end user...

Please elaborate Lynn. Can you give me a step by step?

Someone opens a Word template and enters two parameters....where does Reporting Services come into play?

In earlier post I am...

this needs to be in an application that an end user interacts with regularly and that can easily be shared with others using email. WAnt to make a...

Hi Lynn! Now it's there.

So, did BIGC2269 get what he needed? BIGC2269, what was the issue?

I found this worked.

DECLARE @openorder INT

SET @openorder = 2

DECLARE @Table TABLE (openorder INT)

INSERT INTO @Table (openorder)

SELECT...

Yes, I did think of SSIS solution however I ended up converting the Excel spreadsheet into a .csv file and using Microsoft Query to import it as a table. I...

The solution has been to convert the excel file into a .csv file and import data into Excel with Microsoft Query. Moreoever, since I am using powerpivot, I can...

In the final analysis I cannot (due to permission restrictions) create a new table in SQL Server and I can't store the excel datasource on the same server as the...

additionally, this will not work because the excel file that needs to be queried is not on the same server as the instance of SQL Server that needs to query...

I am following directions at this link:

http://msdn.microsoft.com/en-us/library/aa560998(v=bts.10).aspx

per instructions: "In SQL Server Management Studio, double-click Server Objects, right-click Linked Servers, and then click New Linked Server."

Is this ""Server Objects"...

Jeff, I never thought to look up some German date words and try that STUFF line. Thanks for the idea. :pinch:

I did try the CONVERT (as I said)...