Solved

Help with designing crystal reports charts

Posted on 2009-05-09
7
249 Views
Last Modified: 2013-11-15
Hi There,

I am totally new to crystal reports.
I am looking to create charts.  The first will show level of quotes by company.
The second should show quotes by month
The third should show total values for ordered,  lost & pending.

On the first chart if you click on a company name, the other 2 charts data should reflect that companies data - (No clicking should show all companies combined.

I have tried doing a sub report and linking fields by company name but it only ever shows the first companies data.  If I click on the other companies bars it does nothing.

If I go to design view of the subreport and select refresh - hear it allows me to type the company name and only then will it display the data.

Can anyone help me with this please
0
Comment
Question by:mco32
  • 3
  • 2
7 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 24343735
I don't think you can make a chart clickable in that way.

What verion of Crystal?

mlmcc
0
 

Author Comment

by:mco32
ID: 24343755
8.0.1.0

Any way round it?  Just do separate graphs and feed in parameters?

Do even know if this can be done - totally new to this about 3 days now :-(
0
 
LVL 6

Assisted Solution

by:Dan3D
Dan3D earned 250 total points
ID: 24356534
I don't think Crystal would work like this, particularly an old version like CR 8.0x.

-Dan
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:mco32
ID: 24357571
do you know of any software that would do this?
Or would it have to be done through programming?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24357690
I don't know of any

mlmcc
0
 

Author Comment

by:mco32
ID: 24358493
Thanks mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now