Search results for query: *

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

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

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

Thanks, that worked perfectly.

Thanks for your quick reply! However, when I try it out, I get an error message that says that my field, {VW_CATALOGUE.MAKER}, following the ubound function, needs to be an array . The following is what I input: whileprintingrecords; stringvar output:=""; stringvar array...

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.