Encerrado

Crystal Reports XI ( 11 ) chart / graph

Please send instructions on how to create Chart 1 and 2.

Issue Summary:

--------------

Chart 1 and 2 below rely on many Access 2002 queries.

I would like to simplify this and not re-do many of the queries we currently have by using a shortcut.

I am hoping to use 2 queries: One with many rows of: Site, MD, Patient - that match the criteria: White

And the other query with the same fields that show all patients.

Note: The most flexible solution would use similar data for both charts.

But chart 2 most likely will need a 3rd query, like Query 1, I am thinking with criteria: Black

Unless you had Query one with Type: Black or White but that would limit you to a patient only having one type.

I can use Visual Studio [url removed, login to view] and C# but don't want to use custom coding, just Crystal Reports and queries.

Question 1: What is the best way in Crystal Reports XI R2 to make Chart 1 from the 2 queries below or something close?

Question 2: What is the best way in Crystal Reports XI R2 to make Chart 2 from 2+ queries below or something close?

Example Query 1: All patients that match criteria: White

Site MD Patient

------------------

1 11 111

1 22 222

2 11 333

2 22 444

...

Example Query 2: All patients (notice extra rows)

Site MD Patient

------------------

1 11 111

1 22 222

1 33 333

2 11 444

2 22 555

3 11 666

...

Chart description:

------------------

There are many MD's per Site and many Patients per MD

To calculate the MD percentage, you count patients that match & divide by total # of that MD's patients.

To calculate the Site percentage, you count patients that match & divide by total # of that Sites patients.

To calculate All Sites percentage, you count patients that match & divide by total # of All Sites patients.

Chart 1:

|

|xxxxx

White |XXXXXXX

|0000000000

|

|__________________

0% 50% 100%

Legend:

------

MD = x

Site = X

Patient = 0

Chart 2:

|

|xxxxx

White |XXXXXXX

|0000000000

|

|xxxxxxxxxx

Black |XXXXXX

|00000000

|__________________

0% 50% 100%

Legend:

------

MD = x

Site = X

Patient = 0

Habilidades: .NET, Processamento de dados, Visual Basic, Área de trabalho do Windows

Ver mais: what is a graph, what graph to use for data, what graph, want to create a chart, use of graph, use graph, use a graph, the graph, make charts, make a graph chart, make a chart, how to make a chart, how to graph data, how to do reports, how to do basic coding, how to create graph, how to create a graph, how do you graph data, graph using c, graph to data, graph this data, graph the data, graph s, graph of data, graph in c

Acerca do Empregador:
( 1 comentário ) Brantford, Canada

ID do Projeto: #146041

7 freelancers estão ofertando em média $42 para este trabalho

MMaghawry

I can do this for you using any version of Crystal. And you will see my work.

$50 USD in 3 dias
(73 Comentários)
6.0
rajendra420

i can do it *Please Communicate before accepting the Bid , So that i can Schedule For the Project Best Regards, Rajendra Dewani About Me i am a Sr. Programmer ** 4 Years and 1 months of total experience Mais

$50 USD in 4 dias
(45 Comentários)
4.7
pros12

I work with this all day long. I can do it for you in a nmatter of a day.

$50 USD in 2 dias
(0 Comentários)
0.0
daniyal

we are expert of crystal reports all versions. we have done a lot of project on crystal reports. Give us a chance to work for you.

$45 USD in 2 dias
(0 Comentários)
0.0
rajshashi

I have done somany report in cystal report XI. So i am very confident for completing your report.

$40 USD in 2 dias
(0 Comentários)
0.0
sukhveer

we can do very [url removed, login to view] are expert of crystal reports all versions. we have done a lot of project on crystal reports.

$30 USD in 2 dias
(0 Comentários)
0.0
munendratyagi79

LOADS OF EXPEREINCE IN CRYSTAL REPORTS

$30 USD in 4 dias
(0 Comentários)
0.0