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: crdamsel
  • Order by date
  1. crdamsel

    GENERATE AUTOMATIC DATE

    vb works with chrome and firefox as well as i.e.
  2. crdamsel

    GENERATE AUTOMATIC DATE

    ACTUALLY VB DOES WORK IN OTHER BROWSERS BESIDES INTERNET EXPLORER APPRECIATE YOUR RESPONSE.
  3. crdamsel

    GENERATE AUTOMATIC DATE

    CAN SOMEONE HELP ME CREATE A DATE FIELD IN A WEB PAGE THAT AUTOMATICALLY UPDATES EVERY 2 WEEKS? FOR INSTANCE, WHEN THE WEB PAGE IS ACCESSED, IT WILL SHOW WHAT WAS THE ORIGINAL DATE OF 08/12/2016 (NOT NECESSARILY IN THIS FORMAT) TO BE 08/26/2016 BUT ON OR AFTER 08/26/2016, THE DATE CHANGES TO...
  4. crdamsel

    COMPARE SUBREPORTS

    briangriffin APPRECIATE YOUR IMMEDIATE REPLY BUT I NEED TO COMPARE THE DATA IN EACH SUBREPORT WITHIN THE CRYSTAL REPORT WHICH WILL THEN GIVE ME A REPORT OF THE DATA THAT MATCHES AND A REPORT OF THE DATA THAT DOES NOT MATCH. ANYWAY, THANKS AGAIN FOR YOUR SUGGESTION.
  5. crdamsel

    COMPARE SUBREPORTS

    HELLO FELLOW CRYSTAL REPORTS PROGRAMMERS. DOES ANYONE KNOW HOW TO COMPARE DATA IN ONE SUBREPORT TO ANOTHER ONE? FOR INSTANCE, CHECK TO SEE IF A LINE OF DATA IS IN ONE SUBREPORT AND IF A LINE OF DATA IS IN ANOTHER SUBREPORT AND VICE VERSA? ANY HELP OR SUGGESTIONS WOULD BE VERY MUCH APPRECIATED.
  6. crdamsel

    Connect CF to MS Access Code

    Appreciate the immediate reply. This link is very helpful. Thank you.
  7. crdamsel

    Connect CF to MS Access Code

    Does anyone know the ColdFusion code to connect to an MS Access database on another server?
  8. crdamsel

    SUPPRESS TEXT OBJECT

    MADE ANOTHER MISTAKE BUT LAST TIME. ANYWAY, THE CORRECT CODE IS BELOW. if ({?Code} = "F" and {?Product} = "T35") then SUPPRESS else if ({?Code} = "F" and {?Product} <> "T35") then SUPPRESS else if ({?Code} <> "F" and {?Product} = "T35") then DO NOT SUPPRESS else if (?Code} <> "F" and {?Product}...
  9. crdamsel

    SUPPRESS TEXT OBJECT

    I WAS WRONG. THE 2 LINES OF CODE THAT I GAVE DO NOT SUPPRESS PROPERLY IF {?Product} <> "T35" AND {?Code} <> "F" HOWEVER THE CODE BELOW WORKS GREAT. THANKS AGAIN EVERYBODY FOR ALL YOUR HELP. if ({?Code} = "F" and {?Product} = "T35") then SUPPRESS else if ({?Code} = "F" and {?Product} <> "T35")...
  10. crdamsel

    SUPPRESS TEXT OBJECT

    THIS THREAD IS CLOSED. THANKS TO THE TIPS FROM ALL OF YOU WAS ABLE TO JUST USE THE CODE BELOW TO SUPPRESS MY TEXT OBJECT WHEN IT NEEDED OR DID NOT NEED TO BE SUPPRESSED. if {?Product} = "T35" then FALSE; if {?Code} = "F" then TRUE;
  11. crdamsel

    SUPPRESS TEXT OBJECT

    APOLOGIZE FOR NOT BEING CLEAR. HOWEVER IN ANSWER TO pmax9999: 1. {?Code} = "F" and {?Product} = "T35" *** SUPPRESS TEXT OBJECT BECAUSE {?Code} = "F" 2. {?Code} = "F" and {?Product} <> "T35" *** SUPPRESS TEXT OBJECT BECAUSE {?Code} = "F" 3. {?Code} <> "F" and {?Product} = "T35" *** DO NOT...
  12. crdamsel

    SUPPRESS TEXT OBJECT

    EXCELLENT SUGGESTION HOWEVER I NEED TO BE MORE SPECIFIC. IF {?Code} = "F" THEN THE TEXT OBJECT IS SUPPRESSED REGARDLESS IF Product} = "T35" BUT IF {?Code} <> "F" AND Product} = "T35" THEN THE TEXT OBJECT SHOULD NOT BE SUPPRESSED.
  13. crdamsel

    SUPPRESS TEXT OBJECT

    THANKS SO MUCH FOR YOUR PROMPT RESPONSE. THE {?Code} = "F" IS A GREAT IDEA HOWEVER I NEED TO NOT SUPPRESS THE TEXT OBJECT IF {?Product} = "T35". SOMETIMES BOTH PARAMETERS ARE {?Product} = "T35" AND {?Code} = "F" AT THE SAME TIME.
  14. crdamsel

    SUPPRESS TEXT OBJECT

    NEED TO SUPPRESS A TEXT OBJECT DEPENDING ON 2 PARAMETER FIELDS. IF {?Product} = "T35" THEN DO NOT SUPPRESS BUT IF {?Code} = "F" THEN SUPPRESS. TRIED USING THE FORMULA BELOW IN FORMAT EDITOR CLICKING THE X-2 BUTTON LEAVING THE SUPPRESS CHECKBOX UNCHECKED IN THE COMMON TAB BUT WILL NOT WORK IF...
  15. crdamsel

    CR Group Footer Date Format Problem

    Appreciate your immediate reply. I am using CR 2011 however it only does it if i use the Group Name Field in the Group Footer but when i used a Database Field in the Group Footer, the date format did not change so i was able to solve my problem. Still, thanks again for your response. This thread...
  16. crdamsel

    CR Group Footer Date Format Problem

    Have a problem with the data format in a Group Footer. The date is supposed to be YYY-MM-DD in the Group Footer total but when it is the first line in a next page, it changes to M/DD/YYY as shown below: HEADING PH ======= ----------------------- GF1 Total for 6/30/2004 GH Example...
  17. crdamsel

    Merge Detail Lines in CR Report

    This thread is closed. Have over 1M records so solved this with a Cross-Tab report. Thanks again for all your help.
  18. crdamsel

    Merge Detail Lines in CR Report

    kray4660, the only reason your formula didn't work was because I'm now using the GF for yearly calculations so I need the Detail to show all the records which some columns have more than one record. Should have said that each column is really a monthly column so I have 12 columns for each month...
  19. crdamsel

    Merge Detail Lines in CR Report

    Appreciate your help but think i didn't make myself clear. I need the records in the report to all be in the same line but in their own columns: From This: GH (suppressed) (Column1)(Column2)(Column3)(Column4)(Column5) D XX:123 D ........ ZZ:345 D ................. YY:567 D...
  20. crdamsel

    Merge Detail Lines in CR Report

    Still no luck with this so if anyone can help me, i'd really appreciate. The fields can be referenced as {col1}, {col2}, {col3}, etc. and they are all VarChar.

Part and Inventory Search

Back
Top