Recent content by sql99

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

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

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

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

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

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

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 =...

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

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

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

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

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

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

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

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