Search results for query: *

Thanks very much!

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

-LB Thanks for your input. You were correct I found another issue not related to the formula which solved my problem. Thanks

Sorry, {TrxHistoryHdr.InvoiceAmt} + {TrxHistoryHdr.SalesTaxAmt} Thanks

The formula {@Total Amount} is a simple addition of the invoice amount plus sales tax and is in the detail section of the report. There are no other formulas in the report. Hopefully I am giving you enough info. I appreciate the response.

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

I had not utilized a subreport before but I spent the afternoon working through it and succeded. Thanks to everyone for your help.

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.

Thanks for your quick reply, I do have the paperwork for all of the cals. I just was not aware that we switched to the "honor" system...

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?

I was doing a little more reading over the weekend... Does the IMF function work with messages that are downloaded with the pop3 connector? This is how I currently get mail from our ISP as I do not have a static IP address and have not taken the time to figure out the configuration utilizing...

Thanks for the replies... I did get IMF installed and have it configured at the global and virtual server levels per microsoft instructions. I have the threshold levels set at 8 and to archive files but it still does not seem to be scanning the incoming mail. Can anyone point me in the right...

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

Brian, Works perfectly! Thanks [medal]

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