Crystal Reports - any programmers on here?

JeffSturgeon2002

Board Regular
Joined
Dec 28, 2004
Messages
50
I have always received quick fast answers to any problem in excel I have. I am currently trying to program Crystal Reports to do specific things and need some help.

I need assistance with a physicians appointment schedule. In the database, it is set to "overbook" appointmets - meaning 4 patient slots for every time slot. For examle, Patient A, Patient B, Patient C and Patient D can all be added to 8:00 am time slot to see the MD.

I have a form created much like a grid and would like the system to plug in the corresponding names to the report. When I drag the fields over now, I get the same patient 4 times across. I need a way to distinctly identify each and populate it accordingly. Second issue is, how can I make the crystal report identify and plug into the right time slot? Not all patients are at 8:00 am assuming I can get it over in distinct placements.

Is it possible to do this?
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,141,154
Messages
5,704,612
Members
421,359
Latest member
Edwardvanschothorst

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top