Search results for query: *

I used the second solution as it seemed more straightfoward to me, but I thank you both very much!!

I know this must be simple, and I have read through dozens of posts, so maybe I have just missed it somehow. I have a report that is grouped by the employee ID number. It displays the groups in that order. But I need to sort and print the groups themselves by the employee Name field. I can't...

Turkbear - Sorry if I was not clear. I want to return ALL license data, for those employees that have an active license of a certain type. So if the license parameter is entered as "CL" and these employees have the following licenses: Lic. Employee# Type Active 101 CL...

There are no formulas in the record selection area, only the Group Selection area is being used, and it has the sum formula. Still only getting the one active row darn it. I don't want to take any more of your time but I do appreciate your help - I'll keep playing around with it and post...

Okay - I got a little further. My formula {@HasLicense} looks like this: If {EMPCODES.CODE} = {?LicenseType} and {EMPCODES.ACTIVE} = 'Y' then 1 and my GROUP selection formula is: Sum ({@HasLicense},{EMPCODES.EMPLOYEE})>=1 But for each employee it is only returning the one active row, not...

On the first formula - do I create that as part of the group (on the options tab)? Or just create a formula by itself, and put it...where? Sorry - I am trying it, I just am missing a step somewhere I guess.

Thanks for the quick reply. But that will only return the row with the active flag. I need to show ALL of the licenses that exist in the table (active or not, any type), for each employee that meets that criteria (has a licensetype = &parm and activeflag = Y) So I am hitting the table twice...

I know this is simple, but I am new to Crystal, and I'm stumped. I have a table with these fields (greatly simplified): Emp#, License_type, Active_flag There are many License_types for each Emp#, but only one where Active_flag = Y. Here is what I want: Show all records, by employee, for...

This is a basic formula. How would this be written in Crystal syntax? And is there any advantage to using one over the other?? formula = "From " + ToText(Minimum({?ActivityDateRange})) + " To " + ToText(Maximum({?ActivityDateRange}))

Thanks for the responses. That helps.

We have a staff section on our intranet where the users login with their SSN number. We want to replace an existing report with a similar one in CE. This report has a parameter for SSN. Is there a way to place a link on our intranet that will allow a user to run the report, without any...

Thanks a bunch. Seems so simple, but it was beyond me!

I have a date field that occasionally has a SQL server default value of 01/01/1753 in it (no nulls allowed, yet the application does not require the date to be entered!). I want to show this value as blank on a report. After I had no success figuring out a Crystal syntax formula, a co-worker...