Search results for query: *

Hello All, I've searched the archives but didn't see an answer for this problem. I have somebody that has a legacy MSAccess97 Training database (using Workgroup Administration to handle security as it is req'd for this need). This MDB & MDW file are located on the network so that multiple...

Let me try this another way - As an example here's a visual: GH1 - assigned to GH2 - proccessname ==================== GF2a Jan Feb Mar Apr Atlanta HR 5 4 4 (@Active-Inactive) MI 10 11 11 ======================== GF2b...

Ken, In the 'Inactive' running total this was easily defined as {cccusers.userID} = {ccctransfers.frn_userID} and I believe this would work since it would only calculate for people in the particular processname. All CCCUsers.UserID records have a duplicate ID in the CCCTransfers.frn_userID...

Thanks for the responses. Ken here is a sample of the records I'm dealing with. I've only listed the pertinent fields: ====================================================== ~~ CCCUSERS ~~ FIELD VALUE lname Gonz fname N frn_locationID 2 //locations table-...

Hi all, I have a report that tracks the 'headcount' of people in different departments in different regions. Based on that different calculations can then be made. To find out this number I have two formulas (for every month of the year) that will theoretically determine what is the Active...

Hi All, I'm running Crystal 8.5 with a SQL 7 database. This is a report that is grouped by location and then department. What I'm trying to find is the number of active people. I have a formula that looks similiar to this one that I'm running in the GroupFooter2 section...

Ken, Thanks for your help. I found my mistake. Instead of {users.STATUS} = "H" I need to use {users.paytype} instead. I guess that's one error that the 'check formula' option won't catch (Duh). Sorry for taking up your valuable time. Thanks again for your timely response, NGonz

Ken, Thanks for your help. I found my mistake. Instead of {users.STATUS} = "H" I need to use {users.paytype} instead. I guess that's one error that the 'check formula' option won't catch (Duh). Sorry for taking up your valuable time. Thanks again for your timely response, NGonz

Hi all, I was hoping to get some assistance for a formula problem I'm having. I want to use this formula in a running total but just am playing with it in a formula to try to get it to work. Termdate is a sting field that tells what date a change was made (was originally termination date...

Thanks to both of you. That's exactly what I was looking for. I don't recall seeing this explained in the manual. Thanks again, Ngonz

Hello All, I'm sure there is a way for an IF statement (using Crystal syntax) to have multiple results. For example: If <True> then Do step 1 Do step 2 Else If . . . I'm sure this can be done I'm just missing something. I've tried a few different things but don't get the results I want...

Thanks Ken for the input. However, I'm not sure I'm exactly sure I understand where your coming from. Could you possibly elaborate? What I think I hear is that I would have multiple parameters (for cities/regions- Parameter 1 let's say) and then another parameter(2) listing the named...

Hi All, Does anybody know of a way to be prompted for a parameter but be able to choose from multiple 'pick lists'? I have a field that contains various city locations which I would like to define also as regions (ie, North America, Europe, Asia). This way when the report is run and the user...