Search results for query: *

Ken I put the disclaimer in the Page Header and used the formula Remainder (PageNumber ,2) = 0 in the Suppress option of the section. It worked well and was getting the disclaimer on every other page. Only one small glitch, the disclaimer showed on the first page, but can live with that...

Pete I tried putting the disclaimer in GF1 and selected New Page Before and After, but it on put the disclaimer on the last page of the Supervisor (Group #1) group.

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

Thanks Bob! That's what I needed.

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

Pete I am going to need totals for each of the 12 months in the year. I was thinking along the same lines as you and am going to use 12 different formulas for totals of each month. Thank You for your suggestion!

No I'm not grouping by months because I'm not sure which date to use to group it by. For example a Begin Date of 12-19-13 might be before the Begin Parameter 0f 1-1-14, and the End Date is 1-3-14. These dates would needed to be counted in the January Group, but the Begin Date is not in January...

Charily I need to clarify more Of what I need to do. I am getting a count of days in the 1st half of 2014, then get the total days for each of the 6 months of the year. I.E. if the total days from 1-1-14 to 6-30-14 = 600 days, the monthly totals need to equal something like Jan - 150 days, Feb -...

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

Davest11, I'm using Oracle v 10g

Davestll, I did not have the SQL Expression enclosed in parenthesis, but when did enclose it I started getting "invalid identifier" - "INTAKE_PARTICIPANT"."PERSON_ID"

PeterDemitrov, I tried your sugestion of using the alias for the tables and copied your exact code into my SQL Expression, but it errored out with the message ORA00936: missing expression.

Davest11 I never was able to find a solution to this issue. From what I can tell, a SQL Expression works when the fields are in the same table, I was try to use fields from 2 different tables. I am not positive on that, but I could never get the correct data when using 2 different tables in a...

Ian It looks like the syntax of declaring the Holiday array was the problem. In the Report Header formula I changed it to: BeforeReadingRecords; DateTimeVar Array Holidays := [ DateTime (2013,05,27), DateTime (2013,07,04) ]; 0 In the Main Report formula it now reads: DateTimeVar Array Holidays...

Ian I tried your suggestion, but it now it highlights the "=" sign and gives the error "An assignment is expected here". I tried For i = 1 to Count({@Holiday}) using the formula from the report header, but it gives the same error.

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

Ian, I have to try a different approach, I don't think the what I was trying was going to work. I was going to try something different, below is the data. Is it possible to give a value to the first instance @Pass-Fail <> @shared AIT? @Record # --- @Activity Date --- @Pass-Fail ----- @shared...

fisheromacse, Ian I edited the formula and it no longer errors out. I ran the report and it did not change the results of the data, it is still displaying as shown below; Decision Date ---- Activity Date ---- Status Code ---- @Pass - Fail 1-22-13 -------- 1-23-13 --------- COMPLETED ------ Pass...

Ian I do have a group for the @Activity Date field. I tried incorporating the changes you suggested, but I errors out with "A Boolean is Required Here" at the line in formula that reads if PassFail := "Pass" or PassFail := "" I have been trying a few things, but can't get around that error in...

Ian I tried rearranging the order of the formula but it did not present the data the way I need it. Below is what I am trying to accomplish with the formula; Current Data Display; Decision Date ---- Activity Date ---- Status Code ---- @Pass - Fail 1-22-13 -------- 1-23-13 --------- COMPLETED...