Chart Difficulty, YTD,MTD

[nerdlinger]

Need some expert guidance on how to accomplish creating a chart.
What I have is a field with the possiblity of holding any one of 15 values. This will be a sub-report linked to the main report by accountno. No problem there. The main report is a monthly report. What I need to do is chart the Year-To-date Vals and the Month-To-Date vals in a simple old bar chart. Any suggestions?

 

[kenhamady]

Well your main problem is that you can't chart number coming back from a subreport.

Othewise, what does a bar in the chart represent?
Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[nerdlinger]

Ken,
The bars will represent the answers to the question. there are 15 possible answers.
So for example: Only 3 questions for brevity)
Q: what attracted you to our store? There were 10 responses
---For the current Year-To-Date(Less Current Month)---
A: 30 said "Location"
A: 30 said "Selection"
A: 40 said "Pricing"
------------------------------------------------------

---For the current Month-To-Date----------------------
A: 10 said "Location"
A: 10 said "Selection"
A: 20 said "Pricing"
------------------------------------------------------
So I want the left bar to be YTD and the Right Bar to Be MTD For each Question

Thanks--You have been a big help with the questions I have posted thus far--hn

 

[kenhamady]

Can you get all of the YTD records in one report without the subreport? You can use conditional totals to separate YTD and MTD within the report, and advanced charts to give 2 bars per Qx. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[nerdlinger]

Ken,
We can do this...So what I would do is select all for the account number in YTD...where and how do I put the MTD conditional statement...in a group?

thanks

 

[kenhamady]

Group your report so that you can get one chart (2 bars) per group. Now create a total of the YTD, and create the following formula for the MTD:

If {date} in MonthToDate
then 1
else 0


Sum this for each group and you have your MTD total.

Now do an advanced chart that uses these two subtotals as the "SHOW" fields. Each will be a bar. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[nerdlinger]

thanks--hn