• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 172
  • Last Modified:

VISUAL BASIC .NET and DYNAMIC CRYSTAL REPORTS

I have created a CRYSTAL REPORT that runs from a VISUAL BASIC console apllication. The report has a pie chart in it that displays how many merchants sell a producers wine in five different countries. It works perfetly. Now there has been a new twist added to the report. The producers are now given the choice of choosing from 1 to 5 different countries.  Is there a way to programmatically change the fields displayed in the pie chart or will I have to create five different reports for each of the five possiblle pie charts?
0
acsakany
Asked:
acsakany
  • 5
  • 4
1 Solution
 
mlmccCommented:
Is this when you run the report?
They choose 5 countries as a parameter?
If so simply add a filter through the select expert like
{YourCountryField} IN {?CountryParameter}

mlmcc
0
 
acsakanyAuthor Commented:
The countries are chosen and then the report is run. The problem being that there used to always be be only 5 countries. So the pie chart ws setup to display five SHOW VALUES. Now the pie chart needs to be dynamic. There can now be one to 5 SHOW VALUES.
0
 
mlmccCommented:
How is the pie chart setup?

It should be simply based on 2 fields
Country
Sum(SalesField)

mlmcc
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
acsakanyAuthor Commented:
The report used to be

WINE: Chateau Haut Simard
---------------------------------

COUNTRY              MERCHANTS
------------              ----------------
France                        30
United States              20
Italy                             20
Germany                     20
Canada                       10

This data would be displayed in a pie chart. Now they can choose 1 to 5 of these countries so I need to dynamically create a pie chart. Is it possible? Is the a CRYSTAL REPORTS SDK?
0
 
mlmccCommented:
You should be able to build the pie chart as

Insert a chart
Right Click the chart
Click CHART EXPERT
Click the DATA tab
Click the ADVANCED button
On Change of - Country
Show Values - Merchants (either sum or count)

mlmcc
0
 
acsakanyAuthor Commented:
yes I understand the concept of adding SHOW VALUES. The problem being that the number of SHOW VALUES will change depending on how many the user chooses. Is there a way to dynnamically change the number of SHOW VALUES?
0
 
mlmccCommented:
What does the database look like?
Apparently it is not just

Country  Merchant

mlmcc
0
 
acsakanyAuthor Commented:
I just got a phone call. Plans cancelled. Five countries only.
0
 
mlmccCommented:
What are the chances they will again change thier minds?

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now