I am on cyrystal report 8.5, active

[khan007]

I am on cyrystal report 8.5, active X viewer, win 2k.

I have a problem in cross tab report.

I have "time" in Row and "physician name" in Column and patientsname in "Summarized field".

I can have 50 physician a day.
Each physician consult patients after 15 minutes span
and a physician can have multiple patients at one time.

My desireable output is:

PHY_1 PHY_2 PHY_3 PHY_4
6:00 am abc ttt www jjj
6:15 am sss hhh qqq kkk
6:30 am eee nnn aaa lll
6:45 am rrr mmm bbb iii
7:00 am zzz ccc ooo mmm
fdf
7:15 am cvb fdc hjh ghg
7:30 am gfv ggg ggg ggg
fff
hhh
7:45 am ghg ggh bbb gfv
yyy
8:00 am gfv rtr rpr trt

...... to 8:00 PM

I am almost done with everything except unable to resolve one.
if we have more than one patient at one time for a specific poovider, I am unable to place them. If I add another row of patient name then it gives me as many rows for a time as # of patients.
Please help me in this regard.

 

[synapsevampire]

It seems to be showing multiple patients for each provider now???

-k

 

[khan007]

That's what I am saying, It's my desireable output but i am not getting it. I am getting as many number of rows as many patients, if I add another row as patient name after first row date.
If I don't and summarized as maximum (patient name) then i am getting only one.

Thanks in advance

 

[lbass]

If you mean you are getting spaces for three patients in each cell (at 6 a.m. in your example as well as for 7:30 a.m.), I don't think there's a way around that unless you redesign your crosstab as a manual crosstab. Then you could format the detail section to suppress if blank or organize the detail fields horizontally, instead of vertically.

Or are you not sure how to get the additional names per doctor per time slot? If so, I would just insert the patient name field as many times as equals the maximum count of patients per time, and then use Nth Smallest, increasing the value of N for each additional name. This way they'll present in alphabetical order within the cell.

-LB