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 bkrike 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 Khelben

  1. Khelben

    Sorting Groups - Problem with non-distinct values

    I still haven't heard a satifactory solution to this problem. Crystal 8 is out now...maybe it can do it, but I wouldn't know.
  2. Khelben

    Sorting Groups - Problem with non-distinct values

    I'm afraid I may have oversimplified my example.&nbsp;&nbsp;I'm trying to explain what I need without including all of the irrelevant details of my particlular report and I probably haven't provided an accurate representation.<br><br>Let me explain further.&nbsp;&nbsp;The grouping is, in fact...
  3. Khelben

    Sorting Groups - Problem with non-distinct values

    I have a problem with sorting and grouping.&nbsp;&nbsp;I have a report with a group defined.&nbsp;&nbsp;Consider that there are two different fields I would like to sort by.&nbsp;&nbsp;One is a unique text string, lets call it &quot;Name.&quot;&nbsp;&nbsp;The other is not unique and is a number...
  4. Khelben

    NULL Problem (Need a Zero when database is empty)!

    Sweet.&nbsp;&nbsp;I haven't tested that yet, but if it works it's as good a solution as the next.&nbsp;&nbsp;I didn't know you could provide the &quot;evaluateafter&quot; statement with a parameter like that.<br><br>Thanks for the excellent idea.
  5. Khelben

    NULL Problem (Need a Zero when database is empty)!

    The suppression doesn't recognize the &quot;RecordCount&quot; variable that you refer to (I get &quot;The remaining text does not appear to be part of the formula&quot; and similar error messages)...this doesn't appear to be defined.&nbsp;&nbsp;I cannot find any special &quot;RecordCount&quot...
  6. Khelben

    NULL Problem (Need a Zero when database is empty)!

    Basically, yes.&nbsp;&nbsp;Here's the situation using two formulas:<br><br>--- FORMULA1 ---<br>BeforeReadingRecords;<br>0;<br><br>--- FORMULA2 ---<br>WhileReadingRecords;<br>Count({MyField});<br><br>First, notice that the evaluation-time statements are now completely unnecessary (they are only...
  7. Khelben

    NULL Problem (Need a Zero when database is empty)!

    Good suggestion.&nbsp;&nbsp;However, I tried that, too.&nbsp;&nbsp;For it to work, I'd need something like this:<br><br>BeforeReadingRecords;<br>0;<br>WhileReadingRecords;<br>Count({MyField});<br><br>And this doesn't appear to work...I suspect you can only use one of the 'evaluation time...
  8. Khelben

    NULL Problem (Need a Zero when database is empty)!

    Thanks for the suggestion Malcolm, but is there some special RecordCount function/param available that I don't know about?&nbsp;&nbsp;I've looked through the help, but I don't see anything that does that...but then, I'm new to it.<br><br>My problem seems to be that I can't get the record count...
  9. Khelben

    NULL Problem (Need a Zero when database is empty)!

    I have a Running Total defined that counts distinctively the number of items in a certain field.&nbsp;&nbsp;This works fine when there are records in the database (I'm using a simple .MDB file).&nbsp;&nbsp;When there are no records, it displays nothing, but what I need is for it to display a...

Part and Inventory Search

Back
Top