what's wrong with summary distinct count on formula in Crosstab

[fancyface]

Hi all. I'm using Crystal 7 - yes go ahead make fun of me. I know.... we're upgrading soon.

In my crosstab I have a column on date to group monthly. I only want to show the number of donations and the number of donors per month. I don't really want any row grouping. But on the number of donations in this particular crosstab I only want to show donations where prog <> "a" and type <> "p". So because I can't use a running total in a crosstab, on my details, I created a formula that says donations where prog <> "a" and type <> "p", created a distinct count summary function and used that as a summarized field in my crosstab. However, it's still counting ALL records, not just where prog <> "a" and type <> "p".

 

[lbass]

Please show the actual content of your formula.

-LB

 

[Madawc]

I think you need a formula field containing something like

if prog <> "a" and type <> "p" then 1 else 0

Then do a summary total of that. It would work in Crystal 8.5, at least.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10