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: sql99
  • Order by date
  1. sql99

    cross-tab table and recordnumber field

    Thank you so so much LB, it worked like a charm!! You've made my day :) sql99
  2. sql99

    cross-tab table and recordnumber field

    Hi LB, I looked at the thread you wanted me to see --- do I need the following formula: whilereadingrecords; numbervar linecnt; stringvar name; if instr(name,{table.name}) = 0 then (name := name + {table.name}; linecnt := linecnt + 1); linecnt Also, you asked me to substitute...
  3. sql99

    self join??

    Thank you so much Dave...It works...:)) I'm so glad you can understand what I was trying to do...
  4. sql99

    cross-tab table and recordnumber field

    Thanks you for your reply, LB... Do you know how I can get it to work successfully for multiple row fields? Thanks, sql99
  5. sql99

    cross-tab table and recordnumber field

    Hello, I have a cross-tab table with a formula (@question) as one of the columns. The formula is displaying the question number - ToText ({QUESTION.QUEST_NUM},0). The question numbers however are not sequential numbers. For example, they're starting from 15 on (15, 16, 17, 18, 19, ...). I...
  6. sql99

    self join??

    Hi Dave, I hope this is what you're looking for, if not, please let me know... select * from task_view: contract_id pm_name tech_name 145 Jack Do Amy Jones 145 Jack Do Amy Jones 145 Jack Do Amy Jones select * from employee: ind_id f_name l_name address phone...
  7. sql99

    self join??

    Thanks for your reply Dave. Sorry, I mistyped the script. It should be like this: SELECT tv.pm_name, tv.tech_name, empl.f_name, empl.l_name, empl.address, empl.phone, empl.fax FROM task_view tv, employee empl, role rol WHERE tv.contract_id = rol.cpmtract_id AND rol.ind_id =...
  8. sql99

    self join??

    Hello everyone, Sorry - I've recently submitted the same question but was away for a week and never had a chance to reply to the original thread. This is my script: SELECT tv.pm_name, tv.tech_name, empl.f_name, empl.l_name, empl.address, empl.phone, empl.fax FROM task_view tv...
  9. sql99

    Please help with self join

    Hello everyone, I have the following select statement: select comp_dir, comp_poc, comp_role, empl.add, empl.phone, empl.fax from company comp, employee empl where comp.comp_id = empl.company.id and comp.active_flg = 'Y'; This select gives me the address,phone, and fax for...
  10. sql99

    Returning multiple records

    Thanks KayLynn. Can you please show me an example? Thanks, sql99
  11. sql99

    Returning multiple records

    Hello everyone, I have a crystal report in version 9 where I am pulling client information. Basically, these are the things it's pulling: company name (comp_name) company phone (comp_phone) company address (comp_addr) company representative (comp_rep) company point of contact (comp_poc) I...
  12. sql99

    please help with cross-tab table

    Hello, I added the formula RecordNumber to the column section of the cross-tab expert and that fixed the problem. Instead of my numbers starting at 7, it started at 1. However this only works if it's pulling one row. I tried it w/two rows and the numbers got all messed up... Thanks all for...
  13. sql99

    please help with cross-tab table

    Hi Beanbrain...Thanks for the tip, it worked....!!
  14. sql99

    please help with cross-tab table

    Hello everyone, I have an existing report that has a cross-tab table in it. On the column part of the table, it's pulling question numbers that are not archived in the database table. For example, it's pulling, 7, 8, 9, 12, 15 based on their active flag in the table. I would like to change...
  15. sql99

    Need help with numbering in Crystal

    Thanks for your help, I used the special field "record number" and it worked. Thanks, sql99
  16. sql99

    Need help with numbering in Crystal

    Hello, I have a report in Crystal 9 that has a field which pulls question numbers from the database. For example the database would have the following information in the table called xyz. question # question archived 1 What is your name? Y 2...
  17. sql99

    Please help - missing tables in ODBC

    Thanks synapsevampire. I will check w/my DBA. sql99
  18. sql99

    Please help - missing tables in ODBC

    Thank you for your reply, synapsvampire. The options are set correctly. This issue happened when we did a database restore.
  19. sql99

    Please help - missing tables in ODBC

    Hello everyone, I recently noticed that all my tables and views were missing when I go to open my ODBC in crystal report version 9 client. The only things that display under the ODBC are stored procedures. Has anyone ever seen this issue? Thanks, sql99
  20. sql99

    field is truncating if it's <LONG>

    Hi synapsevampire, Thanks for your reply. I tried using the crystal supplied ODBC and that fixed the issue. Thanks for all your help... sql99

Part and Inventory Search

Back
Top