Search results for query: *

Thanks. I tried that, but the issue is that I do want SOME headers on the drill-down. I just want to suppress certain header sections on drilldown. Is there a way to do this?

I'm using CR 8.5. I have a report with two subreports, in report headers a and b, that contain summary information. When I drill down into hidden details on the main report, the summary subreports show up on the new drill down tab. I want to hide report headers a and b on drill down. Anyone have...

Thanks for the reply. I'd never used the "convert null field values to default" -- it makes this sort of issue go away, which is nice. The real question on this is WHY you have to check for null values first. Shouldn't the formula evaluate every part of the "or" statement? Or...

I have a report doing some strange things regarding evaluating a zero or null value. The report uses a left outer join to join an inventory table to a bill of materials (BOM) table. There are some records that have a matching BOM record, and some that don't. I have a boolean parameter...

I'm hitting the wall on this one. I have an Inventory report which is grouped by inventory item and site (Groups on the following formula: {InvItem}&{Site} ) The boss wants a parameter that will prompt for how the report will be grouped. They want to group by items at an individual site (which...

Nope. I was teaching a Crystal Advanced class, and one of my students came up with this problem, so I thought I'd see if there was an answer to why it's not working. There's a bunch of different ways to do the same thing (.e., if...then...else), but if the IIF statement doesn't evualate this...

It looks like our confusion is due to the formatting on this site. Squarebrakcet-i-squarebracket is being interpreted as italic. My posts, and it looks like yours, drop the square brackets and anything in between them. Let's try this again: Local NumberVar intvar:=1; Local StringVar PhoneVar...

My apologies, I missed an item in my formula when I posted it. This still doesn't work Local NumberVar i:=1; Local StringVar PhoneVar; While i<=length({Customer.Phone}) do ( IIF(IsNumeric({Customer.Phone}[i]), PhoneVar:=PhoneVar+{Customer.Phone}[i], PhoneVar); i:=i+1 ); Right(PhoneVar,6)

Yes. I'm using the while statement to loop through the phone number field and parse out any non-numeric digits. The final end product is an account number based on the last 6 numeric (not &quot;-&quot;, &quot;(&quot;, or space) digits of the phone number. The big question is why the IIF...

Does anyone have any idea why the following formula doesn't work? I'm trying to return the last 6 numeric characters from a phone number. I know there are other ways to do it, but am not sure why the IIF statement isn't evaluating correctly. It seems to return &quot;true&quot; regardless of...