Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ginaburg

    Comparing dates by using other criteria

    That worked great. Thanks for all of your help.
  2. ginaburg

    Comparing dates by using other criteria

    After putting in a grouping for approver, both of your suggestions worked. Thank you. Here is what I have for the date difference between approvers if {APUI.APRef} = previous({APUI.APRef}) then totext(datediff("d",previous({APUR.DateApproved}),{APUR.DateApproved}),"#",0) + " days" else "" Now...
  3. ginaburg

    Comparing dates by using other criteria

    The records are sorted by invoice number but where does the approver come into the formula. I need to see that Group 1 - Invoice 123 approver 1 approved on 12/3/14 approver 2 approved on 12/6/14 approver 3 approved on 12/15/14 with the number of days between each one.
  4. ginaburg

    Comparing dates by using other criteria

    I am using Crystal 11 I am trying to get the difference between dates based on the approver of an invoice. Approver 1 approves invoice on 12/3/14 Approver 2 approves invoice on 12/6/14 Approver 3 approves invoice on 12/15/14 I need to get the number of days between approvals. My fields are...
  5. ginaburg

    Trying to use the case function in Derived Column

    Im using SSIS 2012. This is the expression that I have on my field. The paymethod field is char field of length 1 I am trying to say if it = C then put "CHK else "EFT. How can I write this expression when I want the output to be 3 char. The following give me an error [Flat File Destination [35]]...
  6. ginaburg

    Need a fixed length flat file with Header, Detail and Trailer records

    I was wondering if someone can help me with some of the flow for this project. I am farily new to SSIS and seems like there are several way to accomplish what I want to do. Just trying to get some input before I go in the wrong direction. Here is what I need to accomplish. We need a fixed length...
  7. ginaburg

    Need help combining formulas

    I ended up doing 3 cross tabs. The original one, one with just Minority and one with male/female. The problem I had from there was to supress the columns that I didn't want. I went into the group and selected specified order, listed the ones that I wanted to set it to delete all othere. It...
  8. ginaburg

    Need help combining formulas

    It's a SQL database but it is written off of a stored procdure.
  9. ginaburg

    Need help combining formulas

    The cross tab works great and it also taught me a little more about cross tabs. If I could bother you with one more question. For the race formula, I have select {brptPRWklyCompliance;1.Race} CASE 'I': 'Amer Indian' CASE 'A': 'Asian' CASE 'B': 'Black' CASE 'H': 'Hispanic' CASE 'W': 'White'...
  10. ginaburg

    Need help combining formulas

    I was thinking along the same lines with a cross tab but since I haven't worked with then that much and wasnt sure how to group the formulas, I didn't go that route. thanks for the information. I will give that a try.
  11. ginaburg

    Need help combining formulas

    I would still need each class. It would look something like this (partial list) Total Total Minority Hispanic Black Asian Male Female Male Female Male Female Male Female Male Female Apprentice 5 2 2 1...
  12. ginaburg

    Need help combining formulas

    Thanks for the input. So you don't think there would be any way to combine the formula? I'm still going to have about 50 formulas.
  13. ginaburg

    Need help combining formulas

    ...I will have about 50 Count and 50 Print formulas. WhilePrintingRecords; Numbervar CountApprenticeM; if ({brptPRWklyCompliance;1.Class} LIKE 'CA*' OR {brptPRWklyCompliance;1.Class} LIKE 'EA*' OR {brptPRWklyCompliance;1.Class} LIKE 'FA*' OR {brptPRWklyCompliance;1.Class} LIKE 'IWA*' OR...
  14. ginaburg

    date ranges by group formulas

    When I do that, I only get January 2014 data. So I tried something and put both years in one grouping like this. if {PRJC.PREndDate} in cdate(2013,01,05) to cdate(2013,01,26) then 'January' else if {PRJC.PREndDate} in cdate(2013,02,02) to cdate(2013,02,23) then 'February' else if...
  15. ginaburg

    date ranges by group formulas

    I changed my grouping to have the year group first but it still does not work. For the year group, it's giving me January 2014 data and the month group is giving me January 2014 data. I'm not getting any data for 2013.
  16. ginaburg

    date ranges by group formulas

    I am using crystal 11.5. I have a group that runs off of this formula which gives me hours by month for 2014 if {PRJC.PREndDate} in cdate(2014,01,04) to cdate(2014,01,25) then 'January' else if {PRJC.PREndDate} in cdate(2014,02,01) to cdate(2014,02,22) then 'February' else if {PRJC.PREndDate} in...
  17. ginaburg

    Subtotal Multiple Groups

    I just have a formula in the Supress (No-Drill down) in the Section Expert on each group Group Footer 1a {bPRDT.EDLCode} <> 1 (1 being Fed Tax EE) Group Footer 1b {bPRDT.EDLCode} <> 2 (2 being FICA Tax ER) I have a different formula on each group to limit to a particular tax. There is...
  18. ginaburg

    Subtotal Multiple Groups

    That would work great, but I forgot to mention that each of these tax types are already a group conditioned to pull each tax type and total the detail. This would be the deduction of taxes for all employees for a given pay period. Group 1 conditioned to Fed Tax EE Contribution Subject...
  19. ginaburg

    Subtotal Multiple Groups

    I am using Crystal version 11 I am trying to create a report that will subtotal multiple groups. Exapmple Fed Tax FICA Tax FUTA Tax Subtotal State TAx SUI Tax Subtotal I'm not sure if this is the right approach but I created a group for each tax type and put all my fields in the Group...
  20. ginaburg

    Keeping sections together

    Thank you, I didn't realize that keep together had a seperate function then the format section.

Part and Inventory Search

Back
Top