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 Rhinorhino 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: trenttc
  • Content: Threads
  • Order by date
  1. trenttc

    Conditional Feld Size & Total Page Count

    Group Footer text field can be populated with from 0-6 lines. I want to count the number of non-blank lines in Group Footer, so the total of Group Footer + Detail lines can be calculated before TotalPageCount is calculated. The problem is that when the Group Footer lands near the bottom of the...
  2. trenttc

    load data blob mysql

    Mysql has 'load data infile' to load a list of file names into a table. I want to load all the blob files from a directory into a table, not just names.
  3. trenttc

    Report Header Subreport

    I have a report header with a subreport in it. I want to hide the report header but run the subreport to get shared variable values that I print in the page header. If I Hide(drill-down OK) the report header, I don't get the subreport values. Can I get the subreport values and hide the report...
  4. trenttc

    Cross Tab Percentage

    The Cross tab column is date and row is category. The summarized fields are A sum, B sum, and A+B sum. I want the summarized A sum and B sum to show a percentage of A+B sum, not show a percentage of all A sum or B sum. CR 11 Date 1 Date 2 Category 1 A sum% A...
  5. trenttc

    Link to Nowhere

    I can group by C.ID, then by P.SKU after parsing and reformatting P.ID_etc. I want to group by C.Name, then by P.SKU. The problem is that I can't just add a group by for C.Name (can't create an initial link between C.ID and P.IDs to allow grouping by C.Name). How do I build a list of IDs so I...
  6. trenttc

    Keep Us Together On The Same Line

    I want to group by code# (t-shirt) and then group by sku (size), printing the quantity ordered for all skus within a code# all on the same line. Grouping by sku puts sizes in the proper order since the lowest sku number always corresponds to the smallest size. Is there something I can do without...
  7. trenttc

    Insert Into Inner Joins

    The select works fine. Adding the insert into causes it to hang. How do I get the results into a new table? INSERT INTO table3 ( id,lastn,firstn,addr3,state) SELECT t1.id,t1.lastn,t1.firstn,addr3,t1.state FROM cust t1 INNER JOIN( SELECT lastn+firstn+state+addr3 AS dupmatch FROM cust...
  8. trenttc

    Sum with Inner and Left Joins

    I want to change this so orders.total is a sum by order.id Something with "sum(orders.total) as total". How do I change this? select c.name from cust c inner join orders on c.id=orders.id left join flags on c.id=flags.id where orders.order_date > '1/1/2007' and orders.total>20 and...
  9. trenttc

    subquery question

    I want all US customers (cust.id is unique) who have spent > $30 from 1/1/06 to 12/31/06. Invoice subtotals and dates are from invoice table (cust.id is 1 to many to invoice.id). I also want to exclude any cust records with flag=1 or flag=2 in flag table (cust.id is 1 to many to flag.id). How do...
  10. trenttc

    Sensitive to Case

    How can I do comparisons for case-sensitive data (a-z) on a case-insensitive database? Creating a new database is not an option. ASA 8.0
  11. trenttc

    Aw Hex

    Anyone know the syntax for hex lowecase a-z in patindex? This isn't it: SELECT @patindex = PATINDEX('%'+'[\x61-\x7A]'+'%',@word);
  12. trenttc

    Case-Sensitive

    I want to test for case-sensitive data on a case-insensitive database (ASA 8.0). I can't create a new database. I connect from my XP box using dbisqlc, passing cs 'cp850'. Further, I try: begin Declare @Temp VarChar(50); Set @Temp = csconvert('UPPER CASE Words only','cp850'); Select...
  13. trenttc

    Default Value index field

    T1.txt1 links to T2.txt1 to print the T2.txt2 value. Sometimes T1.txt1 is empty when there should be a default value of 'abc'. Can I set a default value on an index field so when printing I can print the corresponding T2.txt2 value? I would like an option like: File>Report Options>Convert...
  14. trenttc

    Grouping and Sorting

    Within the primary (category) group, I want a sum qty per SKU. I want to print by category, then the SKUs in sum qty order.
  15. trenttc

    Too many links

    Table1 id and Table2 id are linked to Table3 id, which has a needed text field. While printing on the same line, Table1 id and Table2 id need to lookup and display their respective Table3 text field values. What's an efficient formula? CR 11.
  16. trenttc

    UPPERCASE words only

    I want all the uppercase words from a field that has upppercase words followed by other data. Ex: HELLO There becomes HELLO. I got this far: SET @temp = SUBSTRING(@temp,1,PATINDEX('%[^A-Z ]%',@temp-1));
  17. trenttc

    UPPERCASE words only

    I want only uppercase words from a descripton field that starts with all upppercase words followed by: mixed case or numbers or hyphens or quotes, etc. SET Desc = SUBSTRING(Desc,1,PATINDEX(only uppercase words);
  18. trenttc

    Stored Procedure Declare Select

    Why is it that when I specify 2 column names in the select stmt (vs select 1 column name or select *), I get "Cursor not open" ? I only want to FETCH 2 of many columns. DECLARE cursorP CURSOR FOR SELECT code,desc FROM products
  19. trenttc

    Pattern Match Uppercase, Lowercase

    I want to print only the uppercase words from a field that starts with uppercase words followed by upper/lowercase words (ex: HI BOB Hi Bob > HI BOB). I uncheck File>Report Options>Database Server is Case-Insensitive. I would like to do this in a formula.
  20. trenttc

    Combo box woes

    I tried faq 702-4289 (combo box dependent on combo box). I keep getting Enter Parameter Value Forms!MyForm!cboFirstBox t1 NUMBER NAME t2 NUMBER CODE First Box Row Source: SELECT t1.NAME,t1.NUMBER FROM t1; Second Box Row Source: SELECT t2.NUMBER, t2.CODE FROM t2 WHERE...

Part and Inventory Search

Back
Top