Viewing 15 posts - 1 through 15 (of 21 total)
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...
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
October 16, 2017 at 7:10 am
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...
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
July 11, 2017 at 6:19 am
I found it! One stupid line that was almost hidden in a rectangle.
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
January 10, 2017 at 8:00 am
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')"
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
August 1, 2016 at 1:14 pm
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
...
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
July 18, 2016 at 6:08 pm
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...
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
July 9, 2016 at 3:04 pm
Both are set up with full access, so that is not the problem.
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
July 9, 2016 at 12:39 pm
It turned out to be easy...
=Split(Join(Parameters!JobNum.Value,","),",")
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
June 27, 2016 at 9:09 am
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...
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
June 27, 2016 at 8:02 am
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...
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
June 22, 2016 at 9:05 am
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
...
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
June 22, 2016 at 8:48 am
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...
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
June 22, 2016 at 8:39 am
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...
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
June 9, 2016 at 10:51 am
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...
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
June 9, 2016 at 10:45 am
Another question. should the SQL Server Browser service be running? Or is that to give clients access to SQL not the other way around?
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
June 8, 2016 at 12:22 pm
Viewing 15 posts - 1 through 15 (of 21 total)