Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

VISUAL BASIC .NET and DYNAMIC CRYSTAL REPORTS

Posted on 2008-10-09
9
Medium Priority
?
161 Views
Last Modified: 2013-11-26
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
Comment
Question by:acsakany
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 22679019
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
 

Author Comment

by:acsakany
ID: 22679096
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 22679418
How is the pie chart setup?

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

mlmcc
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

Author Comment

by:acsakany
ID: 22679491
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 22679863
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
 

Author Comment

by:acsakany
ID: 22679900
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 22679975
What does the database look like?
Apparently it is not just

Country  Merchant

mlmcc
0
 

Accepted Solution

by:
acsakany earned 0 total points
ID: 22679998
I just got a phone call. Plans cancelled. Five countries only.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 22680022
What are the chances they will again change thier minds?

mlmcc
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

604 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