Search results for query: *

I have a table that captures patients that belong in a registry with a START_DATE field and an END_DATE field. I've added a Date range parameter {?Date Range} so I can run this report for whatever date range requested. I'm struggling to write a select statement that will include the patients...

I have a report where I am passing a shared variable that lives in the Group Header 1 in the subreport and trying to display in the Group Footer 1 of the Main Report. Not every subreport returns the value I'm passing so I get the value on the main report the first time it shows up for a...

I have a field in the Group Footer called Elapsed Time By Days. This field is calculated by a variable and is a number. I'm wanting to create a parameter that allows the user to select "0 ot 7 Days", "8 to 30 Days", and "31 to 90 Days" and then they would only see records with those values...

Group 1 Header Department Admit Time Detail line 1 Dept 1 8:00 Detail line 2 Dept 2 9:00 Detail line 3 Dept 3 10:00 Group 1 Footer Dept 1 (this is the value I want to see but if a do a Max or Min summary I keep getting either Dept 2 or Dept 3 because their...

I am trying to find a way to display a readmit date for patients that is less than 7 days from admit date. The fields I’m working with are {Discharge.Effective Time} and {Admit.Effective Time} . I also a group on {Patient.MRN}. Every thing I try keeps bringing up the same dates multiple times.

This is really convoluted: The field I'm trying to summarize is {@elapsed Time in OR} = tonumber(DateDiff("n",{@Reported In OR Time},{@Reported Out OR Time})) . {@Reported In OR Time} = if isnull(maximum({@Recorded In OR Time}, {OR_LOG.LOG_ID})) then {@x null datetime} //i.e. don't display...

If you schedule a report to run and to be sent to multiple email addresses, is there a way to see if any of the emails bounce back or are undeliverable?