Search results for query: *

Good morning. I thought I'd post this up here in the hopes that someone has seen this before and might have a fix. I use the Crystal Reports 2008 designer (SP3 IIRC). Windows Vista 32-bit Ultimate SP2 DELL Latitude 630 4GB RAM Dual Monitors When I use Crystal Reports, I get very strange...

I've scoured the internet looking for options on how to accomplish this...and I am stuck. Ready for some assistance :) SQL Server 2000 I am trying to concatenate a list of allergies for a specific patient. these are stored in table PatientAllergy PA.ID - PA.PatientID - PA.AllergyID 1 1...

SQL 2000 CR XI I have some very long numbers in SQL database (DBOID that are 21 digits long) however, each time I try and add to a report, they are converted into Scientific notation. I would like to display the entire number. Does anyone know how to do this? Note, the data type in SQL is...

I am using BO XI and I would like to know if it possible to have different sections of a crystal report export to different worksheets in an excel file Thank you -- Andy

SQL Server 2000 BO: XI BO: XI Enterprise Server I am trying to find a way to streamline some of the processes (hoops) that I currently use (jump through) to get data from Crystal Reports Enterprise server into a nicely formatted excel spreadsheet complete with Pivot tables. I've seen in BO...

Oracle 8i datasource CR 9 Pro ODBC connection Report has two levels of grouping: one for Surgical service and the other for primary surgeon. Crystal defaults the sorting to the group levels first. There are some calculated fields in the second group that count the # of cases that a particular...

Oracle 8i datasource CR 9 Pro ODBC connection Report has two levels of grouping: one for Surgical service and the other for primary surgeon. Crystal defaults the sorting to the group levels first. There are some calculated fields in the second group that count the # of cases that a particular...

Has anyone experienced this? Crystal 9 Pro Various Data Sources (Oracle 8, SQL) Excel 2000 / Excel 2003 / Excel Mac 2004 When exporting data from Crystal Reports (both through the client and Crystal Enterprise) I have noticed odd and even troubling behavior when opening the file on a Mac. The...

I was searching for a solution to a problem I have exporting a report with a subreport into an Excel (data only) file. In my search, I found this thread which mentioned a possible bug/fix thread149-913696 I am curious to know if someone has followed up on this particular issue and if there is...

Ok yall - this one might be a doozt (if at all possible). CR9 Oracle 8i I have a main report (no data or tables or select statements) that contains two subreports. The first subreport list a selection of case #s ({V_NI_RECORD.CASE_CONFIRMATION_NUM}) along with some other fields. The second...

I am not sure if this is possible or not, but, does anyone know of a way to save a CR 9 report as an earlier version (8.5)? -- Andy

Hi all - Oracle 8i CR 9 I am trying to insert two subreports into a main report where the main report is pretty much a 'container' only. Example: Subreport #1 "subrpt 24hours out" Here is the SQL statement for this subreport - designed to pull records where the scheduled procedure date is...

Help....hehe CR version: 9 Pro DB: Oracle 8i Currently stuck trying pull data displaying preference cards for a particular doctor and all of the materials referenced by a particular preference card. Tables/fields in use: Person.PersonID,Person.Full_Name,Card.Card_ID,Card.SurgeonID. I've not...

CR9 Pro Oracle 8i DB I am curious, is there any way to modify the date range of the built in Calendar1stQtr to reflect dates that more closely resemble fiscal year/quarter ranges? IE: 9-01-04 to 8-31-05 as an example of FY05

CR v9 Pro Oracle datasource I was just wondering, I want to try and use a distinct parameter value in a formula. Can I do this by simply inserting the parameter reference into the formula in question? Thank you.

CR v9 Pro Oracle DB I am currently stuck on this one minor detail of my report. I am trying to count the specific instances of a data value in one column of my report. Report is grouped by Day of Week Column to count is Block_Owner Possible vaules in Block_Owner column: Neuro, Optha, H&N...

I am trying to write a formula to: 1. Calculate the diff between times and display in minutes (but only when the times in question are on the same date) 2. Return a text message when there is no previous time on the day in question. Fields being calculated: {V_NI_RECORD.OR_TIME_STOP} using a...