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 dencom 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: Chuku
  • Content: Threads
  • Order by date
  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, 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...
  3. 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...
  4. 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...
  5. Chuku

    Assign leanest value

    I have two types of processes like A and B. say, If there are 5 processes totally Sample data: Process Type RecoveryTime Proc1 A 4hours Proc2 A 5days Proc3 B 8hours Proc4 B 3days Proc5 A 12hours I need to...
  6. Chuku

    How to set "Can grow" for a sub-report conditionally

    Hi, How can we set "can grow' option conditionally for a sub-report? Thanks in advance...
  7. Chuku

    Concatenate

    hi, I need to concatenate the below data. For eg This is how the original data looks like Owner A B Expert C Builder D E and so on. where Owner, Expert and Builder refer to ROLES and are placed in the GH and A,B,C,D and E are from a formula and are placed in the details section...

Part and Inventory Search

Back
Top