query pass in vb data report

irfan512 · #1 Dec 11, 2007, 02:58 AM

I have three records in a table with staff no 555,666,777 and I want to pass select query in data report for only staff no =666

please solve this problem

yuffie · Jan 18, 2008, 08:09 AM

by datareport, do u mean crystal report?

if u're using crystal report, u can create a report with the staff no as its grouping. and then in the vb coding, u can type the report selection formula like
" {table.staffno}= '666' "



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!