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 gkittelson 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: *

  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