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

    SQL String Array Code

    SQL Server DB; Hi all, can anyone help me with this SQL Select statement? I have a Srring Array field named: Region. (The array can contain up to 4 elements.) What is the SQL code to select records that are IN a specific region? Example of Current output: CompName Region CompA NA...
  2. ccding

    SQL String Array Command Code

    SQL Server DB; Hi all, can anyone help me with this SQL Select statement? I have a Srring Array field named: Region. (The array can contain up to 4 elements.) What is the SQL code to select records that are IN a specific region? Example of Current output: CompName Region CompA NA; Europe...
  3. ccding

    T-SQL Code for IN Array Select statement

    Crystal Reports XI; SQL Server DB; I need the T-SQL code to select all companies that are IN certain Regions. Keep in mind that the field, Region, is an array and holds more than one region. EXAMPLE DATA for the 2 fields below: CompanyA Region Comp1 Europe; Asia; Comp2...
  4. ccding

    SubReport1 overlapping SubReport2

    CRXI; SQL Server; I have a main report with about 4 subreports. How can I place SubReport1 above SubReport2 without having the items in SubReport1 overlapping into the place of SubReport2. (Without inserting a new section) ?? I have 'Can Grow' for all SubReports; Sample Report: SubReport1...
  5. ccding

    How to Insert a Subreport within a Subreport

    CR XI; SQL Server Db Is there an easy way to insert a subreport within a subreport?
  6. ccding

    How to Suppress duplicate record in different group

    Crystal Reports XI; SQL Server Database I want to suppress a detailed record if it falls in more than one Group. so, if a customer is in Group A (The top group) and it also falls in a following group, how can I suppress the record only in the following group. **Suppress if duplicate** does not...
  7. ccding

    How to Create a Table of Contents

    Hi all - Crystal Reports XI - SQL Server Database: How do you create a TOC with 2 Group Headers? Group Header 1: Category.... Page Number then Group Header 2: CustomerName (indented under Category)... Page Number ?? Thannk you
  8. ccding

    How to Split elements And Group by each in an array

    Hi, I am new to tek-tips, so here is my question. I hope it is presented well. Using Crystal Reports XI. I have ONE field array ({Geography}) that contains upto 5 elements. For each acct, its ({Geography}) can contain upto 5 different regions. For example (report display): Acct...
  9. ccding

    Parse and Group elements in an array

    In Crystal Reports XI, I have a basic field (which is an array with upto 5 elements.) The field {geography} can contain upto 5 regions per Account. For example, Acct1 may be in {geography} Asia, NtAmerica, Europe Acct2 may be in {geography} Nt America Acct3 may be in {geography} NtAmerica...

Part and Inventory Search

Back
Top