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

Any examples to point me towards....?

bed id - discharge_date(stat17) - date_amount 26294 - 1/6/2007 - (diff between 1/6/07 and 1/17/07) 26294 - 2/17/07 - (diff between 2/17/07 and 2/28/07) Basically at every status 17(per each bed_id)to a different client_id, the difference of the effective_dates. I basically...

Going to try to push this out to a table in a data warehouse....The database that I am using won't allow writing of temp or reporting tables bc of security. Amazing,right?

I dont have the luxury of creating temp tables in this case...It would just have to be some sort of loop to calculate....?

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

Does anyone know how to do this? All I really want to do is to have this on one line instead of 2.

A stored proc is not an option. Is there any examples of building a manual cross tab with conditional formulas??

The id3 and id14 are related bc they have the same form_id The dates refer to the same person by client_id. Here is a better rendition of how the data goes together. client_id form_id type_ID Desc datevalue 5999 01 3 admissiondate 5/7/07 5999 01...

(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 all rows/columns show up EVEN if they have 0 as a summary total? For example I would want to see all of the last row, but right now I am not. a b c priority 5 10 2 welcome 4 8 7 financial 0 0...

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

Row field - formula {@admit} Summary field - count of client_id Cr version 10

My @pack formula is as follows: if ({Command.sequence} = 13 and {Command.std_assess_id} = 11569) then "Priority Pack" else if ({Command.sequence} = 27 and {Command.std_assess_id} = 11569) then "Welcome Pack" else if ({Command.sequence} = 51 and {Command.std_assess_id} = 11569) then "Financial...

...in CE 10

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

Thanks, Now I have 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...