Search results for query: *

I have a Crystal Report in which I have (2) dynamic parameters created: ItemID (this is a string using list of values = static) Serial Number (this is a string using list of values = static) The user will enter and Item# and it's corresponding serial number, which will then...

Thanks to whomever might have this SQL statement for me to try! [2thumbsup] The table name is ACCOUNTS. Field 1 = ARCustomerNumber Field 2 = AccountID We would like a SQL statement that will 1. Clear the data from Field 2 ACCOUNTID 2. Copy the data from Field 1 ARCUSTOMERNUMBER into Field 2...

Hi! [santa3] Can anyone help me strip out some results / text values from a memo field in Crystal Reports XI? {tvw_JournalNotes.Notes} One result returns: Made Call: (I want to eliminate any of these results) Second result returns: *Series...." (I want to eliminate any of these results) I...

Hi! I have an image field that I would like to add to a report. Basically, if the image field contains a signature, I would like to have a column that says Y for yes. But if the image doesn't have any data, I would like the column to say N for no. Would anyone be ale to help me with this...

I need some help with a Past Due Invoice report. The current report is based upon any invoices with an AGE greater than 30 days. Here is the info I have currently: @AGE FORMULA: datediff("d", {JrnlHdr.TransactionDate}, CurrentDate) @AgingBracket2 FORMULA: if {@Age} > 7 and {@Age} < 20000 then...

thread767-1450985 In Crystal Reports XI: I'm trying to get a list of accounts for which there has been no activity over the past 2 years - based upon a task start date. Ideally, I need a list of these accounts/customers so we can have someone begin calling on them. The specific data field...

I have a bi-weekly payroll hours report, that currently 1 grand total of all hours per employee for the 2 week period. It also has a total of hours for each day. I need to sum the totals for week 1 and week 2. Also, I need to combine the type of timelogs by Regular, Overtime, Vacation and...

Using CRXI - I need some help with formulas along with the "summary" total add up values for the formulas based upon the result of either YES or NO. MAIN REPORT Here the basic data: tblAccounts.AccountName I'm summarizing this field based on "distinct count" This provided me with 288 total...

I need a SQL script for the following: Select a specific account ID from tblAccounts that has a warranty expiration date of x. SELECT tblAccounts WHERE AccountID = '15391' (which is the account ID) then SELECT tblCustomerInventory WHERE WarrantyExpiry = '05/30/12' and then I need to replace...

I have a string value: tblCustomerInventory.Serial Number. The results display the serial number in multiple values. How do I format this data to appear across the page from left to right - so I don't eat up so much paper when displaying/printing the report?

I have a report with 2 groups. Group # 1 = Account Name Group # 2 = Phones The phones group is also the following formula: If {tblCustomerInventory.ItemDescription} like ["*Phone*", "*Terminal*"] then "Phones" else {tblCustomerInventory.ItemDescription} I'm trying to get the detail for...

Need some help grouping data according to string formulas. I created 5 formulas: @Aspire @ISeries @SV8100 @UX5000 @Zultys The aboveresult in either a true or false. How can I group the rest of the data based upon the above, if true? Phone System Type field is called...

I need some assistance in a boolean formula. Here is the info: 1. tblAccounts.AccountType I have my select expert formula showing only: {tblAccounts.AccountType} in ["CSA Customer", "CSA/Data"] 2. tblAssignedAccountGroups.AccountGroup [String =50] I only want account groups that contain...

I need to filter text from within a field name called: tblServiceOrders.GeneralResolutions - this is a memo field in Crystal Reports XI. Within the text of the database, I need to set certain criteria where the text contains the following ONLY: WS Windstream DID Can someone tell me what the...

Need some formula help in Crystal XI. I have 2 inactive rep names. KK and LM. The table field is called "{tblReps.RepName}" If they appear during the printing of the report, I want the value to display the words "Customer Service" Can anyone help me with this? Thanks!

I have 2 fields in my report with the following criteria in the "select expert" {tvw_CustomAccountFieldData.CustomFieldLabel} in ["Date Site Survey Complete", "Digital Ports Available", "Phone Software Level", "Phone System Type", "VoiceMail Software Level", "Voicemail System Type"] and...

Crystal Reports XI: See the attached report and the highlighted areas for Harris House Foundation - the first one - Inv# 6741. I need to know how to suppress this record if the Comm Amt = $0.00 so that all related information does not display. Also, it would be helpful if the area that is...

Crystal Reports XI I have a field name = tbl.InvoiceDetail.ItemID What I need to do is this: If the the above field name "contains" a "U" , I need to have the result be the above but without a "U". (i.e. the U needs to be stripped off the end?) Example: Field value - result is 0890043U If...

Crystal Reports XI I have a field name = tbl.InvoiceDetail.ItemID What I need to do is this: If the the above field name "contains" a "U" , I need to have the result of my formula (@TotalCOGS) * .80 for those item ID's that contain the U. Can someone please help me write this? Thanks!

Crystal Reports XI. I have a field name = tbl.InvoiceDetail.ItemID What I need to do is this: If the the above field name "contains" a "U" , I need to have the result of my formula (@TotalCOGS) * .80 for those item ID's that contain the U. Can someone please help me write this? Thanks!