Recent content by ghostofelmo

CR8 I have fields that I am trying to summarize but CR isnt recognizing the numbers. How do I get it to recognize the numbers as numbers? {P Folder 1.Sq Ft}+{P Folder 2.Sq Ft}+{P Folder 3.Sq Ft}+{P Folder 4.Sq Ft}+{P Folder 5.Sq Ft}

Wow all it took was writing my response to you. I think that the following formula was all I needed. {P Folder 1.Room 1 Active} = False or {P Folder 1.Room 1 Active} = True and {P Folder 1.PAR:} = True Thanks for letting me have something to respond to.

Sorry to confuse with all of the button lingo. Here is what I am working with: First off we have production folders that can either be active or inactive (first suppression) but the active ones need to be turned off once a particular field is marked as true (second suppression). Still clear...

Using CR 8 Can you suppress in the details section using 2 qualifiers? I am writing the report off of 6 tables, one is a master and there are five tables that link directly to it. I need to indicate wether one of the buttons on each of the five areclicked on and the other clicked off to pull...

Formula returned not a numeric value. But I discovered that you can sort by "speicfied order" and just typed 1 through 10 and it worked

I am sorting my reports by priority. We are using a range of 1-10, how do I get the 10 to print after the 9, instead of the 1?

I have been using Excel formulas too much. I used the 5 formula fields then added them up. Thanks!

I am using the following formula If {P Folder 1.Material} = "Stone" then {P Folder 1.$} else 0 + If {P Folder 2.Material} = "Stone" then {P Folder 2.$} else 0+ If {P Folder 3.Material} = "Stone" then {P Folder 3.$} else 0+ If {P Folder 4.Material} = "Stone" then {P Folder 4.$} else 0+ If {P...

AyJayEl Bless you!!! Thanks that killed it![thumbsup2]

You are correct that I am returning some null values good call, now what you sent me is asking for a then because of the IF, I removed it and found no error. Now how do I compare Folder 1 to Folder 2 as true/false. I am trying the following to no avail. IF (not isnull({P Folder 1.Room 1...

Where would isnull go, because the only results returned by each field is going to be either True or False, False by default. I am trying to determine how many of the rooms are active, by checking against the table for each room. Thanks

I am using the following formula to evaluate the total number of rooms in a job, using Crystal 8. The formula editor sees nothing wrong with the formula, but yet it returns no results. Any thoughts? IF {P Folder 1.Room 1 Active} = True and {P Folder 2.Room 2 Active} = False then "1" else IF {P...

Thank you Thank you Thank you, You ROCK! I knocked it down to .7 and .125 and it is just what I am looking for!

I set the Width to 8 inches the Height is dimmed out I set the horizontal gap to 0.125 left vertical gap at 0 I selected Across then down

I am getting : 32769 33413 33420 33561 and would like : 32769 33413 33420 33561