Search results for query: *

I have a report that has it's grouping linked to a dynamic grouping filter which I want to do a custom sort on. Basically, the table and field are a Shift Type Name that sorts in alphabetical order. What sort formula should I use? OR_LOC_SHIFT_TIMES.SHIFT_NAME that is linked to another table...

I created a command for my report: select resindstaffinfo.last_name + ', ' + resindstaffinfo.first_name from phsprod.dbo.resindstaffinfo where resindstaffinfo.is_pract=1 I did not link this command in the Database expert and I am not referencing it in my main report but when I try to run a...

For some reason I have a report that has information cutting off from the left and will not print the whole report (in landscape) accordingly. I do not have this problem with other reports but this one. I've looked at the printer setup, page setup, report options and options but can't figure out...

I'm having trouble getting a report to show totals for group. Below is how the report is structured. I used running totals. GH1 SF.SRCFAC GH2 TEST.TESTCODE [suppressed] D [suppressed] GF2a [TEST.NAME] [TEST.TESTCODE] Total Resulted: @Total Code @Total Code: {#Other Code Total} + {#Stat Code...

I have two subreports in a main report and I want to make the 2nd subreport show up if the 1st subreport returns data. The 1st subreport is looking for certain test codes in the selection expert and if they return data for those codes then I want the 2nd subreport to populate. Thank you, Gary

I have a report that I am having a hard time getting a grand total for a GH1 (using CR 9). The report is setup as follows. GH1 SF.SRCFAC GH2 TEST.TESTCODE [suppressed] D [suppressed] GF2a [TEST.NAME] [TEST.TESTCODE] Total Resulted: @Total Code @Total Code: {#Other Code Total} + {#Stat Code...

I have inserted a cross tab that I would like to have show total number of specialties listed in the report. When I add the cross tab with column formula: if {resind.class} = 'KAISER' then {service.abbr} else if isnull({resind.class}) then " " and row info: count {appt.appt_id} I get a...

How do I go about suppressing a group header based on a record returned? I wrote a report that uses 3 group headers GH1 service.abbr GH2 appt.start_datetime GH3 appt.appt_id Da subreport Db subreport In the Suppress formula (X-2) of the Details and GH3 section of the Section Expert I added...

Basically, I have a maine report that is set up with two subreports. One in a GH and the other in the details section. I'm wondering if there is a way to suppress or do a record selection on the results of the subreport in the details section. If the subreport in the details section shows...

Below is a formula I created to evaluate each row in a table and bring back the correct row due to the criteria (but I was having trouble doing so): if {schedlog.audittype_id} = 2 then date({schedlog.scheduled_datetime}) else if (date({schedlog.scheduled_datetime}) <>...

How do I create a dynamic parameter for the SQL query below. Currently, the table is appended but it gets updated constantly and manual updates would need to be done to the report so I would like to convert the static parameter to a dynamic parameter. The Table name is proname.abbr and would...

I'm writing a report where the end user would like to look at the data in two ways using two different parameters in the same report. 1) Using a surgery date parameter 2) Using a posted datetime parameter Is this possible in CR XI? If so do I create separate parameters using the different...

I need to know how to show months as an age for this formula. It will calculate only in years and if I have a patient that is 10 months old the formula shows 0 as an age when I really want 10 months. // birthday feb 29 and current year is leap year if month({pat.birthdate})=2 and...

Main Report set up: sub=subreport GH1a:@SchedulerName NewAppts(sub) Changed(sub) Canceled(sub) GH1b:(suppressed) @NewAmtSum @ChangeAmtSum @CanceledAmtSum D:(suppressed) GF1:(suppressed) RF: Grand Total:@NewGrandTotal @ChangeGrandTotal @CanceledGrandTot Subreport formulas: NewAppts...

I'm trying to write a report for my hospital's registration department where when scheduling makes a date change to an appointment the report will only return that row if certain criteria has been meet. 1)The appointment is a brand new appointment. 2)The appointment date has changed (the fields...

I have a parameter on a report that I would like to do two things with: 1) When I append the table I get more then just physician abbrs, I get the whole table. I would like to limit the table to just physicians. 2) When the end user runs the report, I would like them to be able to pick ALL the...

Afternoon, The report I'm writing needs the enduser to enter answers to questions for the table to be populated (answerlist table). The answerlist table is linked to the visit.visit_id so when the questions are answered the visit.visit_id is the primary key and the foreign key is the...

Can anyone explain to me why I am receiving this message and how to fix it? I'm using CR 9.0. UFL 'u2lhlab.dll' that implements this function is missing Thank you, Gary

I've created a main report with 4 subreports apart of it (in added group footers) and I would like the main report to print first then the 4 subreports in order. Page 1 Main Report (in Group Header 2) Page 2 Subreport 1 (in Group Footer 2a) Page 3 Subreport 2 (in Group Footer 2b) Page 4...

I have a report that I am trying to make work where I have a schedlog.audittype_id of 1 and I want rows returned with this audittype if two criteria are fulfilled. 1) schedlog.reschedreason_id in 1 to 22 2) schedlog.scheduled_datetime has a date change ONLY. Not just a time change within the...