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 gkittelson 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. UCFSteve

    Query problems for view creation

    I have a set of data that looks like: ID Location ---------------- 1 1 1 2 1 5 1 6 1 9 2 2 2 5 2 3 2 9 3 5 3 8 3 10 I obtain this data doing a SELECT DISTINCT ID, Location FROM tblBooks Now I want to create a view, that will...
  2. UCFSteve

    Sort an array by 2 different fields one after the other

    I need to sort an array that contains multiple objects. I need to first sort it by Rank, then by Last name. Ex Array[0].rank = 3 Array[0].name = Jones Array[1].rank = 2 Array[1].name = Adams Array[2].rank = 3 Array[2].name = Scott Array[3].rank = 1 Array[3].name = Murphy Array[4].rank = 3...
  3. UCFSteve

    How can you Join a report field

    Thanks for you help, but no that did not work. I ended up combining the two records on the db side and bringing them in that way. Thanks anyways.
  4. UCFSteve

    Is it possible???

    Example Data: Record 1- Class: CS Attendence: Steve Test: C++ Record 2- Class: CS Attendence: Joe Test: C++ Record 3- Class: CS Attendence: Mary Test: Java Output: Class: CS Attendees: Steve Joe Mary Test: C++ Java P.S. I do not have the capability to Show SQL...
  5. UCFSteve

    How can you Join a report field

    Crystal Version - 8.0 Database - ClearQuest MSSQL Example Data - Field Name Attendence Expected Output - I want to have a single value that I can insert into the report that contains all of the distinct names for the different attendees
  6. UCFSteve

    Is it possible???

    Crystal Version - 8.0 Database - ClearQuest MSSQL Example Data - Field Names: Class & Attendence & Tests Expected Output - Group Header (Class) Group Header (Attendence) Details Attendence.Name Group Footer Group Header (Tests) Details Tests.Type Group Footer Group Footer
  7. UCFSteve

    Is it possible???

    Unfortunately that is the case they are 2 seperate fields.
  8. UCFSteve

    Is it possible???

    I am unfortunately unable to use sub reports because I am using a trimed down version of cyrstal reports. The version I am using is routed through Rational Clearquest. So I will still need to find another way around this.
  9. UCFSteve

    How can you Join a report field

    I need to join a report field that contains a Memo value. The field has multiple values that I need to join and I dont want to display them in the Details section. How can I join them similarly to a ForEach() where I can join all of the Memo values together?
  10. UCFSteve

    Is it possible???

    I need to create 2 seperate groupings incapsulated by 1 parent group. GH1 GH2 D2 GF2 GH3 D3 GF3 GF1
  11. UCFSteve

    Aligning 2 Charts on top of each other

    I am layering two different charts one on top of the other, by using the transparent background option for the top chart. How can I align the charts to be the same size in version CR 8.5?

Part and Inventory Search

Back
Top