Recent content by trixiegrrl

Yes, I tried conditional suppression on the details, which works, but I would need to display the report at the Group level.

Hello All, I'm trying to display a memo field that is 4000 characters in Crystal Reports 2008, and it doesn't really work as expected. It doesn't work at all, acually. Crystal throws a non-descriptive error saying that it has stopped working. I try just displaying the field in the details...

Hello, We have Access 2007 and we have Crystal with an Oracle back end. When you click the command button in Access, we want to launch a report stored in Crystal. Please advise, thanks.

I figured it out with a Running Total and sorting! Too bad I can't delete my post!

Here is what I am trying to do: I am trying to showing trending averages of MDs who came on staff in 2007, 2008, and 2009 in regards to their ages. So, I have a few fields that are importrant here. I have Current Status, Status From, and Historical Status, and Historical Status From. The...

Yes, 1 - make a formula called @Fake Group: whilereadingrecords; "" 2 - Group by it. 3 - Suppress Group Header. 4 - In the Section Expert of the Group Footer, select the option: Print at Bottom of Page.

Great, thanks! That worked, but I flagged both by doing: if {@From Date} < previous({@Thru Date}) then red else if {@Thru Date} > next({@From Date}) then red else black

I have this probelm and I am drawing a blank on how to resolve it. I have a report that shows University Name and From and Thru Dates attended the University. All three fields (From and Thru are separate fields) display in the details section like this example: University of Rochester...

oh and be advised that if you have any totals you will need to do Running Total instead.

Create a formula to test for Right Heart Cath: if {TestName} = "Right Heart Cath" then 1 else 0 not necessary, but if you want, put the formula in details and do a Sum on it by the ID Group. (you can then suppress these or delete them) then go to Report Menu > Selection Formulas > Group and...

Thanks lbass, that works and is easier than the other solution (making a formula and referencing it in the record seclection). I was noticing it still doesn't get passed into the SQL Query Where clause. I know I can use a SQL expression with Upper to get it to pass in but I recall vaguely...

Want: Testa Don't want: Test Atest Acktest Testtesttest Detest Testing Stestinger

Make a formula with this: global numbervar DOB := day({DATE_OF_BIRTH}); global numbervar MOB := month({DATE_OF_BIRTH}); totext(MOB,0) &"/" & totext(DOB,0) then group by it.

You will have to do a manual running total using variables, you can google the topic if you want more info about why, etc, but it will be something like: (Reset may not be necessary unless you actually do need to reset it, put it in the section of your report where/if you want to reset) @Reset...

There is no conditional formatting on a box that I am aware of. I would make a text object with a border instead and control that with a formula.