Cross tabs and Charts

[sdempsey]

I have created a cross tab based on the data held within a database table in the following structure.

ID
Population (1 or 2)
Step (0-5)

Sample data
1 2 0
1 2 1
1 1 3

So this identifier has at 1st population 1 person at step 3 and at population 1 patient at step 0 and another at 0.

When I create a chart only values for Step 0,1 and 3 are shown.

However I would like the following to occur on the graph:-

Population 1 (Green) 0-5 step
Population 2 (Blue) 0_5 step

Regarding if there is any data recorded for the step.

Is there a way to do this as I can only seem to get it if all the data is present.

I really want a static cross tab and only the values to updated dynamically.

Sarah

 

[sdempsey]

I have been trying this for a day or so. i am quite new to Cystal reports and just really used it to connect to a database and retrieve fields for the report.

I am currently using Version 10 and i am connected to a SQL Server database.

I have changed the way the above data is stored and it is in a table where each practice has 2 entries one for their 1st population and a 2nd for there 2nd population.

practice population step1 step2 step3 step4 step5

Entry one(67 ,1,0, 2,2,4,5)
Entry two(67 ,2,0, 12,12,4,5)

I would like the above to appear on a single chart with population1 one colour and the population2 another colour.

Each time I try to use the chart expert on the group axis I get 10 step produced. I would like 5 steps produced and 2 entries next to each step for each population

If anyone could point me in a starting direction that would be great.

Should i perhaps use the chart group option -- however this is not available.

 

[sdempsey]

I managed to solve this by changing the way the information is stored in the database.

Practice
Pop (1 or 2)
Score (0-5)
num (any number depending on how many people met the condition in the database)

So I end up with 12 rows in the database.

In Crystal report -- insert graph -- advanced

On changed of (Score and then pop)
Summary (Max of num)