.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

SSRS Only Display One Row

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
Hi people, I am using VS 2010 and the SSRS that came with it. I am sure its SSRS 2008. Anyway, I added a report file to the project, added an ObjectDataSource and connected this to SQLServer 2008, and display the dataset on the report. The report is using ScriptManager, ReportViewer1, and Report1.rdlc file. I preview the dataset and I have multiple row returned. The problem is I only have one row displayed on the report. Maybe I did a quick and dirty report? What setting of properties did I missed? BlueMarker

View Complete Post

More Related Resource Links

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

Display an SSRS Report Part on web form

I have a Report Part created on my 2008 SSRS Server.Can I use a Report Viewer to display that part? Or do I have to add that to a report and then display the report? I'd rather not create a report.Any advice is appreciated.

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?

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

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?

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

Display date headers in SSRS reports


Hi All,

I have a report to display sales figure for the last 3 days including current date. That means whenever the report is generated it should start the date column with the current date and the previous 3 days data. I have the query ready to pull the data. But I am not able to generate the column headers in date format. Below is my report format for your reference...

  10/4/2010 10/3/2010 10/2/2010 10/1/2010
Product A

SSRS 2008 how to define a custom legend and display colors of legend in table


How would i go about setting the background color in a table to a legend series color in a chart control?



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 )

want to display 24 hours time and date with datatype Datetime (Not String) in SSRS


Hi All,

I want to display 24 hours time and date in SSRS & for that I am using Format(now,"MM/dd/yyyy HH:mm:ss") but I am using this expression in Parameter, where I need to define datatype of that parameter as DateTime, not string. For Expression Format(now,"MM/dd/yyyy HH:mm:ss"), If I use DateTime datatype, It is showing error but working with String datatype.

For example:

I have parameter To Date  and value of this parameter should be 10/11/2010 13:09:16 (To Date: 10/11/2010 23:09:16) , not in AP or PM format and datatype of this parameter, want to keep DateTime that I can select value from Calender.

Please suggest me how I can achieve this?. I don't want to do it in stored Procedure side, want to do it in report side.

Thanks Shiven:)

ssrs report header display in center


Hi All

I have an ssrs 2008 report ,in which am displaying 15 columns.Those columns are hidden based on a expression.so when the report runs ,it might show 9 or 10 or 11 ,it depends.But there is report name on top which should dipslay in center of report table.It was set to display in center when report  shows all the 15 columns.When the report is showing only 10 columns,the report name in header is going to right,its not displaying in center.How to achieve this?

Thanks in advance!!

Display message box in SSRS 2008 R2 report


I'm trying to figure out how to display a message box in a ssrs 2008 r2 report. I have custome code that validates a couple of parameters, and I want to display an error message if a user enters an incorrect parameter. I included 'system.windows.forms' as a reference in my report, and tried to use 'system.windows.forms.messagebox.show(errormsg) but I keep getting an error. I created a hidden parameter that references the custom code.

Any help would be greatly appreciated.

Thanks in advance.


How can I display the message in SSRS page?



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

howto: display only hierarchy-members (levels) which are selected in the parameter (SSAS and SSRS)


Hi all,

I'm a SSRS/MDX beginner, so this might be a basic question. Sorry for that.

I have a hierarchy, which I use as a parameter. The Hierarchy has 3 levels (level1, level2, level3).

Sample Hierarchy

Now I want to achieve the following:

  • If a user selects CH1 --> the report should show only the CH1 (which is the sum of CH11 + CH12 + CH13)
  • If a user selects CH11 and CH12 and CH13 --> the report should show only these leafs (no aggregations)
  • If a user selects CH1 and CH11 and CH12 and CH13 --> the report should show the leafs and CH1 (seperate)

I guess, this is not that hard, but somehow I don't get it.

Here my sample mdx-query (the hierarchy I'm writing about is "Lieferantenstruktur" and the parameter "@Lieferant" (BOLD)):
(right now, only the leaf-level [Lieferant] is returend by the query)

SELECT NON EMPTY { [Measures].[Einheiten] } 

, NON EMPTY { ([Lieferantenstruktur].[Lieferantenstruktur].[Lieferant].ALLMEMBERS 
* [Artikel].[Artikel Kategorie].[Artikel Kategorie].ALLMEMBERS 
* [Artikel].[Artikel Gruppe Code Name].[Artikel Gruppe Code Name].ALLMEMBERS 
* {[Kundengruppen].[Kundengruppen].[Verkaufskanal].ALLMEMBERS 

Display an SSRS Report in multiple (user's) regional settings



I have an SSRS Report that I've developed that returns date values. I have users that will access this report globally, and I would prefer that the report return these dates in the format tied to their regional settings.

I have set the RDL Language property to the expression =User!Language. this works on my local development environment.

Then I published to my ReportServer (MOSS 2007). Now no matter what regional settings my PC is tied to, both the report paramters and date format display in whatever Regional setting my SharePoint site is set to.

Is there a way that I can dynamically display the report using the User's regional settings?


Legend Display Setting in SSRS 2008


In SSRS 2008 when you have only one series , it displays the name of series in legend series 1. But when you have more than one series group it displays with the true series name in legend box. However, in SSRS 2005 for the same report ,legend box displays the true series name whether I have one or many series groups. Is there any way to control how legend displays the selected series name insteady of  "series 1" in SSRS 2008? What I want to do is replacing "series 1" with "Quarter1" in legend box in SSRS 2008.

Below is how legend displays series group in SSRS 2005 and SSRS 2008 respectively,


Quarter 1

Quarter 2

SSRS 2005                                            

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.

GridView inline Master/Detail record display

This code drop is part of a smash and grab series. If you're in a rush, you can just grab this code and insert it into your application, no understanding is required. When you have some time (ya, right) you may want to review the source code.
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