Search results for query: *

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

Ok I came up with an idea If ?Paramter = "*" then thresholdfield = thresholdfield else thresholdfield = ?Paramter , any other ideas?

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.

Thanks a ton it works

thank you so much for quick response, but here I dont have any common field among different lines, everything is in same detail section with different fields.

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

I will try them again now LB, thanks so much again. I will let you know.

Great Idea, thanks a TON

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

Please Group on Date and Take Max(fields,datefield) and place them in the group footer. You would get the latest recent data. Thanks, Lori

LB sorry if I was not clear When is use your selection criteria DATE({Command.APPDATE}) in date({?Year}-2,7,1) to maximum(lastfullmonth) I did group on APPDATE on report, I get data from july09 to july 07. Also your right when I run a report for FY 2010 (July 2009 to June 2010) in August of...

any ideas friends how to split 200908 accordingly in the above formula?

Any ideas friends?

Blom Many thanks, one final question how to we again break this paramter in where condtion. Year(Date)*100+Month(date) has worked, but getting error for cast(Year(Date)*100+Month(date) as varchar(6)) Below is where condtion where I want to break Year(Date)*100+Month(date) accordingly WHERE...

I am getting data from July 09 to July 07 with the above selection criteria, I will example with data which might be helpful If i run the report today I get data Amt People July 09 2000 12 If I run in Sept Amt People July 09 2000 12 Aug 09 350 2 so on If I run...

Blom thank you I have got the where clause sucessfully. I will let you know once i get to the logic, you been a great help. Thank you Lori

Thanks LB, I will try your logic and will let you know. You been a great help Lori

Skip How can we format the date field into yyyymm, any ideas ?

LB WHEN i use {Table.date} in date({?fiscalyear}-2,7,1) to lastfullmonth I get error showing a datetime is required here on lastfull month