.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How can show a message in SSRS?

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :Sql Server


I want to show the user a message in the SSRS page saying "No records found." when the stored does not return any values. Currently my reports shows the report headers. How do I do it? Please help. Thank you.

View Complete Post

More Related Resource Links

create user wizard login error message dont show in a message box?




i am using create user wizard and capturing other information within content template when a new user

registers. Some of the textboxes are binded to required field validators.


there is a validation control on the page and ShowMessage box is True.

If they dont complete some of the text boxes then the message box pops Up with the error message.

It does not however include information errors like "User already exists" or Email address already exists

from the create user wizard membership  UserName and Password Textboxes


is it possilbe to hook all of these up so I get one message box with all errors including membership ones?




How can i show Transpose Query In SSRS ?

Hi, Any one help me for following Output. please tell immidiatly.  How I use this expression as follow: I have Database Table Like ----------------------------------------------------------- Date                 ShiftName                    Tons 7/21/2009               Day                          (Ans by Formula) 3 7/21/2009               Night                          (Ans by Formula) 4 7/22/2009               Day                           (Ans by Formula) 8 7/22/2009               Night       &

SSRS - Message/Alert

Dear Colleagues,   I want to find out, is there a way to prompt a message to user when datediff("ss",Now,ExecutionStartTime) > x number of seconds?   For example, report is having 5 parameters with multiselect property enabled and user had selected all values from all parameters. Report starts processing on clicking ViewReport button and then message has to poped to user asking to reduce the parameter values such that report could process within allowed number of seconds.   Is this possible in SSRS 2008 R2 version or Is there any .config setting for the same?              

SSRS Report based on SSAS Cubes doesn't show NULL values correctly

I have a SSRS report which is based on an SSAS Cube. In the Cube the formating of numeric fields that NULL values are properly shown as NULL values. In the Cube Browser and Excel this is shown correctly. However when I design the report already the query against SSAS shows these fields as "0" instead of NULL. Is there a way to fix this or is this a bug ?  

How to Show Loading Message while delay in Page Opening

Hy My web application is make time to open First page due to various data control on the page and values are coming to that control from database so i want to show the loading message of gif image during page loading delay. I have written this code in my master page but that image is not showing the application so please give solution on that problem<html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server">   <title>Load Wait Message Demo</title> </head> <script type="text/javascript" language="javascript">   if(document.getElementById) { // IE 5 and up, FF     var upLevel = true;   } else if(document.layers) { // Netscape 4     var ns4 = true;   }   else if(document.all) { //IE 4      var ie4 = true;   }   function showObject(obj) {   if(ns4) {      obj.visibility = "show";   }   else if (ie4 || upLevel) {      drawMessageBox(); obj.style.visibility = "visible";            } }        showObject('splashScreen');   function hideObject(obj) {   if(ns4) {     

How to show a message box on an invalid filename entered while saving a file using save file dialog

Hi all i have written a code to display a message box if invalid characters are entered while saving the file but my message box is not displaying. Actually i will have a save file dialog option to save a file if the filename starts or consists of the following    \\/:*?<>|"  I would like to display a message box as invalid or illegalcharacters in file My code is as follows    Stream myStream;                          SaveFileDialog saveFileDialog1 = new SaveFileDialog();                            saveFileDialog1.InitialDirectory = @"C:\";                          saveFileDialog1.DefaultExt = "txt";                          saveFileDialog1.Filter = "(*.txt)|*.txt";                          saveFileDialog1.FilterIndex = 2;                          saveFileDialog1.RestoreDirectory = true;                            if (saveFileDialog1.ShowDialog() == DialogR

Show Please Wait... message on loading GridView.

Hi All. I wants to show Please Wait... message on loading GridView. I am not using ajax. The Please Wait... should come above the GridView. On combobox value change the gridview binds with new value. On every binding i wants to show the Please Wait... above the gridview.   Thanks.

what kind of a report to be created in SSRS when the requirement is to show the Summary and Details

I have some reports to be developed where I need to show the Summary and the details of Students/Particular Product, Please advice what kind of Report format/ drill down or is there a way that on clicking on the summary it would show Details in a child report using SSRS 2008. it would be helpful if there are some tutorial links too thanks in advance for response.

SSRS report, doesnt show default value in paramaters when viewed in reportserver

