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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DoPLeGaNgA

  1. DoPLeGaNgA

    allign records when using section suppression in details

    Hello: I'm using CRXI with a SQL DB. Is there a way to make a field associated with a suppressed record appear with other records in a detail section that are not being suppressed? For example: There is a group in the report that is a code for a specifc record and there is a date field that...
  2. DoPLeGaNgA

    Select Expert Formula Based on Current Year

    Thank you lbass I'll give that a try.
  3. DoPLeGaNgA

    Select Expert Formula Based on Current Year

    Thank you all for your quick response. lbass thank you for your suggestion, but when I use a record selection formula I get a crystal error that states this must be evaluated after and when I try using the SQL Expression i get a sql error. I'll keep trying. Any other thoughts would be helpful.
  4. DoPLeGaNgA

    Select Expert Formula Based on Current Year

    Hello: Using CR10, I'm trying to select records in a report using a formula that returns records for providers that have not had a specific screening during that year. This is the formula I'm using: year(CurrentDate)<>Year({checkupdate}) The problem is there are records selected from the...
  5. DoPLeGaNgA

    Section suppression formula to exlude a PH if a subreport is in RF

    Hello: Is there a way I can suppress a page header section of a report if there is a subreport in the report footer of the the report? I've manually created a cross-tab that has header info in the Page Header E section and I've created a subreport with detail in the Report Footer b section...
  6. DoPLeGaNgA

    section suppression formula

    Thank you all for your help. I'll give this a try.
  7. DoPLeGaNgA

    section suppression formula

    Hi, I'm using CR10 and I'm wondering if it is possible to suppress a section in a report if a subreport in another section is blank. Is this possible, and if so what would be the correct syntax?
  8. DoPLeGaNgA

    If Then Else Function

    How do I represent a Date Field as a null or blank value in a formula when using an if then else function. I'm using two date fields in a report and if one is null or blank I want to use the other.

Part and Inventory Search

Back
Top