Friends I have a number and I am converting this to chat to conc with other stirnf field.
But the when i convert the number it strips of 0's before number
suppose number is 001234598 when i convert it to string it strips of 00 and gives me 1234598, any way to fix this?. THanks in advance
Lori
Friends,
I am trying to connect a universe to my existing one from different data base, but I know I could have only one connection. Any turn around for this?.I am using XI R2
Thanks a lot,
Lori
Hello,
I need to give a option in CRXIR2 report in a way that A user can enter the value in paramter or if they dont enter default value should be the current value in that field. Every year the value in this field changes, it has only value. Any ideas how to do that?. Thank you.
Lori.
Friends I have a small question,
My sample data is like this
just one detai section and one group.
IN detail section my data is like this
OLD new
own field1 field2
rent field2 field3
buy field4 field5
other field6 field7
How can implement that one...
WHERE DATE(LPAY.ADDED_DT) between date( '07' || '-' || '01' || '-' || CHAR(YEAR(current date )))
and (((DATE(current date) - Day(DATE(current date)) day)+1 day)) - 1 day
Above is my where clause which works fine, I alwuas wants to get data from July to June and chnages next year
But problem...
Friends
I want to write a where clause in such a way that
I am getting all data from July(Current year) to July(next year) suppose by the end of year I have amount >0 then I need to get data
July(Previous year) to July(Current year).
DO i need to write a IF else statement in Where statement...
Hello all, I am new to Crystal and I have a report where it looks for Fiscal year and Fiscal month
NO matter when I run the report Report should start with July
Suppose I run the report on July09 I need to get data only for July 09 and if report is scheduled in August then I need to get data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.