Recent content by auylox

I don't believe it is the font. I use the same font with those characters in other locations. If it were a font, I wouldn't expect the replace function to work.

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

Please disregard. I resolved it by reversing the links between two of my tables. K

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

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

Well, thank you for looking into it. I'm starting to wonder if it might be something to do with Unicode support in my ODBC driver (or lack thereof). KB

Lbass, Courier New (As I have it) doesn't have a combining low macron. Also, I don't have much flexibility with fonts as I am designing labels that fit into a signage program. DejaVu Sans seems to be the most comprehensive (I have many non-latin characters) font that is similar enough to the...

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

Hi lbass The footer contains a design element that I only want to appear in between group 3 sections. I've figured out how to suppress it if it is the last group 3 within a group 2 but if group 2 continues on the next page, I don't want the design element to show up at the bottom the page. I...

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

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

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

Thanks, That was perfect.

In this case, is it possible to change on which field the data is grouped based upon the field that is chosen in the parameter {?Choose} ?

Thanks LB, That's kind of what I had figured out already. And it seemed so messy. But, with a new day brain, I realised that because I wasn't using value lists I could also just do as follows: ( select {?Choose} case "By Group" : {VW_GROUPS.GROUP_NAME} like {?Choice} case "By ID Number" ...