CR XI - 3 Pie Charts using same fields 1

[fnpuff]

I have a working Pie Chart pulling data from 2 different places. I will do my best to explain below, but my question is, I would like 3 different pie charts using the same data but based on when the data is entered into our database (sql 05)

1st Pie chart is done: shows the total count of all programs based on region
2nd Pie Chart same data fields but entered into the database the last 7 days
3rd Pie Chart same data fields but entered in database in last month

Here is how I am getting the data for the first pie chart:
Data is: Regions.Name
Show value is: Group#1: Regions.Name – A:count of Region.Name (used a Insert Summary of region.name calculate using count)

I can get all the 3 pie charts using 3 different reports and using select expert but it would be nice to show them on one report if possible?

Oh, I am capturing when the data is entered: programs.dataentered

Also, if anyone can give me the names of good Crystal Reports books that would be great to.

 

[lbass]

Create two conditional formulas:

//{@inlastdays}:
if {programs.dataentered} in last7days then 1

//{@inlast30days}:
if {programs.dataentered}in Aged0To30Days then 1

Insert three report footer sections, and then insert three pie charts. Use {Regions.Name} as the group field, and then in one chart use {@inlast7days} as the show value field, and use {@inlast30days} in the second chart. For the last chart, use count of {report.name} as the summary field. You will need to decide what overall date range you want reflected in the last chart, and then use that in your record selection formula.

-LB

 

[fnpuff]

Thanks LB, that looks like it will work great. Any books you know of that explain simple syntax code?

 

[lbass]

The CR Help section is full of useful information, and along with posts in these fora, are probably the best resource for code. Also check out Ken Hamady's site (

http://www.kenhamady.com)

for tips and formula resources. He has a useful newsletter, too. In general, the George Peck books are good: "The Complete Reference: Crystal Reports (Version)."

-LB