Recent content by Alundil

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

gmmastros - thank you very much - that is just what the doctor ordered. Worked like a charm. -- Andy

sds, I'd answer your question, but since I am still in the veritable stone age as far as SQL Server is concerned, I'll let others respond. gmmastros - i'll be trying your suggestion shortly. thank you. -- Andy

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

Syn, Thanks, I was looking for something like that solution and I think I might just have been to tired to see it. But, anyways, thank you for a very elegant solution. -- Andy

THANKS SYNAPSE -- Andy

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

Thank you -- Andy

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

Will do - thanks -- Andy

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

thank you for the responses everyone - I will start a new thread a post a more detailed description of my issue -- Andy