Search results for query: *

I have been tasked with using a 4-4-5 date scheme and have created a SQL command to query a table to calculate beginning and end date for periods. I have determined the command itself returns the result quickly, but if called from the select expert it is slow. Here is the SQL command...

We upgraded the other night to version IP Office 9.1 and had several issues with the soft console. First could not login which turned out to be that the current 9.0 soft console and previous releases will not work with 9.1. Would receive Login error. After upgrading to the new version was able...

We are doing some heavy development with Wisys and Macola 7.7 and need to set up a different Progression and SQL environment that will not affect production. I have both a separate Dev Macola server and Dev SQL server available. Would like to restore production data to this Dev SQL Server and...

I have 2 brand new HP XW4600 Workstations. After Last weeks Microsoft Security updates for May were downloaded and installed on these workstations, they Blue Screened and kept rebooting directly after login. I windbg the mini dumps and it seems to point to CSRSS.EXE crashing after these updates...

I have a named instance that is installed on a local machine with SQL Express. When I try to connect to it remotely , I get "under default settings SQL Server does not allow remote connections." I go to the configuration manager, but I can not see the named instance to set "allow remote...

Hello, I have a report that contains a formula field in it. I am trying to filter out all records that contain whole integer values that are diplayed form the formula field. If it says 1.00 or 8.00, I want to filter these out, but if it says, 0.92 or 2.83 I want to display these on the report...

I have a report that is displaying the detail for items sold vs available quantity. I have a running total formula that tracks when Item sold exceeds Qty_ON_HAND. This is based on a formula: {IMINVLOC.QTY_ON_HAND}-{@RunningTotal}>=-1. This gives me a True/False response sorted by ship date. I...

Hello, I have a user account that is missing. When I look in the Visual Menu Builder she no longer exists. When I try and create a new account for her, it states that New User is already on file. If I look into User Module Maintenance she exist. How can I get this user back? Where does the...

Windows XP Pro using Fortigate Client. I connect via Wirless WAN connection. I start the Fortigate Client and connect succesfully VPN to Fortigate 200. One issue is I have to log in first to windows via Doamin cached account, then connect to Wireless, then to VPN. I am not able to browse the...

Hello, I want a field from database when returned to ASP page to display in Currency. I have tried FormatCurrency, but cannot get it to work. I would assume there is an easy way to display the data returned in Currency Format. Any help would be appreciated. This is the error I receive...

Hello, Using VFP 6.0.I have some code to run through some files and make some changes to data for conversion. I would like to print the fields of the records I am changing. I can not figure our how to make it print. I need the code to print the records I have touched. Currently just get a...

Crystal 8.5 I have a parameter fields that can be multiple plant codes. I created a formula field to coincide with the plant codes and listed descriptions. In report header I want disply Plant code along with the description from formula field. If user select one plant then it works, but if...

I need a Formula that will calculate the previous full year date range of 01/01/year to 12/31/year. My formula is: if {Table.date}>=dateadd{"yyyy",-1,#2006/1/1} and {Table.date}<=dateadd{"yyyy",-1,#2006/12/31} then {Table.qty} I do not want to have to key in the dates in the formula, but I...

I am writing a report that pulls information for Month to Date, Year to Date, Previous Year Month to Date, and Previous Year Year to Date. I am able to do this using Date Params {?MTD}, {?YTD}, {?PYTD}, etc.. I have it set to run on the Nth day of month in eportfolio. However; I have to...

I have a client runing Exchange Server 2003 with all the clients on Outlook 2003. The client I believe has both personal .pst files as well as Exchange Mailboxes. They wanted one calendar that all can see, to keep up with upcoming jobs and schedules, etc.. I have created a Public Folder Calendar...

Just purchased a HPML570 G3 server. I am not able to put the OS and the log both Raid 1+0 sets onto one channnel and the database Raid 5 on the other due to the physical drive cage make up. These new servers have a 8 + 2 Config. So which should I put; the OS or the Log, on the same channel with...

I am looking to add two 2003 servers to already existent 2000 domain. I have two servers with two different forest and domain, but have a trusted relationship between them. I want to add the new 2003 servers to one of the domains. Once I perform the adprep/forest and adprep/domainprep on the...

I am trying to create an announcement on our switch and I am not sure what I need to accomplish this. We have a Definity G3si v6. We only have basic CMS, so I do not believe we have the ability to vector. I want to be able to have a user talk to the attendent then when being transfered to...

We are running GP7.5. When we choose to print the W2's the form type W2 LASER is not in our list to choose from. I can go to the report writer, and I see the W2 laser report listed there. I have tried to import it and set the security for the user, but I do not see it in the list to choose from...

I am wondering what I need to be able to set up two com ports for a CDR software package we are looking at purchasing. We have a Definity G3si v6.0. I have TN2224 digital line cards installed. I assume I will need to purchase a 8400B data module. My question is do I only need to use two...