Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Database & SysAdmin
  3. Database
  4. ReportViewer Problem

ReportViewer Problem

Scheduled Pinned Locked Moved Database
databasehelpcsharpasp-netsql-server
2 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    sangramkp
    wrote on last edited by
    #1

    Hi, I am using Sql Server Reporting Services in my asp.net web application. I am displaying the reports in reportviewr. Whenever there is some data its ok. But When The Stored Procedure or query didn't produce any result the report viewer appears and take usual place(i.e width and height). My requirement is that if the stored procedure or query returns data then the report viewer will be visible along with data. Else the report viewer should Hide and display Record Not Found. Issue: -------- As the .rdl file is directly related to stored procedure or query we r not fetching any datatable into the page. Any Suugesstions or Solutins heartly Accepted.... :rose:

    Sangram (A battle with self) Life is simple, we are the ones makes the living difficult

    P 1 Reply Last reply
    0
    • S sangramkp

      Hi, I am using Sql Server Reporting Services in my asp.net web application. I am displaying the reports in reportviewr. Whenever there is some data its ok. But When The Stored Procedure or query didn't produce any result the report viewer appears and take usual place(i.e width and height). My requirement is that if the stored procedure or query returns data then the report viewer will be visible along with data. Else the report viewer should Hide and display Record Not Found. Issue: -------- As the .rdl file is directly related to stored procedure or query we r not fetching any datatable into the page. Any Suugesstions or Solutins heartly Accepted.... :rose:

      Sangram (A battle with self) Life is simple, we are the ones makes the living difficult

      P Offline
      P Offline
      pmarfleet
      wrote on last edited by
      #2

      Data bound controls in SSRS have a NoRows property which allows a message to be defined which will only be displayed when the data source that the control is bound to does not return any data.

      Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups