Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ABetha
  • Content: Threads
  • Order by date
  1. ABetha

    summarizing field

    I am attempting to summarize a field {Parts.ReportId} I have summarized another field {Parts.Partnumber} works fine. But when I attempt to summarize the {Parts.ReportId} field I get the same value as the {Parts.Number} field. This is what I am looking for GH- Country Australia GH-CustNo...
  2. ABetha

    exporting report only to excel

    I am using Visual Studio 2005 with crystal reports 2008 I want to know can you export a report only to excel? I know that when you turn on the HasExportButton it gives you all available options to export the report is there a way to turn them off?
  3. ABetha

    declaring variable and concatinating two or more fields

    I have 6 fields that I want to contacinate if they are not null or empty. This is what I started off with. I am getting an error A string is required. Any help would be appreciated stringvar notes; notes = {qt_head.text_id_2}; if (not isnull({qt_head.text_id_3})) then notes =...
  4. ABetha

    page break by group

    I wanted to know how to do a page break by a group. Is this possible
  5. ABetha

    creating a parameter from a formula field

    I wanted to know if it was possible to create a parameter based on a formula
  6. ABetha

    crystal Viewer not refreshing

    I have a report that is viewed by supervisors There are 3 parameters on this report. technician name - which is a dropdownlist start date - text field end date - text field the supervisor selects a techicians name from a dropdownlist and enters in a start and end date to view report. The...
  7. ABetha

    evaluating formula

    I am trying to compare if the custNo and ItemNo in one table match the CustNo and ItemNo in another then I want to set the warrEnd1 to 12/31/1999 being out of warranty if isnull({vSerialNo.WarrEnd1}) or {vSerialNo.WarrEnd1} = date(0,0,0) or {vSerialNo.WarrEnd1} =DateTimeValue ("12/31/9999") or...
  8. ABetha

    flagging empty date fields

    I am trying to flag an empty date field and change the value to a default value this does not work if isnull({vserialNo.WarrEnd}) then datetimevalue("12/12/1999") else {vSerialNo.WarrEnd}
  9. ABetha

    formula not picking up chars

    if val({vSerialNo.Operation})< 0 then formula = 1 else formula = 0 end if My formula is not picking up special characters like '?' '!' etc its counting them as 0 when these are not valid and I am looking for it to return a 1 for these characters as well as numbers less than 0.
  10. ABetha

    nested if formula

    I am trying to summarized a nested if formula I am not getting the numbers that I am looking for. I believe that I am on the right track with this if {@outofWarranty} = 0 and {@DuplicateRep 2} = 0 and {@Hours } = 0 and {@visit} = 0 then 1 else 0 here are the contents of the following...
  11. ABetha

    changing the value of a formula field

    this is the formula I have if {@DuplicateRep 2} = 1 and {@Hours } >0 then {@Hours } = 0 else {@Hours } = 1 This is the contents of {@DuplicateRep 2} if {@DupSummary} = "dup" then formula = 1 else formula = 0 end if THis is the contents of the {@Hours } if...
  12. ABetha

    Supressing a field with formula

    I am trying to suppress a few fields if the subtotal values if there is only one entry therefore a subtotal would not be needed for that group. This is what I have {@ClaimedVisitSub} = val({@ClaimedVisit}) these formula contents are just summaries
  13. ABetha

    This field cannot be summarized

    My formula is called {@DuplicateRep 2} if not onfirstrecord and {vSerialNo.SerialNum} = previousvalue ({vSerialNo.SerialNum}) then formula= 1 else formula = 0 end if I am trying to sum my formula but it says that this field cannot be summarized. Any help would be appreciated

Part and Inventory Search

Back
Top