Crystal Reports - how to create a chart from link variables? 2

[dadazs]

Hi Tek Tips

I am working on KPI project.

In general, i link shared variables into main report to do formulas & calculations and it works fine.

Howeve,r I cannot create any charts with those variables.
What can I do about it?

Crystal Reports 11 & using basic

many thanks

 

[lbass]

You would need to use the technique explained in "Charting on Print-time Formulas":

http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/40e7130d-aa1e-2b10-ce9f-eee2a54ff4cd

-LB

 

[dadazs]

thanks for the link. it is really helpfull. however, i still have issues.

plz see below

Formula Details

{KPI - sites - number} DistinctCount ( {CONTACT1.COMPANY}, {CONTACT1.KEY3} ) / {@total sites} *100

{total sites} Shared NumberVar totalSites;

{Total Sites} WhilePrintingRecords;
Shared NumberVar totalSites;
totalSites := DistinctCount ({JRClientsOnly_.JR}, {JRClientsOnly_.KEY3});


My problems: 1. I still cannot get grahps
2. Is it any other way to find out e.g. Calculation below
I need to find out
-total sites each manager has (table 1) &
-how many sites have history (table 2) and
-compare to sales (table 3) to count of sites in total & sites with history ( table2 and table3)
Table1
John 10
Tom 5
Andy 35
Brian 3
Lee 57

Table2
John
Tom



Few sites have history only

 

[lbass]

What is the rationale for using subreports? Why not just link the tables and then work with them in the main report?

-LB

 

[dadazs]

main reports & its select expert -

{CASES.RESOLVED_DATE} <= {?Resolve Date} and
{CASES.CREATED_DATE} >= {?Start Date:} and
{CASES.FTYPE} startswith "CAF" and
{ACODETLS_SALES.U_TRNDAT} in {?Start Date:} to {?Resolve Date}

what it does:
1. Select a period / quater for different tables.
2. Select specific records startswith "CAF" and
2.1 When specific records are selected I do not get TOTAL contracts per managers. I do get contracts with "CAF".
2.2 I use sub report to get TOTAL Records

 

[dgillz]

1) Get rid of the line in the selection formula that reads "{CASES.FTYPE} startswith "CAF" and". This will of course, return all records, so your total records will be right.

2) Your other formulas will be wrong. Thats OK. Group by {CASES.FTYPE}, then do a group selection formula for {CASES.FTYPE}="CAF". This will make the group work perfectly, and your total records should still be good, as they are still there, just not shown due to the group suppression formula.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dadazs]

Thanks for the tip - I can get totals now & it display just the right sites.

however, i cannot figure out how to calculate displayed contracts