Recent content by grendel81

I should have mentioned, I am using CR 9 Adv.

I am trying to create a cross tab based on 13 months of data. There are several sections, with several measurements per section. Each value for each month must be compared to a target value for that month. I have a formula that does the comparasin, and writes the results to a variable, as...

We ended up adding a third field to the table, default_text. I then added a running total counting the number of records displayed. If RT0 = 0 then table.default_text else table.commment.

Thanks for your assistance on this. What I get currently is Bullet_num table.comment 0 1 good candidate 2 a different comment What I want to have is: 0 No Comment Unless there are comments, in which case bullet 0 is...

Well, the field is blank or null in the table at the moment. This particular string shouldn't display if there is anything in the field. what I have tried so far: if (isnull({table.comment}) or trim({table.comment}) = "") and table.bullet_num = 0 then "No comment" else {table.comment} I have...

Hi, I am trying to conditionally display a string if the field is blank or null. We have a database in which the users enter in their comments. If there is a comment, then the data is shown. If there are no comments, they currently have to type in "No comment". What I would like to have is...

Hello all, I have a bit of a problem (as you can see from the subject). I have a table that is a mix of raw data from the DB, and calculated fields in crystal. What I need to be able to do is have them all display nicely in a crosstab style chart. here is the data layout...