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!

Register Log in
  • 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. jadzian

    DistinctCount Problem

    None of this resolves above is correctly. Previous I explain why uour first formula can't calculate good result, now I understand why Reebo's formula is wrong. You use DistinctCount, not Count, so I recognize You join two tables, due to some of {pers_id} are dupplicated. If You use formula if...
  2. jadzian

    DistinctCount Problem

    Could You send mi this report. My e-mail: jadwiga.nowak@acn.waw.pl Jadwiga.
  3. jadzian

    DistinctCount Problem

    I gess what is wrong. You use formula : If Not({mgt level} = 'M') then {pers_id) This formula gives you sometimes {pers_id} sometimes null. DistinctCount counts this Null as 22nd employe. On the other hands, I don't understand why formula If Not({mgt level} = 'M') then 1 else 0 gives You...
  4. jadzian

    Duplicate Detail rows

    No, there isn't. You have to make group, and place all needed fields from details in group header or footer, then suppress details section. Jadwiga.
  5. jadzian

    Record counting

    I think, You should use typiacal Crystal's function "count". When there are no records function "count" displayed blank filed but not number "1". Jadwiga.
  6. jadzian

    Problem with subtotals of 1 to many table relationship

    You are right, where is simple solution. I suggest use Running Total Field. This is one of basic field that you can find in menu Inser->Fields.

Part and Inventory Search

Back
Top