Hi.

I am new to Crystal Reports. I need to create a report that will look similar to this:

               Mon    Tues   Wed   Thur   Fri   Sat
Activities      1242    321   333   5453   653   2121

Where the activites are fields in a database. All of the activities done on the Monday need to be added up to give me the total of 1242, and so on for Tues, Wed, etc.

The user enters in the start date, which will always start on Monday, and the end date will then be Sunday.

I am using the following:

if DayofWeek({@Weekstart}) = 2 then
Sum({Table.Activity})
else 0

Where weekstart is the Monday that the user selected. Now, even when I put in the formula for Tuesday:

if DayofWeek(Dateadd("d",1,{@Weekstart})) = 3 then
Sum({Table.Activity})
else 0

I get the same result. What can i do to get the correct vlues for all the days?

I cant use a crosstab, because I need to add several rows after activity, I am looking for lots of information here. Already tried a crosstab, but it did not work.

any other suggestion on how to do this? Without using a crosstab?