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 SkipVought 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: *

  1. TXP007

    Include Column Headings with Query Results

    The following subquery successfully identifies duplicate description table entries in an Oracle database. The result of this query is automatically transferred to the business functional team (customer) for them to fix through the front end application (Oracle EBS). Select...
  2. TXP007

    Select All types if one of the types is...

    CoSpringGuy, That appears to be working. Thank you!
  3. TXP007

    Select All types if one of the types is...

    hilfy, My filter is on Attorny fees. If a customer has Attorny fees print ALL classifications for that customer. Sorry if this wasn't clear in my original post. TXP007
  4. TXP007

    Select All types if one of the types is...

    I am running CRXI against SQL server tables. I have 2 tables joined on Cust_num. Customer (table) Cust_number Cust_name Classification (table) Cust_number Class_descr Class_amt Customer (table with data) 1 Bob Jones 2 Rob Tillman 3 John Phillips 4 Bill Fargus 5 Jim Sellers Classification...
  5. TXP007

    Dynamic Year Headings

    Thank you for your reply MCuthill. I apologize for the lack of detail in my question. You are correct. "FY10" would be for 2010, "FY09" for 2009... so on and so forth. FY = Fiscal Year I only have one BUDGET_YEAR to work with. This year it's 2010. We are preparing our budget for the...
  6. TXP007

    Dynamic Year Headings

    I am using CRXI against SQL server tables. I have a SQL data element called BUDGET_YEAR. It is a string value (e.g. 2010). I want to derive 3 coulumn headings from this BUDGET_YEAR as efficient as practical. My goal is to limit the amount of formulas for each heading. The column headings I...
  7. TXP007

    Rounding Shared NumberCur Variables

    Actually, I meant CurrencyVar. I was going back and forth between that and NumberVar trying to figure it out. As usual, you are correct! Thank you, TXP007
  8. TXP007

    Rounding Shared NumberCur Variables

    Hello, I am using CRXI against SQL server views. I have a SharedCur variable defined like so... Shared NumberCur groupB_expected_dollars := {@f_Shared_Total_Pay_Amount}*{@f_Group_Availability} How do I round my SharedCur variable to the nearest whole dollar? Thanks for the assistance. TXP007
  9. TXP007

    Using command parameters

    I am using CRXI against SQL server tables. I am using an ODBC command as my data source, as -LB suggested in thread767-1523885. It seems to be working correctly. Now, I am trying to figure out how to use the parameters using the command option. Let's say I have 2 tables: Hair and Sales. The...
  10. TXP007

    Maintain left join when selecting from right table

    I am using CRXI and SQL Server 2005 tables. I have 2 tables: Month and Sales. I am doing a left-outer join (Month ---> Sales). This allows me to see all months even when there aren't any sales in the month. I want to maintain my left outer join when I select against a data element from the...
  11. TXP007

    Grouping Question

    I'm using CRXI. I have 1 SQL server table. Sales (invoice_num, customer_num, customer_region, sale_price) I want a sales summary report by customer_region, but I want to show all regions, even when there aren't any sales for a given region. Is there a way I can define my groups (regions) and...

Part and Inventory Search

Back
Top