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 strongm 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: auylox
  • Content: Threads
  • Order by date
  1. auylox

    Unable to display certain punctuation characters from a memo field

    Hello, I'm using CR2016 Oracle 11.2 connection via ODBC I'm trying to include a memo field in my report, but the following characters are being interpreted as question marks: ’ (alt+-146) “ (alt+0147) ” (alt+0148) – (alt+0150) … (alt+0133) I can replace the question marks using formulas...
  2. auylox

    Select Case on a Formula field not returning all expected entries

    Hello, CR 2008 Oracle 11 Windows 7 I'm having problems with a selection formula not returning all of the entries I expect when I select based upon a formula field. Using the folowing selection formula: {VW_CATALOGUE.ID_NUMBER} like {?Data} where {?Data}= "2956/201*" returns three lines...
  3. auylox

    Conditionally Duplicating Records in a report

    Hello, CR2008 Oracle 11g Using this FAQ I'e been trying to create a report that has repeating labels based upn a number field if an isnull condition is met. Here is my selection formula: if isnull({VW_LOAN_ITEMS.ID_NUMBER}) then {VW_LOANS.TOTAL_ITEMS} >= {VW_CATALOGUE.MKEY} and (select...
  4. auylox

    Unicode combining character not displaying correctly

    Hi, I am running a report on string fields that contain Unicode combining characters. I'm having a problem getting certain characters to render correctly. For instance, consider the Latin small letter g when combined with a combining macron below (U+0067;U+0331). Using the font DejaVu Sans...
  5. auylox

    Supress Group Footer if last section on page

    Hi, Using CRXI on an oracle database I'm trying to figure out how to suppress my Group Footer 3 when it is the last section on a page. I've tried to do a running total by using numbervar count:=count+1 in each group footer 3,2,1 and Page footer and resetting it in each page header but when I...
  6. auylox

    Supressed fiels based upon another conditional suppression

    Hi, I'm using CRXI to report on an Oracle 9i database. I'd like to know if there is a way to suppress a field based upon whether or not a second field is suppressed. For instance, I have {field 1} that is suppressed if duplicated and I would like to set {field 2} to suppress if {field 1}...
  7. auylox

    Convert relationship to an array

    Hello, Is there any way to convert a one to many relationship to an array for a formula field? Thanks
  8. auylox

    Selecting a parameter to use

    Hello, I am using CR XI to access and an oracle DB. Is it possible to have a user select a parameter on which to run a report? What I have right now are two reports that are identical except for the parameter that is used to select records. I would like to amalgamate the two reports so...
  9. auylox

    Omitting Question marks in strings

    Hello there, I'm trying to figure out a way to remove a question mark from a string. I'm finding this hard because the question mark is a wildcard in formulas. Is there any way to get around this? Thanks, K
  10. auylox

    Rearranging a string field

    Hi there, I am trying to rearrange a string field that is in the following format: LastName, FirstName; LastName, FirstName; ... Where there is no limit on the number of names. To show: FirstName LastName, FirstName LastName, ... Is this possible? Thanks for any help.

Part and Inventory Search

Back
Top