Recent content by timroop

I'll answer my own question. Thank you for reading if you've gotten this far. I had not rebooted after loading the Database engine downloaded from: https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=13255 Have a great day! Tim Roop "If you can do something about it, why...

I am using the below code: select * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'excel 12.0;HDR=yes;imex=1; driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; extended properties=excel 12.0 xml; Database=\\sql2016\Imports\SETUP.xls', 'select * from [Employees$]') I get an error...

We determined how to create a new Data source and remap the report to use it. Thank you for taking the time to look at this anyway. T Tim Roop "If you can do something about it, why waste time getting upset? If you can't do anything about it, why bother getting upset on top of it? -Shantideva

We have migrated our databases to a new sql instance on the same server as the current instance. Is it possible to change the sql instance that the entire report server refers to? ie. Our current SQL is named SQLData and the new instance is SQLData\Version10. Is it possible to migrate the...

This has just popped up today. Clients reported that email was down. I seem to be able to send and recieve from the local network. However outside users are unable to send but can receive. I am not able to telnet to port 25 from outside. Inside telnet works but each character manually typed...

The report server is simply a default install with only a few reports published. We have two groups (payroll, and HR). I have not denied any rights and the only permissions have been setup through the report server. Other users in the groups have no problems with retrieving the reports. In...

I have one user (a member of HR group) that does not see the report list on the server's main HTTP://Server/reports page. The user gets the page header down to the line above the bar that shows "New Folder, New Data source, etc" Is there an Add-in or other control that I'm missing? I've...

I have a view returning a list of checks and related employee information. The important fields here are CheckDate, CheckAmt, EmployeeID, and EmployeeTermDate. I need to return the last check for employees that have been terminated (EmployeeTermDate not NULL). However the view returns all...

RiverGuy Thank you so much. That last bit of code was the closer. I was close but couldn't get the last bit down. Tim Tim Roop "If you can do something about it, why waste time getting upset? If you can't do anything about it, why bother getting upset on top of it? -Shantideva

I need to return a period to date total as well as a last value from a table. Given the following data set... Declare @Temp Table(EmpId VarChar(20), Checkdate smalldatetime, Gross_Pay numeric(19,5), IRA_Contribution numeric(19,5)) Insert Into @Temp Values('01123DOE', '01/01/2010', 500.00...

I accepted IE8 and it's updates for install to our workstation group. We then found that IE8 didn't like one of the main websites (bank) used by our accounting dept. I have since created a NoIE8 group and moved the appropriate computers into it. I then set all of the IE8 updates to be...

We have the situation where a payroll was run and it created an ACH batch for processing. The payroll was then voided but the ACH batch is still listed in ACH Maintenance. If you view the detail, the transactions all show checks by either Void or Man. Void. My first thought was to go ahead...

Thanks for the reply janakiranmp. I have most of that covered. Could you elaborate on the COM+ account credentials? Tim Tim Roop "If you can do something about it, why waste time getting upset? If you can't do anything about it, why bother getting upset on top of it? -Shantideva

Dynamics GP Professional 9.00.365 Integration Manager 9.00.0047 We have a few users that need to use Direct to Table imports in Integration Manager. We set the integrations up on one of our IT dept computers and everything works fine. The same integration fails on the end user workstation...

I found and deleted user from the SQL Security Logins portion and GP allowed me to delete the user. Thank you. Tim Tim Roop "If you can do something about it, why waste time getting upset? If you can't do anything about it, why bother getting upset on top of it? -Shantideva