I have a query I created in SQL and have added it as a data source for a report I am working on. In the design view of the report I have added just a plain table component. when I link my query to it, there are only about 15 rows in the table of the query but in the report it only shows the first row and replicates that row on 15 different pages of the report and no other information is showing.
I deleted the table, added it back and set my columns like before and now it is working…
1 Like