Solved

VISUAL BASIC .NET and DYNAMIC CRYSTAL REPORTS

Posted on 2008-10-09
9
150 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
  • 5
  • 4
9 Comments
 
LVL 100

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 100

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
 

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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 100

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 100

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 100

Expert Comment

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

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

Suggested Solutions

IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

867 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

22 Experts available now in Live!

Get 1:1 Help Now