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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dadyswat

  1. dadyswat

    Multiple If Statements

    Hey thanks guys, I've got it figured out and its giving me what I need. You're the best!!
  2. dadyswat

    Multiple If Statements

    I'm trying to pull only values above a certain value. I'm getting errors on the statement in general. Record selection formula looks like this: {OB_0001.vccid} in [22, 32] and {AX_0001_B.EndDate} in {?AXStartDate} to {?AXEndDate} and {IVUEAPPVCCNODEPATHS.appid} = 1 and {IX_0001.CASE_STATUS} in...
  3. dadyswat

    Exclude Holidays and Weekends

    By the way dpatrickcollins, you are correct it was dropping the holiday dates in addition to the row inflation. The dates.date >= work.startdate and dates.date <= work.enddate you're referring to, is that a record select clause or a link to the table?
  4. dadyswat

    Exclude Holidays and Weekends

    Thanks for all the help. The report is available but I'm going to keep going to get the Date table working. Just makes better sense in the long run. I think part of the row inflation problem is the fact that the data is retrieved from a view that asks for the max audit time with certain...
  5. dadyswat

    Exclude Holidays and Weekends

    dpatrickcollins Your solution worked. Yes, it will be a little cumbersome hard coating all the holidays in for the next few years but I need to get the report running and available. synapsevampire I don't want to give up on the table for the holidays as its something I can use with MS Access...
  6. dadyswat

    Exclude Holidays and Weekends

    Here is the section from the record select in Crystal: {IX_0001.EMP_TIER} <> "A" and {OB_0001.vccid} in [32, 22] and {AX_0001_LUT2.id} = 6 and {AX_0001_LUT.id} = 5 and {IX_0001.NON_UM} <> "Y" and {IVUEAPPVCCNODEPATHS.appid} = 1 and {IX_0001.CASE_STATUS} like "C*" and {OB_0001.createtime} in...
  7. dadyswat

    Exclude Holidays and Weekends

    Ok, I think I know where the problem is. First I've simplified the report. Second, the reason things aren't working properly is these are datetime fields. When I tried joining tables through Query Analyser the results where all wrong. And direct query against the dates table the results where...
  8. dadyswat

    Exclude Holidays and Weekends

    Right, I have to add that clause again, I'll been tied up on a couple of other things. When I linked the tables I got no return. SELECT DISTINCT "AX_0001_B"."refobjid", "IX_0001"."CLAIM_NO", "AX_0001_LUT"."valuetext", "IX_0001"."NON_UM", "AX_0001_LUT"."id", "OB_0001"."vccid"...
  9. dadyswat

    Exclude Holidays and Weekends

    OK, here we go. First I'll post the Query from Crystal and then the sql Data. The next post I'll add the Holiday date formula. Looks like the word wrap makes it a little messy. This works fine but doesn't correct for the holidays. SELECT DISTINCT "AX_0001_B"."refobjid", "IX_0001"."CLAIM_NO"...
  10. dadyswat

    Exclude Holidays and Weekends

    Just let me clarify want you're recommending. You're saying drop the variable d3 and them add the selection criteria in the formula area of the select expert? Would it make a difference that these are datetime fields vs date fields?
  11. dadyswat

    Exclude Holidays and Weekends

    OK, I gave this a try and the duplicates are back??
  12. dadyswat

    Exclude Holidays and Weekends

    I'm currently working on a report in V10 that needs to exclude the holidays and weekends. I've created a new table in SQL Server 2000 and holidays =1 all other days =0. I used a formula this formula in testing and as long as there is only one holiday in the reporting period it seems to work...
See more

Part and Inventory Search

Back
Top