Search results for query: *

Thanks! That 'sort-of' works, however now I have a blank page following the valid one. I have checked every section, am I missing a setting somewhere?

Hello All, In CR 8.5 how do you suppress pages after the first (either on purpose, or if a field is valued/NULL)? Thanks for any help!

Hi All, How do create a field to display 'continued from Previous Page' if multiple records produced in the Detail section go over one page (CR 8.5) Thanks for any & all advice!

HI All, How do you omit characters from the left or right of a given string field? Ex: ABC-DEFGHI omit 'ABC-' = DEFGHI I understand the LEFT & RIGHT functions, but I guess I need it to work in reverse - instead of 'keeping' a number of characters from the left or right, I need to omit them...

Hi All, I have location names in a format with consistent delimiters, but varied names sizes. Example: ABC-111-DEF-1 ABC-22-DEF-2 The point is how to eliminate everything on the left of the the 1st (or leftmost) hyphen '-', including the hyphen itself, despite the varied lengths. i.e...

Hi All, How/Can you insert a watermark graphic into a CR 8.5 report? Thanks for all help!

Thank you all for your solutions!!!

Hi All, I have a field which contains strings of letters and/or numbers: Examples: Hospital-Unit-Room-BedNum or Hospital-Department Hospital-ICU-1234-1 Hospital-ICU-1234-2 Hospital-TELE-4567-A Hospital-TELE-4567-A Hospital-Laboratory What I need...

Hi All, I have three numeric fields to work with: BirthDay BirthMonth BirthYear How can I utilixe them to calcuate a persons age in Years, or if younger, months or days? i.e. the result will appear either: 21 y 7 m 18 d Thanks for all help!

Hi All, I have a two issues. In 8.5 I have a report with a page Header split into A,B,C, & D. I would like to have B & C not repeat on the next page if the details info extends beyond one page. By the same token, how do display/print a "continued on next page" if the details section extends...

Great! Sorry I misread as a formula, my bad... Thanks a lot for your help!

Is this formula placed in the Suppression condition (of the Details Section) or Record selection for the report? Thanks!

Hi All, I have a set of fields in the Details section of my report (CR8.5) and it is displaying exact duplicate information twice. Example: ---*-------------------------------------------------- D * Field1 Field 2 Field3 * ---*-------------------------------------------------- D *...

Hello All, I have a stored procedure which outputs two strings in a field on my report: string 1 = "Acute Medical" string 2 = "Behavioral Mngmt" So I need to total the number of instances of both (done). However, how do I total/count each individually: "Acute Medical" = XX (times occurred)...

Totally Awesome Dave! (Forgive my 80's vernacular) I don't suppose you can walk through how it works? Thanks again!!!

Hi all, I asked a similar question last week of how to change a string of items into a list format with delimiters of ';'. The answer which proved to work was: join(split({Field.SummaryLine},";"),chr(13)) Very Cool, still don't understand the how/why of it, but that's for a later...

HooYah synapsevampire !!! That's it ! Sprinkle a little 'Can Grow' onto the field and I got what I needed! As a humble and final request to this isse, would you mind explaining how the formula works? Many great Thanks!

Well, That's close, but I need everything from the left to the ';', then everything from ';' to ';', and so on... Go fish! :)

Hi, How do I out put a list from a string field with the criteria (length of text) determined by a delimiter of a ';'? Ex: A for Apple; B for Banana; C for crouton Output: A for Apple B for Banana C for Crouton I am planning to have this in the Details section of my report. Thanks for all...

I am creating a Census report for a hospital. The report needs to display every room for a floor and patient info for the patient occupying the room. However if the room is unoccupied, the patient info area of the report must be empty space for 'write-ins' for admissions after the report is...