Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: LoriDurham
  • Content: Threads
  • Order by date
  1. LoriDurham

    how to make a number deafult length of 9

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

    Can i link universes from different databases in XI R2? please help

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

    How to setup default value in paramter which would change every year

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

    How to show one line in white and other in silver

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

    Need Help on where clause

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

    Need help on Where clause

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

    Need help with date selection criteria on Fiscal year,July month

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

Part and Inventory Search

Back
Top