Search results for query: *

Hello All, Using Crystal Reports 8.5/Crystal Enterprise 8, hitting a MSSQL 2005 Database. Here are the details: Mock Cross Tab, grouped by different performance measures down the left side and displaying all 12 months across the top - looks like this: Jul Aug Sep Oct Nov Dec...

Hello All, Crystal Reports 8.5/Crystal Enterprise 8 hitting a MSSQL2005 database. My mock crosstab is working fine except for the background colors in the summary fields inserted in the group footer. I'm basing the formatting on a field which has a value of 1, 2 or 3. 1 = green, 2 = yellow...

Hello, I'm using Crystal Reports 8.5 and Crystal Enterprise 8.0 hitting a MSSQL 2005 database (I know, we're in the process of purchasing CR 2008). I have a crosstab summerizing numerical data with a Performance Measure as the Row and the data date as the column. Here is an example...

Hello Everyone, I'm using the following formula to display information as the row header in a crosstab. I would like to highlight a portion of the text, namely this portion: "Green - " & {Measures.Green} & " Yellow - " & {Measures.Yellow} & " Red - " & {Measures.Red} & chr(10) Is this...

Hello, We're running Exchange 2003. We've just recieved a Public Records Act request and have 10 days to comply. This request involves about 40 staff members and I can't fathom having to search through each mailbox for the various items. Is there a way, or a third party utility, to search...

Hello All, I'm using Crystal Reports XI, hitting a MSSQL 2000 database. I have a report that displays two subreports. I would like to take the data from each subreports and make calculations like percentage. Is this possible? What is the formula syntax?

Hello Everyone, I'm using Crystal Reports XI against a MSSQL 2000 database. I have a report that does a datediff between two date/time fields. Here is the formula: datediff("s",{activity.new_date},{activity.working_date}); //get the seconds between 2 dates Then its converted to...

I'm using Crystal Reports XI and MSSQL 2000. Working with three fields 1-Type, 2-Subtype, 3-Condition. My formula lables each record based on the various conditions of these fields. If one of the conditions isn't met I want the label to be "Other". My problem is when one of these three...

Hello All, I'm using Crystal Reports 8.5 running on Crystal Enterprise 8 hitting a MSSQL Server 2000 database. My report has two details sections. Details a contains client information. Details b contains a memo field and is suppressed if blank. My problem is when the memo field does exist...

Hello Everyone, I'm using Informix 7.3 running on Solaris on a Sun Box. I am trying to extract all rows from a table into a delimited text file. I need to add a text field of "Y" and the end of each row. Is this possible with SQL? Thanks, Jack

Hello, This is my first post in this forum, so please forgive me if I'm in the wrong place. Environment - Microsoft Access 2003 connected to Informix 7.3 database via ODBC driver Problem - I need a query that will produce output suitable for loading into another application. Each record will...

Hello, We're using Informix IDS 7.3. Does anyone know how to modify the dbschema to tell which tables to load in which dbspaces for a dbimport. I forgot to use the -ss operator with a dbexport and then imported and now everything is in root db (noooo!). I don't want to use round robin...

Hello Everyone, This is an Excel 2003 question. We are attempting to prevent decimals from being entered into spreadsheet. I know you can set a cell as currency with no decimal places and if a decimal and the coresponding cents are entered it will round up or down. I'm wondering if we can...

Hello, I'm new to SQL but have the following problem. SQL 2000 on Windows 2000 My 2 Gig database has a 21 Gig logfile. My server has ran out of disk space. I wanted start the database with a new logfile but keep running into errors. This seems like it should be fairly easy, but I'm...

Hello all, I'm a little confused about which of the following menu options takes precedence. Here A and B lead you to dialog boxes that allow you to set options. A = Report / Options / Layout Tab / Create Group Tree (check box) [on the top right of the Layout Tab] B = Report / Report Options...

Hello, We're running Exchange 5.5 on a Windows 2000 box. Out workstations are running Windows XP/Office XP. One user is having a very strange problem. Their Out of Office Autoreply is not functioning. I've logged in as them on several workstations and everything seems OK. I get a message...

Hello All, I'm using Crystal Reports 8.5 connected to an Informix Dynamic Server 7.3 via native drivers. I have a report that is grouped by a formula called 'ClientName' which is 'leadingcaps(client.last_nam & "," & client.first_nam). It's grouped by this so it will sort by Client Name. The...

Help! Something has gone wrong with our system. Last Monday (10/4) the City switched us from static addresses to DHCP. Since I was not sure what affect that would have, I kept the SUN Box running and Charles modified what he needed to, to keep us going. This morning I decided to do a backup...

Hello, I am using Crystal Reports 8.5 connected to an Informix Dynamic Server 7.3 via native drivers. My report uses three tables WIA_APP, WIA_CASE & WIA_EXIT. I want to show clients who are considered Carry In's. These are clients who enrolled prior to a parameter called 'Start Date' and...

Hello, I'm using Crystal Reports 8.5 connected via native drivers to an Informix Dynamic Server 7.3 database. I'm new to crosstabs so please forgive any lame questions. I've created a very simple crosstab based on the following formulas: Row: If {@Enrollment Status} = 'CI' and {@Educ_Status}...