Recent content by govmule

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