formula problem

[Former Member]

I am using Crystal XI and an Oracle database. I have a treatment plan report that shows whenever staff electronically sign it, including the date and their title, etc. We collect information in the database (start and end dates for staff assigned to a patient) to show dates they were assigned to a patient for care. Right now the report shows every staff person who ever signed it. I need to narrow it down to show only current staff assigned to that patient and/or be able to input a date with a parameter and show staff who were assigned as of that date. I have tried many variations of formulas to display the correct signatures, but haven't been successfull. However, I did build a subreport that is successfully telling me current staff assigned.

[kyle_mcadam · Accepted solution]

Jerri,

It would be nice to know more about the table structure that you have available to you, but from the sounds of it, you can use the table/set of tables that you are using to get the current assigned Staff id, and link that/them to the main reports' table by the Staff id. This will automatically filter out all the staff that are not 'currently assigned'

[Former Member · Accepted solution]

The signature piece is a subreport and the assigned staff is a separate subreport. I am new to this forum -- is it possible for me to e-mail you my report so you could see how I have it setup? I have spent a lot of time trying to figure this out on my own.

[Former Member]

Jerri,

As far as the record selection goes, you have several options. You just have to decide what you actually need.

You can filter based on a date parameter.

You can filter based on currently assigned staff... I'll assume that currently assigned staff have a null in the EndDate field. You cant select based onthat value being null.

You can even do both...

As far as the signature part of the problem, that will boil down to a table linking issue. If you would like to provide a sample of your table structure, it should be pretty easy to hammer out.

Jason