Search results for query: *

You can catch more flies with honey than with vinegar. Have the team meet to brainstorm to create new policies and procedures for themselves. The only way to get employee buy in is to implement their ideas. Make sure everyone has a voice, even those employees that tend to hide in a group...

The PO Coding remains in MMDIST. If the Accounts Payable clerk changes the coding on a line within a PO, the coding change is recorded in APDISTRIB only. Also if the AP Clerk has an item on the invoice that was not on the PO, the new item will be entered and will be given a line number of zero...

I am working with Crystal report 9. Background: I am trying to create a report that summarizes AP clerk entry. A major piece of this entry is invoice coding. The coding is first entered on the purchase order (MMDIST), upon entering an invoice the AP clerk may decide to change the coding or...

Jim, Thanks for your detailed response! I have never used this type of formula and can't wait to try it out on some of my other reports! I have one related question: One of my codes is a number 641. When I type NumberVar 641:=0; into my formula I get an error message "A variable name...

lbass, I added the second sort criterea and changed the "in" formula to the syntax in your suggestion. Although the in formula was accepted as valid, neither of my changes made any difference to the incomplete totals on the report. Thanks for you input anyway - I will keep trying...

synapsevampire, I am already sorting by employee last name. After reviewing the post I forgot to mention that the formula would not work as you originally proposed: ({salary,cat} in "TIF", "OTH") The system would only evaluate the first code and would error that "the...

Through deeper investigation I found that the solution does not entirely work because of the table set up. I thought the table listed the employee #s in order and grouped each employee together, but I am finding that the employee numbers show up multiple times in random order (rather than...

Thank You Synapsevampire -- it works beautifully!!!! I appreciate your time and expertise! Lhendrickson

Thanks for your quick response, I will try this right away and let you know the results. LHendrickson

I am using Crystal 9.0 against Lawson tables. I have 2 tables an employee table that has one row of detailed employee information, and one table with salary information by type (overtime,foreign assignment, underwater,etc)for each employee. In the salary table there are up to 20 rows per...

I am using Crystal 9.0 against Lawson tables. I have 2 tables an employee table that has one line of detailed employee information, and one table with user field data for each employee. In the userfield table there are up to 10 lines per employee because all of the user field data is printed...

Thank You Synapsevampire!!! I followed your suggestion and it worked beautifully. You are correct I was misusing the term duplicates b/c although I intended to suppress some of these lines they were not pure duplicates. Note: For those of you that are unfamiliar with grouping - like me - you...

We are on Crystal version 9.0. I am working on a report for our HR department. They have a need to see the most recent raise for each employee. Due to multiple tables being involved I had a number of duplicate records. I have narrowed my dataset down quite a bit using the following formulas...

We have our budgets and variances in the Scenario dimension. Actual, Budget, Forecast, and Variances all roll into this dimension. I have never seen it done any other way -- let me know how your proposed structure works out. LHendrickson

@Duplicate Flag = IF Previous ({@Concatenate Fields})=({@Concatenate Fields})then"Flag" Else"Not Duplicate" @Concatenate Fields = ({APDISTRIB.COMPANY}&{APDISTRIB.VENDOR}&{APDISTRIB.INVOICE}&{APDISTRIB.DIST_SEQ_NBR}) The Concatenated fields determines if it is a unique or...

I am using the following formula in the formatting formulas section of the detail section: IF{@Duplicate Flag}=&quot;Flag&quot; then True When I put the following condition: {@Duplicate Flag}<>&quot;Flag&quot; in the &quot;Evaluate&quot; formula area in a running total I get the following...

What feature would you use to Sum up only the visible data and not the duplicate row amounts? LHendrickson