Search results for query: *

It looks like you posted this in the wrong forum. ~Brian

Solid option posted by Charily. Here is another that isn't better but just another technique to do the same thing. -Insert a group on the bus number field. -Delete the Group Name field that was added to the new Group Header. -Move all the detail fields to the Group Header. -COPY all the same...

Change the Date() function to the DateSerial() function and it should work from there. ~Brian

...is one. -Create a formula and call it "Amount for Cum Bal" -Use this logic for the formula: if {Table.Trans} = "Payment" then {Table.Amount} * -1 else {Table.Amount} -Create a new Running Total field that summarizes the formula above, evaluates each record, and never resets -Place the...

How about just trying this: if instr ({'Administrative_Action_Report_'.Sanctions: Sanction},"Dismissal")>0 and instr ({'Administrative_Action_Report_'.Sanctions: Sanction},"Deferred")=0 then 1 else 0 ~Brian

That looks like an Excel formula. Did you intend to post this in an Excel forum or do you need help converting this over to Crystal Reports? ~Brian

Can the procedure be changed? CR will recognize the SP parameters as actual dates, rather than strings, if you define them in the SP as DateTime type rather than Date. ~Brian

The text has to match exactly. Leading and trailing spaces are characters just like letters and numbers. If they do not exist as pat of the values in the database column, it won't find it. When you did not use the leading and trailing spaces, it did find it. ~Brian

You should be able to use this same solution for multi-word phrases. Have you tried it out? ~Brian

I should have stated Group Footer rather than the Header. I just realized what the issue is. The Sum function you are using is the overall or grand total of the field. You need to reference the subtotal: if Sum ({@ExportPrice}, {PartRevisions.uimrCountryOfOrigin})=0.00 then formula = true...

A couple of thoughts. One, are you certain you have the formula in the correct place? Ensure that you have the group header section selected in the Section Expert and that you have the formula behind the X+2 button to the right of "Suppress (No Drill Down)". Second, are you sure that the...

You can either add the additional spaces like CoSpringsGuy posted or you can add any spaces to search on when the user puts in the prompt value. There are pros and cons for each. If you add the spaces in the record selection criteria, it saves the user from having to remember to add them. The...

I wasn't sure from your original post if you were looking to get exact matches of values from your img desc field or if you want to be able to match patterns. Since you want to match a pattern, the solution you found is the correct approach. Nice job figuring that part out! ~Brian

It sounds like you have referenced the parameter in your report, like dropping it on the report for display purposes possibly, but not used it in the actual Record Selection in order to filter the report records. I don't have a copy of version 9 on my laptop so these instructions may be...

Agree that there are a couple of flaws in what I posted. Definitely need to use "maximum(LastFullWeek)+1" on the last line to pick up the second Sunday. You can either do the same thing on the first line or just get rid of the second underscore. Here is what your end result might look like...

There is certainly more than 1 way to accomplish this. Here is one approach: Use this logic in your Record Selection Formula: ( {table.CreatedDate} in minimum(LastFullWeek) _to_ maximum(LastFullWeek) OR ({table.CreatedDate} = minimum(LastFullWeek) and {table.CreatedTime} >= "070000") OR...

I think "CurrentFieldValue" is what you are looking for. IF CurrentFieldValue < {@LO THRESHOLD} THEN CRGREEN ELSE IF CurrentFieldValue > {@HI THRESHOLD} THEN CRRED ELSE CRBLACK ~Brian

Not sure if you figured this out yet or not but you need to go into the properties for the Break and set the property "Repeat Header on Every Page". ~Brian

Would the year to date total be year to date through that quarter then? ~Brian

To just suppress the Detail section if it only has 0's, you can suppress the detail section based on an Aggregate function. Not sure if your field that can be 0 or 1 is numeric or a string, so you may have to adjust my solution for that. Let's assume it is a string. Open the Section Expert...