Hi reader,

I'm very new to reporting (and using CRXI) yet I'm immediatly thrown in the middle of a crucial reporting-stage. We have NO experts. So I am alone...

I'll show you the screeny of my current report and then I'll ask my questions.



My questions in order of importance (using crystal formula notation):
1) (**crucial**) : A customer (like Anthony) has 4 or more "test" in the "Action" field. I want to count the number of customers with 4 (or more) "call".
This needs to be a formula (or something) because I'll add that result in the report-footer.

2) (very high, not crucial) : Do I have to group it like this? I just need the formula-oject (or running total field!) to insert it in the report-footer. I may want to choose to setup the report in a different way.
Yet I do need the summary as mentioned in "1".

3) (moderate) : What if I want to summarize per user how many "call" he/she got?
Like:

NAME | CALLs | TESTs
Antho. | 1 | 4
Carla. | 3 | 2

Etc.
Like I mentioned, this is a crucial state of the reporting process. Once I get through this, I can handle the rest of the report most likely!


Edited by Valmont - 29 Jan 2007 at 11:33am

[quote] 1) Can you use a global variable and only increment it when the record has "call" in it?[/qoute]

Not skillwise. That's why I am here.
For the sake of consistancy with the report, I need a formula and then drag the formula to the reportfooter. Question is that I only can make very basic formula's.

Thank you for the reply by the way. This project important.

Thank you for your time but that is not what I meant. I could have been clearer.

Say a database has a record of 2 tables: Customer, Action.
Say we have 10 customers. Say we have 2 types of actions (AOne and ATwo).

Say customer "John" can have up to 50 actions. I am only interested if John has at least 4 times action "AOne". If he has then "CustomerActionOne_4Count" = 1.

Mary has at least 4 times action "AOne" as well!
So my variable becomes:
"CustomerActionOne_4Count" = 2.

That's because 2 customers have at least 4 x performed a certain action.
I don't care who they are, all I want to know how many users have that amount of that specific action.

Now the tricks is that this has to be a formula that does not depend on what is to be seen on the report:  I may not want to display any field of any table in the report. I just want to put formulas in the report. And this very formula is the most important one.

So the formula gets complex alright. Once again I totally used up my spare time. (1.05 am here). I'll try until I drop down from tireness but without help I'm lost.



Edited by Valmont - 30 Jan 2007 at 4:14pm

Jolly awesome! This looks promising!

Thank you. Deadline tomorrow (my time, it's evening here now).
It's funny to see how a certain skillset with Crystal Reports has direct influence on attracting more customers sometimes. This is one of these times. Tomorrow afternoon the potential customers comes to see if we can report decently!

That's the story behind this CR project :)

Once again, thank you all for your help.