I got it to work!  Here is how.
I  did a UNION of Production and Estimating Hours setting Estimating Hours to zero in the Production Query and Production Hours to zero...

Ya'll ready for this?  Two of the fields I return are a description and a sort order for an enumerated field.  Rather than put in case statements that may require...

I found it! One stupid line that was almost hidden in a rectangle.

If anyone is interested, this works...

="void window.open('" & Globals!ReportServerUrl & "/Pages/ReportViewer.aspx?"

& Globals!ReportFolder & "/Labor+Detail"

& "&StartDate=" & CDate(First(Fields!pStartDate.Value, "dsOrdSummary"))

& "&EndDate=" & CDate(First(Fields!pEndDate.Value, "dsOrdSummary"))

& "&ID=" & CStr(Parameters!ID.Value)

& "&Dept=DETAIL&Dept=VENEER&Dept=MACHINE&Dept=CABINET&Dept=FINISH&Dept=METAL&Dept=SHIPPING&Dept=INSTALL&Dept=OTHER"

& "','_blank')"

I've dropped all but the one link as follows. Both the SQL Server and Excel are 64 bit so the ACE drivers should work.

EXEC sp_addlinkedserver

...

Current status is I have created three different linked servers, none of which work. Below is the server configs and the logins. The Temp folders have full access...

Both are set up with full access, so that is not the problem.

It turned out to be easy...

=Split(Join(Parameters!JobNum.Value,","),",")

One more thing... I even tried creating a parameter that would identify when the second report is being generated as a pass through called PassTrue. I then pass True...

That looks so much better than the ugly CASE. Looks like it is time for me to lookup PARSENAME and REPLICATE. If I ever learned them, I forgot...

I got it, but it is ugly...

SELECT 'STUFF 2'

, JobNum.JobNum

, CASE WHEN CHARINDEX('-',JobNum.JobNum,CHARINDEX('-',JobNum.JobNum)+1) - CHARINDEX('-',JobNum.JobNum) = 2

...

The result will be used in a query for sorting so the length will not matter. If I need to store it in a temporary table I define it...

I found the answer in the Event logs (the first place I should have looked).

Login failed for user 'Administrator'. Reason: An attempt to login using SQL authentication failed. Server is...

Does anyone want to take a stab at why my SQL server to SQL server linked server is not working.

Here is what I have done and the results.

I...

Another question. should the SQL Server Browser service be running? Or is that to give clients access to SQL not the other way around?