Search results for query: *

I have 2 sub reports in the main report. The first on the left in the example shows all phone reservations made by each agent and a total gratuity amount if they collected any. The second sub report shows all of the phone reservations with zero gratuity's. Is there a way I can pull the zero...

CR 10... I have a report which shows daily revenue totals by day and a subreport that shows refunds by day. The report and subreport data come from different tables. The report looks like this: Mainline Daily Trips Date Revenue Trips Passengers 10/1/2014...

SQL 2005... We are trying to run a query to Identify a duplicate web reservation ID and the related fields in that row if there are any. I came up with this query SELECT WRESID, COUNT(WRESID) AS NumOccurrences FROM res2sql.dbo.Reservations Where serviceType = 1 AND Operation = 'N' GROUP BY...

CR 10. Is there a way to create a report to identify a duplicate reservation ID in the table? The field WRESID would only appear once under normal circumstances but we have a utility that brings over our web reservations that we suspect may be bringing over a duplicate every once in a while. Any...

Using CR 10 Creating a report for our CFO and she would like to be able to run it by either of two parameter values "Run Date" OR "Paid Date". Is there a way to create the parameters so that she can choose which way she wants to run the report without having to create two reports? Thank you in...

When looking into upgrading to 8.0 the information lists the cost to upgrade below 32 users at $99 NPL and above 32 users $199 NPL. What is NPL? Thanks

I have an IPO 500 system V2, version 6.1 Current licenses 42 end point licenses (31 end points currently in use) 27 Customer service licenses (20-24 logged in at any one time) Advanced edition license VM Pro Preferred edition license 3 Supervisor licenses (only one or two actively used at any...

Is it possible to add multiple 2003 servers to an SBS 2011 domain? The 75 user limit is not an issue and the SBS 2011 being the domain controller is not an isuse but I have two 2003 R2 terminal servers and a standalone 2003R2 SQL2005 server that are critical in our business. I do not want to...

IP office 500...We have 5 locations. At our main location we have various agents that will login to our reservation queue. When an agent logs in to a queue at our dispatch desk then you need to call that agents extension to reach the dispatch phone. Various agents will login at our dispatch desk...

In our current office environment we prefer a collective group so that all agent phones ring when a call comes in. This is not supported in the CCR. Does anyone have a work around for using a collective group and still have the ability to use the CCR. Is there any option to have a collective...

My phone vendor will be installing a SIP based VOIP system soon and has requested that I change my internal IP address scope from class a to class c (His words). Although I am a little confused with what he has given me as a suggessted IP scheme. Currently my subnet mask is 255.0.0.0 and my IP...

SQL 2005...Question; I have a free partition on my SQL server with lots of space. I would like to move only my user databases to that partition on the SQL server. Is there any reason to move the system databases also or is it fine to leave them in the default location? Will this have any effect...

Avaya office IP 500...If an agent has more than one login do they need to have a separate license for each one? We have some Reservation agents that work at our main office but may also work at one of our remote offices from time to time. If their main login is associated with a DID for our...

My prior question is posted below but after further evaluation here is more information on my server room electrical feed/ground. The secondary panel is fed from the main panel with 3 thick #4 stranded cables (Black insulator). There is a hot, a common and a third ground lead which is connected...

I'm setting up a new server room with one Rack. 2 servers will go into the rack and a new telephone system will also be installed in the rack in March which will require a #6 ground. The server room will be in a separate small stand alone building and is approximately 80 feet from the main...

Can SQL 2005 be installed and will it run on a 2000 small business server? The server already runs SQL 2000 which is integrated in the small business OS but we need to have SQL 2005 for some programs but also need continue to run SQL 2000 for others. I'm ok adding a second server for SQL 2005...

Currently our main server is running Small Business server with SQL2000. The company that provides our reservation system provides two options in house or hosted. My dilemma is this; we host our reservation system in house and the database resides on the server mentioned above in SQL 2000. We...

CR10- I have several fields that are dollar amounts and are not showing correctly in the report. 50.00 shows as 5000 without the decimal. If I browse the data it appears correctly. Is there a way I can format the field so that it shows as 100.00, 50.00 etc. instead of 10000, 5000? I have tried...

CR10 I need to create a report to compare future reservations from a specific date, For example a report where I can see all reservations with a pick up date greater than current date for 30, 60 or 90 days out but I want to see the same historical information from a year ago so I can compare...

CR10.. I have report which shows a list of travelers and includes 2 subreports to show the total collected today, one for payment type CC and the other for cash. In the case of CC's "collected" means the card was charged and the customer signed the receipt. There is also a third subreport to...