Solved

VISUAL BASIC .NET and DYNAMIC CRYSTAL REPORTS

Posted on 2008-10-09
9
149 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A basic question.. “What is the Garbage Collector?” The usual answer given back: “Garbage collector is a background thread run by the CLR for freeing up the memory space used by the objects which are no longer used by the program.” I wondered …
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

758 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

20 Experts available now in Live!

Get 1:1 Help Now