Search results for query: *

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

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

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

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

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

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

Oy! CR 10 SQL Server 2005 Summary: I have an Estimate report that drops data at a certain unknown threshhold. Setup: We have Projects and Functions w/in those Projects. The RH is Suppressed, PH has 2.5" of data describing the Project, the RF is Suppressed, RF has 2" of data. There are 3...

Oy! CR 10 SQL Server 2005 I have a simple report with one mutli value parameter. I want to highlight the Details section with a different color for each parameter value. The actual colors don't matter, just that each value has it's own color. thanks

Oy! Access 2003 SQL Server 2005 I need some help porting the following query from Access to SQL Server. I am not familiar enough with the PIVOT and TRANSFORM statements yet to understand fully what's going on. Access query TRANSFORM Sum([mtbl Combined Totals].SumOfBalance) AS...

Oy! CR 10 SQL Server 2005 I'm curious how CR determines indexes and precidence? I have a table that has one index in SQL Server. When I go in to link it to another table it lists 8 indexes, color coded for 1st, 2nd, 3rd and so on. Is CR just using onboard logic to determine these? Can the...

Oy! SQL Server 2005 CR 10 I have found posts relating to moving from a Table to a SP but I am trying to go the other way; SP to Table and I am getting an error: 'Cannot obtain error message from server.' I used Set Location and it seems to work but this error shows up at runtime. The SP has a...

Oy! CR 10 for Solomon SQL Server 2005 I was wondering if it's possible to have Crystal update a table and turn a flag on based on what was requested in the report by the user. I have a pre-process SPROC that fires when the report is called from Solomon. This SPROC dumps a bunch of records...

SQL Server 2005 I feel dumb for asking this but I can't figure it out. I need help to iterate through an employee status table and select only the most current record either using a View or SP. Ex. Name Status Effective Date Sally Someone H2 11/03/2006 Sally Someone H1 09/15/2005...

Crystal v10 SQL Server 2005 Hello, I have a Monthly Client Hours Report I am working on. It's basically a manual crosstab. A SP on the db fires and populates a temp table with the data my report needs. The data use Fiscal Periods (12) and Transaction Dates. Example would be 200610 and...

Excel 2003 SQL Server 2005 I have read through many posts but can't seem to find the answer to my problem. I am very green with VBA. I have a spreadsheet that uses external data to populate PivotTables. From these PT's I have an Analysis sheet that references rows in the PT's. I am trying...

CR 10 SQL Server 2000 Oy! I have seen several posts regrading how to code multiple parameters on this forum. Is there a best practice that most people agree on? ( {?param1} = {table.name1} or {?param1} = "All" ) and ( {?param2} = {table.name2} or {?param2} = "All" ) versus ( if...

Oy! CR 10 SQL 2000/Solomon I am creating an overtime report. One department, APS, keeps time differently and separately from the rest of the company. Most departments use weekly time reporting, APS uses daily. The report specs state the report must be based on {pe_date} period end date...

CR 10 SQL 2005 I am fixing a estimate report I inherited. It's a manual cross tab that I need to be able to populate date columns for. Say I have a job# and this job# has 4 possible revisions. Each revision has a different DateTime and amount. I can figure min and max easy enough for Date1...

Oy! SQL 2005 I have an Estimate report that is run from Solomon. It has 3 groups. Portrait printer setup. The total Header is about 2 3/4" high, the total Footer is 2 1/4" high. That leaves 3" for the body. Not a problem unless the body runs more than 3". Expected behavior is that output...

CR 10 Access Oy! Is there a way to control the order that parameters prompt at run time? I have 8 parameters {?Client}, {?SortField1} - {?SortField6}, and {?ReportType} and I want {?Client} 1st {?ReportType} 2nd and the remaining {?SortField} parameter in order from 3rd to 8th. thanks, .batman