developing a report in VS and upon running only produces data in column 1 and doesn't return all the records. (See picture 1). I imported the report into Report Designer connected the connection to an Access DB and run the report and returns records as they should. (See Picture 2). I am not sure what is happening. I copied all the header columns and detail columns from Report Designer and pasted in my VB project.
There isn't anything wrong with the SQL as it produces all records if running the query on its own.