Search results for query: *

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

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

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

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

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

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