Search results for query: *

Default date is only for the End_Date. If I'm running the report for the Date Range 11/1/16 to 11/30/16, I want to capture all patients that their START_DATE and END_DATE fall within that range.

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...

You rock. Reseting the variable in the subreport Report header worked. Thank you.

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...

We have to do this with a copy of the original ADT table. ADT_TABLE(FIRST_ENCOUNTER) link to copy of ADT_TABLE(FUTURE_ENCOUNTERS), link by the PAT_ID (a unique id that is in both tables that is specific to the patient but will not limit by encounter)

The only time I've used shared variables is when I'm trying to pass a variable from a subreport to a main report.

I stay away from using the running totals because they don't work when trying to get counts on reports with conditionally suppressed records.

CoSpringsGuy, {@Elapsed Time By Days Variable} = datediff("d",{@tot display 1st Discharge Time},{@tot1 display 2nd Admit Time}) It's calculated by doing a datediff on two times calculated using variables. IanWaterman, That did the trick. It is working perfectly. Thank you.

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...

Thank you that worked. I was doing the same thing but I was including an "else " " " on the end of it and it was messing it up. Thanks again.

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 actually figured it out. The problem was in the linking of the different tables. I needed to add a second link of a DATE_REAL field on each table.

Are those 2 fields Dates or DateTime? They are Datetime fields. Are new records created on re-admittance? Yes, they each have a new {Patient.CSN} for each admit. Neither of those fields seems to have a readmit date or time. There is no readmit field in our tables. BTW, what have you tried...

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.

It worked. Thank you so much. That is really awesome. Three of us have been trying to figure this out for 3 days. Thanks again.

The only thing I'm doing to suppress values is to check "suppress if duplicate". Here is an example of what I'm trying to do: Time In Or Time Out OR Record #1 null 6/01/09 13:30 6/01/09 13:00 null null...

I did what you recommended and it is counting all the values (including the values that I have suppressed due to duplicates). I'm trying to find a way to only summarize the values that I actually have showing on the report.

Yes the values are correct. I have the {@elapsed Time in OR} in the Details section. I'm wanting to put the total in the Group 1 footer or Header.

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?