.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

In SSRS 2005 in y-axis i want to display only those dates which are coming from select statement one

Posted By:      Posted Date: September 17, 2010    Points: 0   Category :Sql Server
For example in select statement:   select date  from Employee   Now i want to show only this date field in y-axis in ssrs 2005, how can i resolve this issue?

View Complete Post

More Related Resource Links

Question regarding IIF statement and Grouping in SSRS 2005

Hi Guys, I am using SSRS 2005. I am facing small prob in using IIF statement to hide a column. I am having a Grouping in my table. (Emp_Group and the values are 'Yes' and 'No') Now, I want to hide a column of the table if Grouping is Yes and I want to show the table if Grouping is No. (When exported to excel it will appear in two different sheets). Any suggestions please............

SSRS 2005 external images won't display - images on DIFFERENT file server

Hi, Been having trouble getting external images to display in reports rendered on SSRS 2005. Images are displayed as a red X. However, my scenario is different from some of the examples I have read about. - The images are stored on a file server that is DIFFERENT from the box on which the Report Service is running. For various business reasons I cannot copy the images locally to the Report Service box. I am using "file://fileserver/path/to/image.jpg" to retrieve the images. - Since the file server does not have IIS installed, I cannot access the images using the URL method (http:// access). I need to use the file:// method. Currently I am prototyping this setup on my test box, which is running XP Pro and IIS 5.1. The Report Service is installed on this same box. I am currently testing this through the Report Manager web site (http://servername/Reports). The images are displayed using the Image control, which I added to the report using the visual report designer in Visual Studio 2005. It is set up with source=External and with "file://fileserver/path/to/image.jpg" path values. File names are retrieved from our database and file paths are built dynamically using a data processing extension I have written. My best guess as to why this is happening is that the ASPNET service account on my test box does not have access to the particular share on the file serve

X-axis labels missing: SSRS 2005

Hi, I have a single line chart in a list, with hourly intervals on the X-axis. The generated report has a number of charts displayed, one for each group in the list. For some charts the X-axis labels depicting the hour are shown for all intervals. For others, I do not see the label for the first and last interval. The intervals are spaced out enough and there is no reason why SSRS may choose to not show a label because of a space constraint. Any idea why some labels along the x-axis are missing? Thanks, Yash

What is fastest way of reading large size XML in SQL Server 2005 using Select statement ?

What is fastest way of reading large size XML in SQL Server 2005 using Select statement ?

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?

how to display leading zero to a value in SSRS 2005


Hi I am having a report with report parameter.In report parameter user will enter the number(number should be <=9) and then related data will display on screen as well as the number which user entered.When user enters the number which less than 9 digit on report I need to display that number with leading zero on report.for example if user enter 12345 the related data will be displayed on report as well as  I need to add 000012345 and display that number on report.I am using a textbox to display the user selected number (parameter!number.value).So can any one say how to add leading zero in SSRS.In sql we can use SELECT REPLICATE(’0′, 10 – DATALENGTH(col1)) + col1 AS NAME

but can any one say how can we display in SSRS.


Thanks in advance

Can I set a table to display 20 rows and then scroll instead of expanding down the page? (SSRS 2005


Can I set a table to display 20 rows and then scroll instead of expanding down several page? (SSRS 2005 )

Can I display Data from a SQL Select Statement to a Label


            sql_select = "SELECT auid FROM tbl_auAccount WHERE username='" & IUN & "'"

            'Add Error Trapping Later
            con = Server.CreateObject("ADODB.Connection")

            'Execute the SQL Command

            'Close the connection
            con = Nothing

Now this works and I was able to put the value into a dropdown list box, but I need the value returned placed into a label such as:

SSRS 2005 error: The Value expression for the textbox contains an error: [BC30205] End of statement



I am trying to run an ssrs 2005 report and receiving the error above.

I want to run custom code in the CODE tab.

Here is my code

Public Function GetDayName (dayIn as integer) as String
Select Case dayIn
Case 0
 Return "Sunday"
Case 1
  Return "Monday"
Case 2
 Return "Tuesday"
Case 3
  Return "Wednesday"
Case 4
  Return "Thrusday"
Case 5
  Return "Friday"
Case 6
   Return "Saturday"
 Case Else
  Return  "None"
End Select
End Function

What is wrong with my code?


SSRS 2005 display totals on each page and the last page



 I have a requirment to display the page number on each page with a total number of records per page like this

Page 1 of 2  ---------------------------Total records: 11

Then on the last page I need to display the page number, the page Total and the grand total records fields like this:

Page 2 of 2--------------------------- Total records: 10 ---------------------------Grand Total records: 21

I tried different combinations but got errors like global execution field cannot be used in the report body,
a text box could not be used in the report footer etc. 

Thanks for your help.

Is Conditional Subscription possible in SSRS 2005?


Hi Guys,

Is there a way to set up a subscription that will send e-mails based on the contents of a report? For example, I want to schedule a daily subscription that will only send an e-mail if the report contains data, otherwise it will do nothing for that day. i.e If the report has more than one row, it should send the mail otherwise it should not send the mail.....

Is it possible in SSRS 2005 or is there any other way to do it???


SSRS 2005 "Mixed" Authentication Mode


I have a web application where users can authenticate using either SiteMinder or Windows domain accounts.  This is actually configured as two separate virtual directories within IIS 6.  Both applications need to use the same instance of SSRS.  Is it possible to configure the SSRS web application so that if a user is authenticated by SiteMinder it impersonates a Windows account, but if they are already Windows-authenticated that account is used instead?

web services transactions (select statement)

 Hi everybody, i'm just getting started in web services and i have a problem connecting to a database. All i want is that my web service recieves a string parameter and return a dataset so that in the client aplication i just show the result of the web service in a datagrid. Here's the code of the web service:    <%@ WebService Language="C#" CodeBehind="Service1.asmx.cs" %> using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Linq;using System.Web;using System.Web.Services;using System.Web.Services.Protocols;using System.Xml.Linq;using System.EnterpriseServices;using System.Data.SqlClient;namespace Farmacia{    [WebService(Namespace = "http://localhost/MyWebServices")]    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]    [ToolboxItem(false)]    public class Farmacia : System.Web.Services.WebService    {        private SqlDataAdapter da;        [WebMethod(TransactionOption=TransactionOption.RequiresNew)]        public DataSet Consultas (string sel)        {            if (sel == "")&

Report printing problem(ssrs 2005)

HI   i have a SSRS 2005 report with width as 32 inches i have a requirement to print the report in a3 landscape  but when i print the report it comes in 3 page width   is there any way to auto scale the report into a3 size without affecting the view in the report viewer   Thanks varun kumar

Dual values in Column chart Y axis in SSRS 2008

Hi,  Any one pls tell me how to show dual values in Column chart Y axis. Example: Im showing Total Number of clients in the Y axis of column chart My Requirement is In that Y axis column chart also  i want to show differently of Inactive clients from total number of clients. how to do this pls help me. Thanks in advance. TotalnumberOf clients :  1000 InActive Clients : 200 among TotalnumberofClients      

Display name of months on x-axis in a chart

Could you please let me know if there is any expression which can be used to display the months on x-axis of the column chart. I've tried playing with the Axis option trying to change the interval type to "months" but it is not giving the result. Thank you.

SQL DIAGOSITC MANAGER tools capture "SELECT *" statement while ALTER / ADD CHECK CONSTRAINT is execu

Hello  ,   I exectuted the code(alter/add with check)  below in SSMS . My_table has 200 millions records . While running the alter/add with check query  the server crashed and the “SQL DIAGOSITC MANAGER” which run on the top of sql serever alert the DBA that select * from my_table was obtained from the last command issued by the user using a DBCC command.      Where does the select * from my_table comes from ? I didn’t excuted select * from my_table at all .   After the sql serever re started I was able to run the command below with out any problem. I checked the SQL PROFILER for the trace there is no “select * from my_table” .   So again where this select * from my_table comes from ?   Here is my initial query ----------------------------------------------------------------- ALTER TABLE [Dbo].my_table WITH CHECK ADD  CONSTRAINT [FK_key1] FOREIGN KEY([Key1]) REFERENCES [Dbo].[Dim_table1] ([Key1]) GO   ALTER TABLE [Dbo].my_table CHECK CONSTRAINT [FK_key1] GO   ALTER TABLE [Dbo].my_table WITH CHECK ADD  CONSTRAINT [FK_key2] FOREIGN KEY([key2]) REFERENCES [Dbo].[Dim_table2] ([key2]) GO   ALTER TABLE [Dbo].my_table CHECK CONSTRAINT [FK_key2] GO   ALTER TABLE [Dbo].my_table WITH CHECK ADD  CONSTRAINT [FK_key3] FOREIGN KEY([d], [c], [r], [g]) REFERENCES [Dbo].my
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