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: graph use data, what graph, want create chart, use graph, the graph, make charts, make graph chart, make chart, basic coding, graph using, graph s, graph data type, graph coding, graph c, for graph, description graph, create graph, c graph, can graph, a graph, visual net chart crystal, crystal reports chart percentage, crystal charts, crystal queries graph, crystal reports graphs

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 easy.we 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