Search results for query: *

I use this delete query to update 4 tables. Is there a way to set a parameter for the field "siteno" so I only have to enter 1 time. Thanks use [acr] go delete sb.SiteContractBill where SiteNo = 'PA0041' go delete sb.SitePMInspection where SiteNo = 'PA0041' delete...

Hello, Looking to set up a report (CR11) to print inventory labels from an SQL database on a Dymo Labelwriter. Anyone have any hints, documentation or any information to get me started? Thanks

CR11 SQL Database This seems simple enough but... I have a simple report that lists open invoices. I want to limit the report to the highest 25 invoices. Looks like I could use the TopN or Topcount function but I am confused over the correct use. Thanks

Using CR 11 Pro, SQL Database I have a formula that converts the result of one formula to a negative based on a parameter. if {TRXHISTORYHDR.TRXTYPE}= 3 then -{@Total Amount} else {@Total Amount} Once I convert the number to a negative I need to sum the result on the report. The sum function...

This is probably pretty easy but I need help with a selection formula. I want to first select customers by their contract date from one table and then include transactions from another table, based on a date range, if any. If there are no transactions just display customer info. The formula...

Hello, I am looking to install a Dell PN# 07212T MDL# STD2401LW Tape Drive in a Dell 400SC. Does any one know how I can find the correct SCSI Controller Card for this Drive? Thanks in advance.

Hello, I recently purchased a new dell server pre-loaded with standard server 2008 and a total of 10 cals (5 extra). I do not see any tools to view the license specifics. How can I tell I got what I ordered?

Hello, I am running SBS 2003 with SP1. I recently installed the Exchange SP2 to get the IMF functionality. The SP2 installed without error but it does not seem to have installed the IMF. Am looking under the properties of the Default SMPT Virtual Server and do not have the additioanl tab. Does...

Hello, Looking for the best practice opinion as I have read several solutions to date on this subject... I currently have a 10 pc workgroup attached to a Netgear FVS318 Router which is acting as a DHCP server. I have a server with SBS Server 2003 installed that will be the DC. My ISP uses...

Hello, I have a field that consists of URL's visited by multiple users such as http://www.yahoo.com/black http://search.yahoo.com/new http://signin.yahoo.com/mail http://www.epix.net/ http://cgi.epix.net/blue I am using Crystal reports v9 and am looking to create a formula to be able to...

I currently have a site created with FP2002 and hosted on a Linux Server with FP Extensions. The server does not support ASP. Is ther a way that I can password protect a page. I want to have an area where current customers can input a password and go to a page with special pricing for my...

Hello, has anyone ever tried outcalling to a Nextel Phone. Nextel has a numeric paging message gateway but I have not been able to get the string right. We currently outcall to a numeric pager with no problems. I have it set up currently as 9*233XXXX******0002330000#9999# with 233XXXX being the...

Need some help getting started on a new project. I have about 200 customers that have contracts each expiring on a different date but with data that spans over several contract periods. I need to summarize the data for the current contract period for each customer and then for all current...

I have recently installed the "5 Named User Complimemtary" Copy of CE on my Windows 2000 server. When I try to log in to the CMC via my browser typing Administrator with no password the user field just goes blank with no error message. All of the services are running via the...