Search results for query: *

Yep - I was reading one of your responses to a different post and gathering the same thing. I'm adjusting the order my tables are linking in and seeing if I can get rid of those statements too. I'll let you know how it works out - and again, as always, thank you!

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

Figured it out. I found a numerical field that represents each color in the details. I created a summary for that, then supressed it in the footer. I now can base by formatting on that and it's perfect. Thank you for always being here to talk things out with.

I didn't use running totals, just formulas. I did some additional research and am trying running totals now. I'll let you know how it goes.

As always - thank you - here is the formula: ___________________________________________________________ if {RANGE_COMPUTATIONS_6_GET_RESULTS.RangeResult} = 1 then crgreen else if {RANGE_COMPUTATIONS_6_GET_RESULTS.RangeResult} = 2 then cryellow else if...

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

Perfect LBass - Thank You

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

lbass - thank you much. I appreciate it. Worked like a charm!

Where would I place that in this formula? There are other conditions (besides one of these fields being null) that also return an "Other" result. Thank you, Jack

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

Thanks ETID. I did some searching in the help file and noticed it mentioning the 'Allow' box but did not know where to find it. It was under the validation tool. Very easy and just what we were looking for. Cheers