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 John Tel 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: 42894
  • Content: Threads
  • Order by date
  1. 42894

    Need help to change format of Date in Chart

    Hi, I am using CRXI. I am working on 1 report and i have to change the format of Date in Chart. In Chart dates are displaying like Jan-2008 but i want to see 01/08. I put Close_date field in my formula ConvertToTimeZone({table1.Close_date}). I used this formula in my chart.I have done...
  2. 42894

    Need help to concatenate the values

    Hi, I am using CRXI. In my report, the output coming like this. ID Name Users Div1 Div2 Use 10 Smith XYZ-123 Info Devlopment 30 10 Smith ABC-000 Search Prod 40 10 Smith LMN-234 Med Info 100 Now i need...
  3. 42894

    Need help to filter records from parameter

    Hi, I am using CRXI. In my report, i have 3 parameters. State, Country and Zipcode parameters. Now i need to exclude the records where State=CA, Country=USA and Zipcode=34009. For example, ID Name State Country Zipcode 10 XYZ CA USA 29003 20 ABC...
  4. 42894

    Need help to calculate business days

    Hi, I am working on CRXI. We have database where we have all the details for report. When report was creat(creat_time), update(update_time). We provide ID to each report. Now i need one report to track these reports. I need to calculate the business days for when report modified last. For...
  5. 42894

    Need Help to get right data from Subreport

    Hi, I am using CRXI. I have 2 tables Item1 and Item2. In Item1 i have column A_Owner and in Item2 i have B_Owner. Both field have multiple values per ID. In my report i need all coumns where A_Owner and B_Owner are same. I add A_Owener = B_Owner in record selection formula. But now i need to...
  6. 42894

    Need Help to Create Formula Field

    Hi there, I am using CRXI. I want to create a formula field. Below are details. For Example: I have 2 fields and values of that fields A Owners B Owners --------- ---------- A1 A1 B1 B1 C1 I want to add 1...
  7. 42894

    Need help to filter records from condition

    Hi, I am using CRXI. I have 2 fields and values of that fields are as below: A Owners B Owners -------- ---------- ABC-LMN XYZ-LMN XYZ-LMN ABC-LMN DEF-LMN I need A Owners where name contains *LMN* but if and only if same value(name) is...

Part and Inventory Search

Back
Top