Summary Count by Month is nice, but weekly?

building reports crystal reports
1

Hello
I use CRXI but I am at the beginner level.

Count({record.ID},{record.date_created},"monthly")

works great for a chart I have.
My problem is trying to chart based on week using a summary count. The graph has Date Created on the X, record counts on the Y
I’ve tried the ‘insert summary’ options but was not having success, which is why I switched to the above simple formula and use the chart in report footer.

Thanks in advance

Haexphane :us: (BOB member since 2006-05-05)

2

Hi,
If you right click the graph and go for chart expert and then go to the data tab, select the date field you’re using (at the top) and then click the order button and then change the bottom drop down menu from monthly to weekly (or any other of the pre-defined date groupings) this will give you a weekly view of the graph.
Andy.

andyherm :uk: (BOB member since 2008-09-26)

3

Thanks for the reply. That is not the problem I am having, I will try to explain it better.

I created the summary count formula because I am actually doing 2 counts

Count({record.ID},{record.date_created},"monthly") 
 Count({record.ID},{record.date_closed},"monthly")

and displaying them both on the graph.

I want to just show the Months of 09, and display the number created and the number closed for each month. When I tried using the default summary/count in the graph tool I did not get good results. I switched to using the “summary count” manually created formula and it worked perfectly, however it only works “Monthly”

I can create 2 graphs. Distinct count, default chart option for “weekly” and 1 graph for count records / date created another graph for count records / date closed. When I attempt to graph together it does not work because Date Created / Date Closed can not both be on the X axis?
The result is a jumble of “Date Created and Date Closed” as the X label, and then it puts 1 set ot dates in the legend and color codes (bar graph)

Can I create something for the X axis that will workaround this issue?

Haexphane :us: (BOB member since 2006-05-05)

4

Hi,

I hope this will help. After you define the record ID count by month created and month closed, define a parameter that will call the orderdate. This will be the basis of your filtering if you want to view certain month of specific year or by year.

after you define the parameter go to Reports then Formula Workshop then choose Selection Formulas then Record Selection then enter this value:

whilereadingrecords;
monthname(month({Orders.OrderDate}))= monthname(month({?My Parameter}))

After you define the filtering create a bar graph. under Data choose Order Date field under the first selection then set the Order to weekly.

For the Show Values choose the define formula you created which is

Count({record.ID},{record.date_created},"monthly") 
Count({record.ID},{record.date_closed},"monthly")

then try to run the report

nahtanoj :philippines: (BOB member since 2009-07-08)