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 Mike Lewis 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
  • 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

    Thak you so much!! It works for me
  3. 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...
  4. 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...
  5. 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...
  6. 42894

    Need Help to get right data from Subreport

    Hi, For example, ID Address State Country A_Owner B_Owner 101 45, salem CA USA ABC-123 DEF-345 DEF-345 XYZ-123 102 65, jam PA UK XYZ-000 LMN-222 XYZ-000 Now i need the...
  7. 42894

    Need Help to get right data from Subreport

    Hi, Thanks for your reply. But i need "All B_Owner" as a separate column. How do i get that? Please reply Thanks Aatman
  8. 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...
  9. 42894

    Need Help to Create Formula Field

    Thanks for your reply. But in every record i have A Owners and B Owners fields but both have multiple values in single record. A1,B1,C1 all values are under single record. Other record might be have B1,A1,H1 for A owners. Same for B Owners field. So i don't understand how to do if more than 2...
  10. 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...
  11. 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