Search results for query: *

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

We have the situation where GP users have been removed from the SQL database users but are still present in the User setup in GP. When you attempt to delete one of these IDs the system reports a SQL error and recommends that the SQL administrator be contacted. My thoughts are that the user IDs...

While not exactly what I was hoping to hear, We'll look into those options. Thank you. 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

Our CFO brought this to me today. When we go into Tools |Routines |Payroll | W-2 Magnetic Media only one of our current companies shows up for the 2008 filing year. If we change the year to 2007 all of our companies show up. The company that shows up also lists the correct date when the...

winthropdc: Thank you for the reply. I do understand how to enable/diable the primary modified report using security. We would like to switch between two different modified reports. Could you please elaborate on how to "create secondary copies and run them from custom reports"? Thank you...

Maybe it is the way we were taught but I don't know this. Is it possible to have more than one version of a modified report? We have a modified SUTA report that has no SSNs. We also have a need for a simple line item report that has no headers or footers. Basically I need to know if it is...