Search results for query: *

I need to return only certain rows based on some logic: (for each sets of episode nbr and mpi id, if there is a ranking of 1, then ONLY show 1) ELSE (for each episode nbr per mpi id, if there is NO ranking of 1 then just return all rankings no matter what) Is this case statements?? I want to...

Is there an easy way to calculate a datediff of date/time field(effective_date based on the change of another field (client_id) changes by bed_id ? AKA when status_code_id is 17 for a row, then the next row is a different client_id, calculate the datediff of effective date from these 2 rows...

(CR ver 10) I have 2 lines with 3 fields, but i have to compare id14 to id3 lines to get a comparevalue field (want to show whether admission date is >,< or = to completedate). ID Desc datevalue 3 admissiondate 5/7/07 14 completeddate 6/1/07 I would like...

Is there a way to have a custom sort (not alphabetical and not by summarized field. My current crosstab looks like this: a b c financial 5 10 2 priority 4 8 7 welcome 4 9 3 This is in alphabetical...

I have a cross tab with the correct numbers BUT the percentages are not adding up(I put a summary field under the row count for %) The bottom total line says 100% but the other three for example say 38%, 17%, 44% which equals 99%. I right clicked on it and tried to format it but I didnt have any...

I am not able to suppress the counts in my cross tab for a formula called @pack. I am suppressing them successfully by using the section expert in the detail line (@pack = "other") BUT the numbers are still be shown in the cross tab that i have in the report header. I do not want them to show...