Click here to Skip to main content
15,882,055 members
Everything / SSRS

SSRS

SSRS

Great Reads

by jkrebsbach
A way to combine data from two different sources into one datasource for SSRS reporting
by Sichen D
How to build system availability timeline in SSRS
by Ajit Kumar Thakur Microsoft
This article explain report server database details. It will help to get the report details available in report server database.
by senthill
This article describes how to create a usage report for SSRS reports that are hosted in the SharePoint Site.

Latest Articles

by Tim Golisch
SSRS and Report Builder (or the old BIDS from 2008) are nice for making reports, but they don't embed into your ASP.NET project very nicely. This is one way to do it without the requirement for full SSRS (and the security hoops).
by Hardik.Sheth1717
How to install and configure SSRS
by Sameh Abdel Mongy
Deploy Reports rdl files to SSRS using C# script
by Michael Ecklin
SSRS Reports: Show Data from Non-standard Provider

All Articles

Sort by Score

SSRS 

23 Oct 2011 by jkrebsbach
A way to combine data from two different sources into one datasource for SSRS reporting
25 Oct 2012 by Sergey Alexandrovich Kryukov
Looking for interview questions and answers is quite useless. You cannot know what questions will you need to answer. Just spare your time and nerve. If you are comfortable in some fields you indicated in your resume, you will be able to answer well, if not — make your resume more...
7 Feb 2011 by Furqan Sehgal
I just found the way to fix it.Got o your ReportViwer that carries the report.Click on the triangle above and clickChoose Data Sources. Here you will find the binding sources in in your data sets.Just choose your binding source and you are done.
10 Mar 2011 by strogg
It seems like you are using more than one dataset / datatable in your reportSpecify a scope for the text boxHere's an example of a textbox value without a scope:=First(Fields!xxx.Value)(does not have a scope, valid if only one datatable / source is attached to your report)If you have...
6 Nov 2013 by Sichen D
How to build system availability timeline in SSRS
1 Aug 2014 by Ajit Kumar Thakur Microsoft
This article explain report server database details. It will help to get the report details available in report server database.
19 Jul 2016 by senthill
This article describes how to create a usage report for SSRS reports that are hosted in the SharePoint Site.
27 Feb 2011 by Sandeep Mewara
it generates error. "Operation is not valid due to the current state of the object."This is because the report is still rendering and you are trying to print it out. You need to wait thill the rendering finishes. There is an event RenderingComplete, that you can use to avoid it. Have a...
29 Sep 2013 by Mubin M. Shaikh
Create Named Query in Data Source View While Designing OLAP Cube in SSAS
10 Dec 2014 by ZurdoDev
If you google for sql server compare editions you can find the links. Here is one:http://msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspx[^]It says that developer has the same feature set as Enterprise and SSIS is on the list.
4 Nov 2010 by Henry Minute
For part 1 of your question this[^] Code Project article might get you started. It is in C# but hopefully you will be able to understand it.
7 Mar 2011 by makwith9789
Found the answer increased time out time from 15 to 30 and it worked
20 May 2011 by CS2011
Try the following links. it's easy to do http://msdn.microsoft.com/en-us/library/ms141212.aspx[^]http://msdn.microsoft.com/en-us/library/ms137955.aspx[^]
17 Jul 2011 by thatraja
Look at these articlesLocalization of SSRS Reports[^]Localization (Globalization) of RDLC reports in ASP.NET applications[^]Oops....Kannada is not in the supported languages for SSRSSolution Design Considerations for Multi-Lingual or Global Deployments (Reporting Services)[^]But...
13 Nov 2011 by Willie Moore
Error trying to get SubReports to show (code in Vulcan.net)
9 Dec 2011 by Royce Bacon
How to search for SSRS subscriptions
3 Apr 2012 by Maciej Los
Try to use ROUND()[^] function.Example:SELECT 1.23 [Value], ROUND(1.23,1) AS [RndValue]UNION ALLSELECT 1.24 [Value], ROUND(1.24,1) AS [RndValue]UNION ALLSELECT 1.25 [Value], ROUND(1.25,1) AS [RndValue]UNION ALLSELECT 1.26 [Value], ROUND(1.26,1) AS [RndValue]UNION ALLSELECT...
7 Jun 2012 by Sandeep Mewara
Have a look at these:How to create PDF files from ASP.NET pages[^]Export Html to Pdf using iTextSharp(GridView)[^]
4 Jul 2012 by ravijain03
How to bind single ssrs rdl report with different database on deploy server.
4 Jul 2012 by Sandeep Mewara
bind single ssrs rdl report with different database on deploy server. Only way this could be possible if you supply the database connection info for the report at runtime. These should help you:Setting the Data Source of Reporting Services at Runtime[^]Setting a Data Source at Runtime...
4 Jul 2012 by Sandeep Mewara
Just posting my comment that sounds worked good for OP and happy with the resolution: "Publish it and then see. Generally, there is mark difference in performance in Debug & Release mode of a website."
11 Jul 2012 by Sandeep Mewara
You need to set the following ShowParameterPrompts property, to True. Set it at design time or runtime.Reference: MSDN: ReportViewer.ShowParameterPrompts Property[^]
1 Aug 2012 by Shingala Anil
I recently added SSRS Reports to our C# .NET application using SSRS 2008 R2 and ReportViewer 2010 (remote processing). When I view a report using any version of Firefox the "Report is being generated" message and progress spinner are not being displayed. Is this documented somewhere as a known...
1 Aug 2012 by Ganesan Senthilvel
Reason is, Browser displays SSRS report data thru IFrame. In Firefox, the IFRAME's height defaults to a few hundred pixels, so that you can see the top 2 inches of the report. In IE, IFrames automatically fixed to Data height, so it works fine in IE.To Fix the Issue in Firefox, you can try...
9 Sep 2012 by Prasad_Kulkarni
Firstly you need to do a simple search on google[^] before posting question here.You can also try MSDN, to get detailed description with some code snippetsReporting Services Reports (SSRS)[^]Not far, you can even get lot more articles and QA on SSRS in CodeProject[^] itself.
12 Sep 2012 by gotoahmad
chart1.Series[...
17 Sep 2012 by Stephen Hewison
There was something wrong with the report definition. It wasn't updating the parameter definitions to use the default values.After deleting the report from the server and republishing it, the default values were applied.
27 Nov 2012 by Aadhar Joshi
Creating job in sql server which automates taking backup of all stored procedures and functions in physical drive.
1 Apr 2013 by Sergey Alexandrovich Kryukov
The comment and the advice by Prasad Khandekar is correct.This is a well-known problem This symbol was recently (10 August 2010) standardized by Unicode committee, but not yet implemented by most of the fonts:http://en.wikipedia.org/wiki/Indian_rupee_sign[^].You need to supply the...
19 Aug 2015 by OriginalGriff
You can't use variables across GO: https://msdn.microsoft.com/en-us/library/ms188037.aspx[^] - it effectively starts a new SQL "session"."The scope of local (user-defined) variables is limited to a batch, and cannot be referenced after a GO command."
19 Feb 2010 by mprem39
Hi, I want to generate rdl file such that columns gets created dynamically w.r t Query that we are giving in asp .net app.Can anyone help me.....?
17 Mar 2010 by Mycroft Holmes
When grouping data within a List control I need a header table and child table. The data comes from 1 datatable where the 1st #n columns are duplicated for each detail rows.The usual answer to this is to set the hide duplicates value in the textbox. This suppresses the text but the row is...
11 Aug 2010 by Balu Arigela
I recently started working on tablix properties of matrix and table but I didn't find any good resource in Google.Can anyone give idea or provide links to: how it makes job easy in report design?
8 Feb 2011 by #realJSOP
Make sure the variable's access level is public.
26 Feb 2011 by Sandeep Mewara
If you see, there is an 'Expression' option available when you set the fonts. Use that. In your expression window, use the fields in a iif statement and based on the condition set the font value.Similar for size.
27 Feb 2011 by Furqan Sehgal
Hi,I am trying to use ReportViewer1.PrintDialog() instead of ReportViewer1.Refreshreport()I mean to take my report to printer, instead of viewing it. But when I run the code, it generates error. "Operation is not valid due to the current state of the object."Please advise what is...
2 Mar 2011 by REJI KURU
hi i have created report in sql server reporting service 2008 r2.The report is view the reportviewer control in vs2010(Window Application).i'm change the rdl file to rdlc file then build the application .i have the following error "The report definition is not valid. Details: The...
3 Mar 2011 by thatraja
OP wrote:Question no 1: Why there is no Channel ID?Did you mean 'Call channel No'? BTW check whether that field has any properties/formatting(visibility, color, etc,) or small width...I'm sure it will be a minor issue.OP wrote:Question no 2: Why Why is the Call Date in long date format?You...
8 Mar 2011 by Sandeep Mewara
Well, all you need is to write expression.Instead of providing the link directly, use an iif condition there and based on the value set the link.Look here for samples and examples of expressions:Expression Examples (Report Builder 3.0 and SSRS)[^]A brief introduction to expressions...
17 Mar 2011 by makwith9789
1. Select the table.2. In the grouping pane, click the triangle button and check “Advanced Mode”. 3. In the Column Groups, select the (Static) item which is corresponding to the B column in the table.4. Specify the Hidden property to the expression like=NOT...
22 Mar 2011 by luisnike19
In the background property choose expression. And then write your code=IIf(Fields!Price.Value>100,"Black","Red")
22 Mar 2011 by makwith9789
HI all is there any way i can change the size of bar like the hight and width in a cloumn chart i have a report with lot of charts and some bars are looking ok but some bars are looking fat,how can i adjust that any ideas please i am using BIDS 2008
23 Mar 2011 by luisnike19
I think you should find the way to merge both DataSets before send it to the report, and then just with one Chart display it. There's always a way, maybe you don't want to do it.
25 Mar 2011 by Sandeep Mewara
and there is one more concern here is i should not change the design (wjhat i mean is i dont want to add other rectangle and put the tablix control in that rectangle with Page break property)No need to increase size and bold it.Even in Tablix, one can put a page break after the table ends....
6 Apr 2011 by Sandeep Mewara
I guess so, Yes. Your question/scenario is not too clear yet:In the table data row, write an expression something like:=iif(Field!Col1.Value > Field!Col2.Value, "Some Text:" & Field!ColName.Value, "Some other value")
6 Apr 2011 by Sandeep Mewara
i did tried that but there are some charts in betweenUse the page break property of Tablix. If and whenever required, you can put any object in Tablix (thats why I asked SSRS2005 or 2008). Put a rectanlge or a list and then embedd the needed control like chart or so. Rectangle/lists would give...
26 Apr 2011 by Sandeep Mewara
,i want my data to show up in vertical manner is there a way to acieve it One possible way:Have one column in the dataset as index (serial number). We will use this as a filter parameter for simplicity. Now, for left side table, filter all the rows after n(lets say 50). Thus only 1-50...
5 May 2011 by Sandeep Mewara
sorry the expression i am using looks like iif(isnothing(Fileds!colname.vale,true,false)i am using the same expression for tables to hide it works fine with tables but when it comes to textbox it is not hiding , all my tables and texbox are in one list controlExpression for textbox would...
12 May 2011 by Sandeep Mewara
You can do it, if you are using SSRS 2008.SSRS 2008 has this new feature in it, kind of "RichText" feature for the textboxes to define mixed formatting within the same textbox.Details here:SQL Server 2008 RTM - New features[^]Microsoft SQL Server 2008 R2 Reporting Services full...
31 May 2011 by Rob Branaghan
6 Jun 2011 by Umair Feroze
14 Jun 2011 by thatraja
Based on error message I give you this fix link.Troubleshooting Server and Database Connection Problems[^]Look at the first block Cannot create a connection to data source 'datasourcename'. (rsErrorOpeningConnection) which contains 5 cases.
18 Jun 2011 by Furqan Sehgal
Use =Format(CDbl(Parameters!New.Value), "###,#######0.00")This is the only thing that works ............
22 Jun 2011 by luisnike19
I think you have problems with your server, it could be with the joins, cursors, open connections, or processor, ram, etc.Try to run the query in SQL manually and check the "Execution Plan"
29 Jul 2011 by thatraja
I think this SO question(which has answer) posted by you, see thatLoading Byte image on SSRS from database[^]
3 Aug 2011 by thatraja
Use Drilldowns in SSRSDrill Down Techniques in SQL Server Reporting Services with the Visibility Property[^]Creating a Basic Drilldown Report in SSRS[^]Implementing Real Analysis Services DrillDown in a Reporting Services Report[^]SSRS Series Part II: Working with Subreports, DrillDown...
21 Aug 2011 by Ziggy981
Hi,i have to generate a complicated report in Reporting Services and the columns are very dynamic. I can take care of all this in the Stored Procedure. Is there any way to bind a Reporting Services table/matrix to a data-source and have it automatically display the table as it is? (something...
26 Sep 2011 by Srinivas39
Hi Friends,I'm using the Microsoft.SqlServer.ReportingServices2005.ReportingService2005() to upload reports on a reporting server programmatically. This works quite fine.What I'm not able to figure out is how to set a user defined data source in the report programmatically. I don't want...
26 Nov 2011 by RaisKazi
Have a look at similar Question-Answer discussion below.Calculating grand totals from group totals in Reporting ServicesIts a very first link from Google-Search.Google Search Result
28 Nov 2011 by thatraja
Subreports...
3 Dec 2011 by thatraja
Check thisSQL Reporting Services 2005: Using IIF to see if field contains specific value[^]For your informationExpression Examples in Reporting Services[^]Expression Examples (Report Builder 3.0 and SSRS)[^]SSRS Expressions[^]
3 Dec 2011 by thatraja
Check theseExporting a SQL Server Reporting Services 2005 Report Directly to PDF or Excel[^]Generating and exporting SSRS reports programatically using Report Viewer Control[^]E-Mail Delivery in Reporting Services[^]
3 Dec 2011 by RaviRanjanKr
Try http://msdn.microsoft.com/en-us/library/dd255234.aspx[^]
3 Dec 2011 by thatraja
Check theseRS Maps with Spatial Data and Bing Maps[^]Bing Maps to be in SQL Server 2008 R2 Reporting Services[^]Data Connector: SQL Server 2008 Spatial & Bing Maps[^]"Cartographic Adjustment" of Spatial Data for SQL Server Reporting Services[^]
4 Dec 2011 by thatraja
Check thisHow to: Add Bevel, Emboss, and Texture Styles to a Chart (Report Builder 3.0 and SSRS)[^]
4 Dec 2011 by RaviRanjanKr
Try Maps (Report Builder 3.0 and SSRS)[^]
4 Dec 2011 by RaviRanjanKr
Try SQL Reporting Services with Dynamic Column Reports[^]http://sqlserverbiblog.wordpress.com/tag/ssrs-dynamic-columns/[^]
29 Dec 2011 by Wendelius
You can use parameters to get values for your report. For example, see: http://www.sql-server-performance.com/2007/report-parameters/[^]. Just make sure that you don't define default values for all of the parameters.
29 Dec 2011 by RaviRanjanKr
Try Prompt SQL Statement Dialog Box[^]
29 Dec 2011 by Rajeev Jayaram
Check if this helps, http://www.bigresource.com/Tracker/Track-ms_sql-NfE9LTCm/[^]
16 Jan 2012 by ernieball_26
Hi CodeProject fella's!Is there a way on how to get ranking in SSRS? Are there any available functions in SSRS for me to be able to rank my data? If so, can you please share your knowledge about it? I want the ranking to be just the way as SQL Server DENSE_RANK Function. Here's a table...
15 Feb 2012 by thatraja
Check thisSSRS Series Part II: Working with Subreports, DrillDown Reports, Expressions and Custom codes, Databars, Indicators, Custom Sorting and Paging and many more[^]
2 Mar 2012 by thatraja
Check thisSend a report directly to printer with Reporting Services[^]
2 Mar 2012 by LaxmikantYadav
Look This -> http://bytes.com/topic/visual-basic-net/answers/369873-print-without-print-dialog-box[^]ANDPrinting .NET BusinessInfoObject Class Without the Print Dialog[^]
24 Apr 2012 by ELiva
In the body of the report. Add a table (if you haven't already) that contains the desired fields from the dataset containing your data. You can then add a report footer easily to the report by right clicking in the leftmost heading table cell and selecting "Table Footer".
21 May 2012 by Maciej Los
You can't! Starting from SQL Server 2008 SSRS can also prepare reports in Microsoft Word (DOC) format.More at: http://en.wikipedia.org/wiki/SQL_Server_Reporting_Services[^]
4 Jun 2012 by ravijain03
how to display parameter value in ssrs report below the header at right side after report generation.
4 Jun 2012 by Prasad_Kulkarni
Please refer:Reporting Services: How to place a report parameter in the header[^]SSRS: Show Parameters[^]
4 Jun 2012 by codeBegin
How to display dataset Field value in Page Header of SSRS report [^]How to display dataset Field value in Page Header of SSRS report [^]SQL Server Reporting Services: Report Header[^]
5 Jul 2012 by nenea nelu
VS 2012 and report viewer 11 should support XLSX:"Export FormatsThe following export formats have been added to the ReportViewer controls in this release:Microsoft Excel XLSX: The Excel export option in the Export dropdown now exports to the Office Open XML format and the file...
16 Jul 2012 by Prasad_Kulkarni
Which is fast ssrs or crystal reportsRefer: which is faster[^]Can we export reports in ssrs directly to pdfYes we can.Refer: Generating PDF reports programmatically using SQL Server Reporting Services 2005, in C#[^]More threads here[^]
1 Aug 2012 by Ganesan Senthilvel
As an alternative, you can try this solution.ADD the following code to the ReportingServices.css file (by default, it's found in "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\Styles\"):
18 Apr 2013 by Aadhar Joshi
To avail Danish language as a language breaker in full text search index option, it has to be enabled manually by adding a registry key for the Danish language.
26 Oct 2012 by PRASHANT KUMAR LAL
Hi I am getting error in ssrs that " cannot convert value from nvarchar to int "any help or input from myside?
26 Oct 2012 by Ambesha
Freind, problem is still not very clear but might be use to pass a parameter to sp and there data type are not matched. check the same and make data type compitble.Thanks,Ambesha
26 Nov 2012 by CPallini
If you really aren't happy with the TimeSpan[^] object, then you probably want something like: Public Sub NaturalLength(length As Integer, ByRef years As Integer, ByRef months As Integer, ByRef days As Integer) Dim remain As Double Dim amount As Double remain =...
10 Dec 2012 by Abhinav S
The following links should be useful to you - http://msdn.microsoft.com/en-us/library/ms159673%28v=sql.100%29.aspx[^]http://msdn.microsoft.com/en-us/library/bb630415%28v=sql.100%29.aspx[^]
25 Dec 2012 by Sandeep Mewara
AFAIK, this is not possible in SSRS charts. They are not that advanced that you can have rotating charts with too much of details. Have a look at the documentation of the features supported:How about having a look at these links:MSDN: Charts (Report Builder and SSRS)[^]MSDN: Get More...
25 Dec 2012 by Orcun Iyigun
From what I have understand you need parameters for your report;Here is your startup link from MSDN: Tutorial: Adding Parameters to a Report (SSRS)[^]A video link: Intro to Parameters and Parameterized Reports in SSRS [^]A CP article for dynamic reports: Dynamic Reports with Reporting...
2 Jan 2013 by Prasad_Kulkarni
SQL Reporting Services[^]Getting started with SQL Server Reporting Services[^]Getting starting with SQL Server Reporting services without using the Wizard[^]
2 Jan 2013 by Abhishek Pant
Getting started with SQL Server Reporting Services[^]Reporting Services Tutorials (SSRS)[^]ssrstutorial[^]Creating Reports with SQL Reporting Service and Visual Studio .NET[^]SSRS Tutorials[^]SQL Server Reporting Services (SSRS) Tutorial[videos]SQL Reporting Services with Dynamic...
2 Jan 2013 by Prasad_Kulkarni
MSDN: Reporting Services Tutorials[^]CP: Dynamic reports with Microsoft local report engine[^]This might be useful:How to Create Parameterized Reports With Reporting Services[^]
22 Jan 2013 by techpub
With SQL Server 2012 SP1, you can now view SSRS reports on the iPad and Windows Surface device.For more information, see "View Reporting Services Reports on Apple iOS devices (SSRS iPad)" at http://msdn.microsoft.com/en-us/library/jj659023.aspx.
2 Jul 2013 by Thomas Benz
I have a 2012 asp.net web form application, and one of its asp.net web form page (named "ReportHolder.aspx") contains asp.net ReportViewer control whose Id on markup page is ReportViewer1. The ReportViewer control on ReportHolder.aspx page is used to get and show remote 2012 SQL Server Report...
3 Jul 2013 by Marc Gabrie
Try replacing all these lines in your code: Response.OutputStream.Write(bytes, 0, bytes.Length); Response.OutputStream.Flush(); Response.OutputStream.Close(); Response.Flush(); Response.Close();by this one...
3 Dec 2016 by Member-515487
How to align the text in justify format with SQL Server Reporting Services SSRSPlease help i want to text align Justify i tried with but not work
5 Jul 2013 by Kuthuparakkal
You may try using html place holder. Adding a placeholder with html markup and in the text expression write something like ="some text"/pre> supposed to work on SSRS 2008
8 Jul 2013 by maneavnash
The easiest way to apply Decimal Format is to click the cell go to properties (Properties Window) find Format Property and apply decimal format by typing N2 (Number format 2 decimal places). You might guess how many decimal places you will get when you type N1 or N0 in format property. Hope...
18 Aug 2013 by Anh Nguyen Trong
You need to go to the properties of the datasource of the report and look at the credentials. You can change the information (user, pass) you will not see this.
10 Sep 2013 by TheUltimateDebugger
how-to-use-dynamic-data-sources-in-your.html[^]