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: *

  • Users: dazum
  • Content: Threads
  • Order by date
  1. dazum

    page of text alternating after each page of data

    I am using CRXI. I would like to have a page of text (a disclaimer) aleternating after each page of data. In other words, page 1 would have the data, page 2 would have the disclaimer text, page 3 the next page of data, page 4 the disclaimer text again, and so on. The plan is to print the report...
  2. dazum

    Like Statement for only Upper Case String

    I am using CR 11 I am trying to create formula that will flag a field if it has uppercase GS in the field name Ie. the formula reads as follows: If {Intake.Intake_Name) like "*GS*" then "Y" This works if the field name is (GS)Smith, but it also works if the field name is Stallings(because of...
  3. dazum

    Monthly Total Days in a Date Span

    I am using CR XI I would like to find the simplest way to get a monthly total days within a year's span For Example I would like to get the total number of days in January 2014 between the Begin Date and End Date Begin Date End Date 12-9-13 -- 7-22-14 (need to show 31 days...
  4. dazum

    Error when trying to run Working Days Between 2 Dates Formula

    I am using CR XI In the Working Days Between 2 Dates Formula (see below), when I check the formula for errors, in the part of the formula that accounts for a holiday on the line: For i := 1 to Count (Holidays) an error occurrs "A field is required here", and the variable Holidays in parenthesis...
  5. dazum

    End Formula Calculation When Condition Is Met

    I am using CR XI In the below formula, I would like the formula to stop the calculation after the stringvar PassFail result is either "Pass" or "Fail" and continue if the result equals "AIT". stringvar PassFail; if CDATE({@Activity Date}) <= DateAdd("d",1,CDATE({INTAKE.DECISION_DATE})) and...
  6. dazum

    Date Parameter pass from main to sub report

    I am using CR 11 I have a Begin date parameter in the main report used for a field called Decision_Date. I use a sub report to get a field called Status_Date. I want to get any Status_Date that is >= the Decision_Date from the main report. In order to get get the correct Status_Date, I also have...
  7. dazum

    SQL Expression - max date

    I am using CR 11 and trying to create a SQL Expression to get a maximum date for a person_id, but the field for the person_id and the field for the date are in different tables (i.e. the Person_Id is in the Intake_Participant table and the Decision_Date is in the Intake table) Below is what I'm...
  8. dazum

    SQL Expression that gets minimum date that is &gt; than other date

    I am using CR XI I would like create a SQL Expression to get a minimum Legal Date that is greater than the Case Begin Date for each individual case. The report is grouped by Case Id. Here is how the data currently shows; (Group #1 - Case Id) Case Id - 1009699 Begin Date --- Legal Date...
  9. dazum

    Median value not correct because of duplicate records

    I am using CR XI I am trying to use the Median function in a running total, but I am getting duplicate records in my report that is throwing off the value of the Running Total Median which is in the Report Footer. I've tried some things to elimnate the duplicate (i.e."Select Distinct Records"...
  10. dazum

    Need formula to show max date that is less than another date

    I am using CR11. I need a formula that lists only Assement Dates that are less than than the Case Status date.(see example below) Group 1(Case ID) Details Case Status Date Assesment Date 2-15-11 3-4-11 12-9-10...
  11. dazum

    Formula to Show Date when it falls within a Group Date Range

    I am using CR11 and have a report that is grouped by each Office Visit Date. I have a Follow up Call dates in the report also. The data is showing up as shown below: 3-31-09 (Grouped Office Visit Date) 6-17-10 (Follow up Call dates) 6-30-10 8-30-10 1-3-11...
  12. dazum

    Conditionally Suppress Text Box Drop Shadow With Formula

    I have a date formula in the Group Header of a report that shows if the date falls within the date parameters. I put the date within the text box and conditionally made the background of the textbox CrSilver if the date formula was not null. It worked by using the below formula: If not isnull...
  13. dazum

    Multiple Dates Within Date Parameter Formula Not Working Completely

    I have a formula that I would like to show information related to a date as long as the date falls within the begin and end date parameters. I have 3 dates in the formula and it works for the first 2 dates in the formula, but if the 3rd date falls within the date parameters it's data does not...
  14. dazum

    &quot;Equals&quot; Part of Formula Not Working When Comparing 2 Dates

    I have a 3 part formula that I am hoping to get the minimum Legal Date that is greater or equals to the maximum Start Date. The formula works OK until it get to a record where the minimum Legal Date is equals to the maximum Start Date then no date shows. Below is the 3 parts of the formula...
  15. dazum

    reoccurring date formula

    I have a formula that calculates a meeting date that reoccurs every 180 days starting with the trigger date. Below is a portion of the formula; If currentdate - {@trigger} <= 180 then dateadd("d", 180, {@trigger}) else if currentdate - {@trigger} > 180 and currentdate - {@trigger} <= 360 then...
  16. dazum

    shared variable from sub report not working when section suppressed

    I have a sub report that has shared variables that are used in the main report. Many of the sections of the main report are suppressed just to show totals. If I suppress the section the sub-report is in the shared variable from the sub do not work in the main report. If I don't suppress the...
  17. dazum

    Minimum Function in Running Total

    I have two dates that need to be compared. Below is the data; Person ID Start Date Legal Date 609486 10-23-10 3-25-11 609486 2-1-08 10-25-10 609486 7-16-07 4-6-09 I need to get the next Legal Date (10-25-10) that is greater than the...

Part and Inventory Search

Back
Top