Can this be done...

[Jacob438]

I currently have a report set up something like this:

Bugs found per week
Bugs found per day
Which user found bugs each day

as you can see, the first group is a group per week, the second is a group per day, and the third is a userID. How to I add this to the end...

Totals for each user per week

I can't put it in the footer of the week group, because it only runs once, so it'll only show one user. I am new to crystal and need a way to do this. I've been thinking about this for way too long and I'm sure it's easier than I'm making it. Thanks in advance,

Jacob438

 

[synapsevampire]

Since what you ask doesn't fit well with the grouping described, you might just add a crosstab into the report footer to handle this.

Fairly straight forward, you shouldn't have any troubles with it.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Jacob438]

Thanks for the quick reply!

yeah, that's what I was looking at just now... the crosstab. See, the thing is, the crosstab has no problems knowing what data I want, I was able to simply create a cross tab with the exact data I wanted, but I don't like the look of the crosstab. Are there any other ideas? I don't like how rigid the formatting is on the crosstab thing. But I know I can get the data I want since the crosstab can get it, how can I do this manually?

thanks in advance,

picky Jacob438

 

[Jacob438]

actually... how about this...

Bugs found per week
Bugs found per day
Which user found bugs each day

Then add..
Totals for each user for whole reporting period
(since this report could be ran across multiple weeks)

Is there a convenient way to keep track of a running total and then at the end of the report list each user along with how many they found over the reporting period?

Or would this be better done using a subreport which only did that and shared the same date parameters as the other report?

Thanks,

Jacob438