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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Chuku

  1. Chuku

    Pull data based on condition

    Hi, I need to display Operator Names in my report. From the front end, this field can be created based on Role or User Name. When created by UserName, entries are created in Worklog.AssignedID and when created by role this field is null. For Role based, entries are created in LoanOper.OperID...
  2. Chuku

    Pull city names based on condition

    hi Peter, Thanks for your reply. I am looking to pull the values in crystal using sub reports. My idea is to implement each condition in a separate sub report. Is this possible.
  3. Chuku

    Pull city names based on condition

    Hi, I need to pull city names from property table. Property_id in property_table is mapped to prop_id in worklog_table. If prop_id is not null then I need to pull the city name If prop_id which is present in a worklog_table is null then I need to pull the city name but based on a field...
  4. Chuku

    How to create a single database connection for two different databases in the same server

    Hi, I have a database ( say master) and another database ( say reporting) which are two different SQL databases present in the same server. Now I need to add tables from both of them to pull data into CR. But the requirement says I need to use a single DB connection. How do I do that? One way...
  5. Chuku

    sub reports to main report

    Thanks Madawc.. That helped!!
  6. Chuku

    sub reports to main report

    Hi, I have two subreports in which there are fields which need to be displayed in the main report. Say, A is the result which is obtained from a formula field in 1st report B is the result which is obtained from a formula field in 2nd report Now I need to compare A and B and display the...
  7. Chuku

    Assign leanest value

    Lbass, spacing was the issue.. got it now.. Thanks alot!! you are the BEST!!
  8. Chuku

    Assign leanest value

    Lbass, I was able to get the minimum value. But when the minimum value is ">7 Days and < 60 Days" , it displays 0.00. It is displaying correctly for other data
  9. Chuku

    Assign leanest value

    Thanks for the advice.. I tried the above way. But it is displaying a value of 0.00 for the last formula
  10. Chuku

    Assign leanest value

    The below are the ONLY possible values. 3 Days 4 Hours NULL 12 Hours 7 Days 24 Hours > 7 Days and < 60 Days
  11. Chuku

    Assign leanest value

    Below is the sample data from the field, 3 Days 4 Hours NULL 12 Hours 7 Days 24 Hours > 7 Days and < 60 Days
  12. Chuku

    Assign leanest value

    Lbass, No. The field just has days and hours.
  13. Chuku

    Assign leanest value

    Lbass, I have links to the other table. Also the recovery time is a string field. Do I still need to convert the days to hours ?
  14. Chuku

    Assign leanest value

    Lbass, I will explain in detail below In my tables, there are 2 types of processes, Business and Baseline. Business process has a recovery time while Baseline process do not have a recovery time. They need to be related to their Business process to have a recovery time (which is present in...
  15. Chuku

    Assign leanest value

    Sorry but how do i create a formula to show the lower of the two values
See more

Part and Inventory Search

Back
Top