I am trying to print a single record on the data report control in vb6.0 with sql2005 as backend can you please sugest how to do this. please send the code.

Try this

SELECT  Field1,Filed2,Field3,. . . FROM Table WHERE FieldX = DesiredValue
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.