Crystal Reports Logical Err

Nasir

Member
Joined
Jun 14, 2004
Messages
5
Programming Experience
3-5
Good Morning to All My Fellow Members
I am attaching a code the dbifo.ini file is for data bse connectivity please when u run it chage the server name plz problem is that reports shows only one record in disply i am try to display all the records but only one is comming all the rest r overwited ??? kindly help me asa possible .I will be grate full to the members

"Nasir "
 

Attachments

  • FiledBProject.zip
    13.4 KB · Views: 89

Paszt

Staff member
Joined
Jun 3, 2004
Messages
1,500
Location
Raleigh, NC - USA
Programming Experience
Beginner
using This SQL statement:

VB.NET:
QryString = " SELECT EmployeeID, FirstName + ' ' + LastName AS Name," _
          & " Address  " _
          & " FROM Employees  " _
          & " Where  EmployeeID=1 "
only the rows that have EmployeeID equal to '1' will be returned. I assume employeeID is either a primary key or no duplicates are allowed in that field; therefore you will only get one record. If you want all records, remove the WHERE clause:

VB.NET:
QryString = " SELECT EmployeeID, FirstName + ' ' + LastName AS Name," _
          & " Address  " _
          & " FROM Employees"
 
Top Bottom