Hi   We have a problem where we have a report that we have deployed to the production SSRS server, when I view the paramater list on the production reporting srver the particular report has the HAS Default paramater ticked, but the default value drop down selected value is blank yet the values are available in the drop down.   When looking at this in system test the default value is loaded.   When comparing the two RDL's they are identical and when loading the report files in Development tools the default value is selected, has anyone come accross this before ?   Ben

How to display pop up message in SSRS 2005?

Hi Guys, I have two parameters : 1. ReportType (with values - Manager, Supervisor, ALL) 2. EnterID (should enter manually) Normally, the intention of my report is when the user selects ReportType as ALL, they should enter in EnterID as ALL But for some reason, when the user selects ReportType as ALL and he enters the EnterID as value 100 or 200 or some number, the report is showing incorrect results. Now, what I want is When the user selects ReportType as 'ALL'  and if he enters anynumber other than ALL, I would like to see a pop up message displaying saying 'Please type ALL'. Is this Possible?

show a "no results" message if a db query returns nothing

I inherited some C# code behind that queries a database table and need to add something that displays a "No results" message (using a Label web control, perhaps) if the query doesn't return any records. I'm just learning C# but am coming up short on how to do this. Would anyone be kind enough to point me to an example, or demonstrate? Thanks a lot. Here's the code I inherited (the programmer who wrote this is no longer available). This is the code behind from the search results page:using System; using System.Text; using System.Data; using System.Data.Common; using System.Data.SqlClient; using System.Collections; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace Maine_Innkeeper_Site_2010 { public partial class lodging_search_output : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { string sql = Session["logdingSearchSql"].ToString(); SqlCommand cmd = common.openDatabase(); cmd.CommandText = sql; string PreviousTown = ""; try { StringBuilder sb = new StringBuilder(); SqlDataReader rdr = cmd.ExecuteReader(); sb.Append("<ul class=lodging-search-initial-results>"); while (rdr.Read()) {

Show custom message in CreateUserWizard ErrorMessage control



How can I show a custom error message in CreateUserWizard ErrorMessage Control?

I check some custom rules in CreateUserWizard CreatingUser event and if not passed I want to show an error message in CreateUserWizard ErrorMessage control. I tried to set Text property of ErrorMessage control and set the Visible property to true but didn't work. I use template in CreateUserWizard.

Thank you,

Show Loading Message during Loop


Hi all

I'm trying so show a message while i am doing some processing. I already tried to show/hide a gif image but it not works :S

Can anyone help me ???



var currentIndex = 0;
ShowImageLoader(); // Here trying to show a gif saying loading
while(currentIndex < newIndex)


    process(currentIndex); // long task here


HideImageLoader(); // Here hide the Gif


Thanks in advance

JQuery: is there a way to show status message - from code behind?


i am trying to figure out how to display message box after it done executing the server side code

 here is the code which works from the client side but still looking for a way to make it work from code-behind


<div id="status"></div>


$("#status").fadeTo(500, 1, function() { $(this).html("You are now registered!").fadeTo(7000, 0); })

How to show message if the gridview row is highlighted


Currently on the gridview i display a list medicine stock and if the medicine quantity less then certain quantity, it will be highlighted on the row. After that, i want to display a message said that the medicine need to be restock ? I have try using  string builder however message does not come out..Any suggestion? Thank you

    protected void GridView_RowDataBound(object sender, GridViewRowEventArgs e)
        if (e.Row.RowType == DataControlRowType.DataRow)

            int Mquantity= (int)DataBinder.Eval(e.Row.DataItem, "Mquantity");
            if (Mquantity< 450)
                e.Row.BackColor = System.Drawing.Color.SkyBlue;
                e.Row.ForeColor = System.Drawing.Color.Black;
                e.Row.Font.Bold = true;

How to  implement the message to show that the medicine quantity is below 450 ?

Century Font in SSRS - Export to PDF doesn't show the font

I have a report developed using SSRS 2008. I have font as Century with size 12. When i tried to export to PDF, the font doesn't show as Century. I have tested using Acrobat 5.0 and 9.0. Any ideas?

SSRS 2005 report export to excel - show text as number


When exports the report to excel, some columns are numbers(something like 00125987). We need these columns to be text,  but excel convert these columns in numbers and in result we received not "00125987" but "125987".  

How to fix that? 

We need all these columns to be text.



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend