Recent content by Timmkatt

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...

Not all of the fields are displayed in the report and are used to filter the data. For example the driver field is used so the report does not count any trips that did not have a valid driver employee number (1 to whatever) assigned which means it did not run "Trips.Driver is not 0"...

Thanks here are the queries Main Report: SELECT "Trips"."ServiceType", "Trips"."EstTripStart", "Trips"."ID", "Trips"."Description", "Trips"."Passengers", "Trips"."AltPassengers", "Trips"."AltPassengers2", "Trips"."AltPassengers3", "Trips"."MaxPassengers", "Trips"."Direction", "Trips"."Driver"...

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...

Works Great! One more question can I make the date parameters a range for each Type? Thanks again in advance!

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...

Not exactly. It is that we want to tell our users once "to reach the dispatch desk, dial (EXTENSION ID) 8003" regardless of who is logged into the phone. Without this we would always have to update our staff at the 7 other locations every time a shift changes Who is logged in since it would...

The reason we want this is that we will have various users logged in at the dispatch phone depending on the day or shift. This is our central point of contact for our other offices, drivers etc. Sometimes it can change on the fly who will be at the desk. They also answer reservation calls so...

Thanks for the advice but we got the soft code and it is working. Here is the code we used 8xxxN dial extension by ID 8N# We tested it and it is working as we need it to.

We figured out that we can program it to still dial the phone in question by the extension ID number like extension 1103 can be reached regardless of who is logged in at 8003#. Is there a way to program it so we do not have to dial the #. We would like to just be able to dial the 4 digits just...