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!

Register Log in
  • Congratulations Chriss Miller 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: EMVIC
  • Order by date
  1. EMVIC

    Installing BO 5i

    Hi guys,, Can anyone pls assist me. I just completed installing BO 5i on my machine and it installed successfully. When I try to lunch BO, it brings out a user identification box, requesting for my username and password. Since I did't enter any during the installation, what should I do? I have...
  2. EMVIC

    Range Grouping

    Thanks it worked
  3. EMVIC

    Range Grouping

    Thanks Ryan7's method worked
  4. EMVIC

    Range Grouping

    Could someone pls assist? Below is snap shot of my data EnrolmentDate DOB Age_Range 30/09/1990 12/10/1961 09/02/1991 14/09/1970 18/07/2000 17/02/1972 17/03/1996 19/07/1975 My intended output is to have a column named Age Range which will be grouped based on {EnrolmentDate-DOB}. How can I...
  5. EMVIC

    Range Grouping

    Could someone pls assist? Below is snap shot of my data EnrolmentDate DOB Age_Range 30/09/1990 12/10/1961 09/02/1991 14/09/1970 18/07/2000 17/02/1972 17/03/1996 19/07/1975 My intended output is to have a column named Age Range which will be grouped based on {EnrolmentDate-DOB}. How...
  6. EMVIC

    Change Sum in Crosstab to Count

    thanks, it worked.
  7. EMVIC

    Changing Sum in Crosstab to Count

    Hi, I'm new to BO and would appreciate any assistance to help me get through this first hurdle. I'm using BO 5.1 and Db is Access. Below is a sample data I used. id Type Region 233 Lamp West 334 Plug North 5 Bulb South 5 Frame West 55 Lamp East 888 Bulb...
  8. EMVIC

    Change Sum in Crosstab to Count

    Hi, I'm new to BO and would appreciate any assistance to help me get through this first hurdle as I've always used excel in producing my reports. I'm using BO 5.1 and Db is Access. Below is a sample data I used. id Type Region 233 Lamp West 334 Plug North 5 Bulb South 5 Frame West 55 Lamp East...
  9. EMVIC

    Converting UpperCase to title case

    Appologies for not supplying the detailed info. CR version: 8.5, DB : SQL 2000. It seems CR8.5 doesnot recognise Propercase. Is there any other way around it.
  10. EMVIC

    Converting UpperCase to title case

    Can anyone help. I have column called Title and contains titles in Uppercase eg TIT/MR, TIT/MS, TIT/PROF. i used mid('TIT/MR',5,99) to get rid of TIT/, my problem is how to convert the MR or MS to Mr or Prof, combined with the formula
  11. EMVIC

    Using Case Expression

    thanks for your assistance. it worked
  12. EMVIC

    Using Case Expression

    Hi I’m very new to Crystal reports and have been faced with this problem. The script below is as I would normally define it in SQL to restrict the amount of data required for my report using case statement Case when (enrolment_date between 'April 1, 2003' and 'March 31,2004')then 'Y03' when...

Part and Inventory Search

Back
Top