Search results for query: *

Okay. Great. Thanks for the help. I was thinking a pivot was the solution.

Yes RECORDED_TIME is available. Also PAT_ID.

Oy! SQL Server 2008 R2 EPIC Clarity 2010 I have a table with flowsheet IDs called Clarity.dbo.IP_FLWSHT_MEAS. The associated value names are in another table Clarity.dbo.IP_FLO_GP_DATA liked via FLO_MEAS_ID. The value names I'm concerned with are vitals like 'HEIGHT', 'WEIGHT', 'PULSE', 'TEMP'...

Yep that's it. I thought that Display Horizontally button turned the text 90 degrees counterclockwise so I didn't use it. I had it flipped in my mind b/c it seemed the default was horizontal. Anyway. thanks LB

Thanks LB, and that works, but they don't want the crosstab. They want it displayed as a field. 0123 RevCodeName {Qty} {Amount} chr(13) 0456 RevCodeName {Qty} {Amount} chr(13) etc Group 1 is Guarantor Group 2 is Account Admit Date Group 3 is Department ID Group 4 is Patient ID Group 5 is Rev...

Oy! Crystal 2008 Oracle db Epic data I have a report that is nearly finished. One last thing the user wants is quantity and amounts billed PER RevId. Group 5 is table.REV_CODE_ID, and they want the summary displayed in GF2 table.ADMIT_DATE_TIME. GF 2 currently contains a subtotal of...

Used this again today. Thanks!

That worked a treat! As always your expertise is very much appreciated.

I remember getting this error a lot when I was building Crystal reports for Dynamics SL. Seems like I would open the rpt file, click Database -> Log On or Off -> Expand the connection -> expand Properties -> set Trusted Connection to 0. I think.

Oy! CR 2008 No access to DB Epic source data I always have trouble with array formulas. I have 2 TABLES named CLARITY_EDG and HSP_ACCT_DX_LIST. HSP_ACCT_DX_LIST is linked to CLARITY_EDG w/ a LOJ on DX_ID. In the report I need some identifying information, the primary diagnosis and ALL...

I tried the font size suggestion. Anyone else have an idea?

Thanks LB. I tried that and I see what you're talking about. The unnecessary space is not acceptable to the client. Any other suggestions?

CR 10 SQL Server 2005 Oy! I have a crosstab report that has data fields that vary in length depending on options the user selects at runtime. I need to see if there is any way to get the crosstab rows to size themselves according to the length of the field. The choices the user has are...

Crystal syntax cut and pasted directly from the formula.

I'm posting here b/c I intend to alter it to a more conventional format and I wanted to make sure I didn't miss anything.

2 things: There are 2 IF's and 2 Then's. The report functions as intended.

Oy! CR 10 SQL Server 2005 I inherited someone elses report and in the process of discovery I found a weird IF statement: @Agecolumn1 Numbervar vDaysbetween := {@wAgedate} - {pjinvdet.source_trx_date} ; If if {pjinvdet.li_type} <> 'D' and {pjinvdet.bill_status} <> 'B' then(vDaysbetween >=...

I know. Not a big deal. Just trying to be more efficient. thanks LB

Right you are. Will do next time. Thanks. Once you have added said field to Details is there any way of un-linking the two? If I want to link a heading to a Group level field can I?

Oy! CR 10 SQL Server 2005 This is such a rooky question I'm almost ashamed to ask - almost. When placing a data field on the report in Details CR auto generates the heading and links the 2 fields together such that when you delete the data field the heading field is deleted also. How/where...