Thanks for the response - the query right now is just selecting all of the records in the table ( I believe - I am not very familiar at all with SQL or SSRS ... apologies in advance for my ignorance ):
select * from tblEmployeeID
I would expect this to return all of the records, so I could just click next to browse the results of the report.
Additionally, I have just recently added the line:
where...
User Profile
Collapse
-
Report Builder 3.0 - only one record returned when report is run
Hi Everyone! First post here!
I am working with a test report, using Report Builder 2.0 in an SQL environment with server 2008 R2 with SSRS installed.
I have a data source and dataset set up properly (I think). I have a table in the data set that has things like (for the sake of example...) EmployeeID, firstName, lastName, ... etc which I have thrown into a blank report to make sure that it connects to the data fine...
No activity results to display
Show More
Leave a comment: