Unable to get all records

Hot Topic

Please help with explicit permissions for a database
Replication Error
SP1 failure - incorrect platform
Multiple-step OLE DB operation generated errors
Decrypting Password of SysxLogins Table - SQL Database.
No Data Returned for report
Pre execute Failure on Look up task
Remote messages not working – message vanishes
Login error
Access to SQLServer Database from Visual C# app and ASP.NET app

SQL Server

SQL Express Eventlogs?
Database restore to new database
Error locating server/instance specified
Custom procs for replication
Which version of VS?
SQL escalating S lock to IX by itself and later Deadlocking
Unexpected Results with "Rolling 12 Month Sales" Calculated Member
Configuration File Locations - Likes to say it can't load them in designer
Datatype conversion strangeness
What is the ADO DataType for nVarchAR(max)

Unable to get all records

Hi  Everyone,

Hope everyone is doing good.

I have problem while running the report, it returns only one record  but it has many records
. I am using stored procedure and parameter for running the report. If you have any suggestion I will apperciate you. Thanks in advance.


Answer this question

Unable to get all records

  • sureshkolluri

    Are you sure there is more than one page   You may have messed up on the grouping if you used the wizard.

  • Rabarbers

    ya I got that thanks

  • wfoster3

    Are you sure that the query is returning multiple rows What does it show in the query tab Can you turn on SQL trace and see what is actually happening Do you have any filters in the report itself

  • Software Arch

    yes I got that thanks


  • Unable to get all records
Answer this question