Recent content by dadyswat

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

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...

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?

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...

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...

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...

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...

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"...

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"...

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?

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

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...