Char 9 inside a chart and other questions
Posted on 2004-09-20
First, this is not a Database related Question, it is related to the GUI things in CR, but i couldn't find any better place to put this question.
also, I am using CR 220.127.116.11
I have the following case:
Have a one page report (we report) that contains a line chart, onChangeof a date field it plot some amounts, The dates are passed as YYYYMM to the report to keep the sorting correct, a recent request by the client was to put the format as YYYY-MMM or YYYY/MMM
I did the format, but the problem now is that the sorting of the data is alphapitaclly, and so it is wrong in real order, Meaning that 2003 APR comes before 2003 JAN,
Actually, the order is APR, AUG, DEC, FEB, JAN, JUL, JUN, MAR, MAY, NOV, OCT, SEP
I cannot use the "Specified order" because i am attching to the year (which happens to be dynamic - differs as the data differs) , so I added a specified number of Chars to the month name, to change its presedence in order, I tried some chars, and on CHR(9) it worked, I added 11 chars of CHR(9) to JAN, 10 to FEB, 9 to MAR, 8 to APR and son on and it worked perfectly, now they are ordered, and the Chart image is generated and retruned as rose.
Anyhow, when i moved to Production, the nightmare began, instead of invisible charachters, small squares started to appear in front of months, I am now sure it is a machine dependent thing, since it worked at the dev machine, but i don't know what is the factor in that.
If CHR(9) happens not to be an invisible character, then i need one that is < "A" and < "a"
Another thing, since this is a 1 page report, i wanted to remove the toolbar from teh report , and the page navigator, can anyone help me in taht too?
BTW: why Ex-Ex doesn't have the ability to attach pictures, that would have helped me alot in putting the question :)