Click here to Skip to main content
15,885,366 members
Everything / Reporting services

Reporting services

reporting-services

Great Reads

by J.Jash
Data Auditing Trigger Generator
by Levente Kupás
If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.
by James Maeding
Tool to report another programs buffer of messages sent to a text file
by Hardik.Sheth1717
How to install and configure SSRS

Latest Articles

by Hardik.Sheth1717
How to install and configure SSRS
by yuvalsol
Set the format of a SSRS date parameter apart from the SSRS report localization
by Mark W Solomon
In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.

All Articles

Sort by Score

Reporting services 

20 Jun 2013 by Levente Kupás
If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.
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...
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...
18 Oct 2012 by James Maeding
Tool to report another programs buffer of messages sent to a text file
21 Apr 2011 by Sandeep Mewara
Your print setup and properties needs configuration.Look here: MSDN blog: The "Every Other Page Is Blank" Feature[^]About letter size you said, it's your system printer setting. You need to set it to A4 by yourself if that is the case.Further, make sure you have not kept designer too...
21 Dec 2013 by Maciej Los
If you want to get 3/17 instead of 17.65%, formula should looks like:=Fields!grade.Value & "/" & Fields!count.ValueUpdate your query:SELECT ProductName, Grade, COUNT(Grade) AS CountOfGrades, (SELECT COUNT(Grade) FROM Inspection) AS TotalOfGradesFROM InspectionWHERE (Branch =...
23 Dec 2013 by Soldier_T
Thanks to Maciej got this to work SELECT ProductName, Grade, COUNT(Grade) AS CountOfGrades, (SELECT COUNT(Grade) FROM Inspection WHERE (Branch = @branchno) AND (Date BETWEEN @DateFrom AND DATEADD(day, 1, @DateTo)) AND (Grade'') AND (productname=i.productname) AS...
27 Jun 2016 by OriginalGriff
Just concatenating byte arrays won't do anything useful - DPF is a "container" format, so just "bolting" two containers together doesn't produce one big container. Any more than stapling two bags of sugar together would create a bigger bag full of twice as much sugar...Have a look at this:...
17 Jan 2022 by Richard Deeming
If you want to set the header via code, the simplest option is to add another parameter, pass the required title in that parameter, and set the text box's text to that parameter. Otherwise, you could use an expression for the text box parameter,...
8 May 2010 by Rod Kemp
You could try and setup a linked server in Sql Server to Oracle.Setting Up an Oracle Linked Server[^]How to set up and troubleshoot a linked server to an Oracle database in SQL Server[^]
12 May 2010 by Sandeep Mewara
You can set your report parameter as NULL or EMPTY or any default value you wish to. Thing is, the parameters will be used in a query to fetch the data. You just need to handle that value passed properly in the query.
8 Jun 2010 by Scubapro
Maybe the following might be useful:http://msdn.microsoft.com/en-us/library/ms252091.aspx[]
2 Aug 2010 by Sandeep Mewara
Well, SSRS can use user defined functions using Custom Assembly. Read all about them here: MSDN: Using Custom Assemblies with Reports[^]For a sample example, have a look at this article:Localization of SSRS Reports[^]
6 Feb 2011 by Sandeep Mewara
This article of mine would help you in understanding and learning on how to use Custom code: Localization of SSRS Reports[^]Now, pointwise:1) I have added a text box to header of the report, I want to assign some value to it from my variable.You can do it via custom code or using a...
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...
31 May 2011 by Rob Branaghan
29 Jul 2011 by thatraja
I think this SO question(which has answer) posted by you, see thatLoading Byte image on SSRS from database[^]
2 Aug 2011 by Sreenath Gv
Solved..Please chek out..http://www.eggheadcafe.com/community/aspnet/17/10340545/issue-in-retting-reportviewer-parameters-in-aspnet-2010.aspx
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...
4 Dec 2011 by RaviRanjanKr
Try SQL Reporting Services with Dynamic Column Reports[^]http://sqlserverbiblog.wordpress.com/tag/ssrs-dynamic-columns/[^]
7 May 2012 by HomeGrownFreshness
Quote:How can I master SQL Server 2008 Reporting Services in short period? The same way I know Kung-Fu.The only way to "master" is to do.
7 May 2012 by AmitKumar89
Hi,Here is the good article on SSRS.Getting started with SQL Server Reporting Services[^]If you want to be a master of this then first you need to understand the basic requirements and also you'll have to go through it thoroughly using all the conditions and problem statements.This may...
3 Aug 2013 by Amar Kapadia
Quick Solution: Field Names in tables must not have spaces in them.Hello EveryoneI think I might know what is happening here. Indeed, perhaps all this stemmed from the Northwind40.sdf SQL Server Compact Edition 4.0 database file I was using. Again, I'm not sure how I got it but must be...
2 Feb 2014 by JoCodes
Refergetting-started-with-ssrs-part-8-show-ssrs-report-in-aspnet-web-page[^]
14 Nov 2018 by CHill60
TRIM removes whitespace. You want a SUBSTRING of the text. Try thisdeclare @text varchar(50) = 'AM.JUBAIL.PRE-FINISHING-LINE.PFBSTR.PFBST1' select reverse(left(reverse(@text), charindex('.',reverse(@text)) - 1)) Here is the reference material LEFT (Transact-SQL) | Microsoft Docs[^] REVERSE...
30 Oct 2021 by Hardik.Sheth1717
How to install and configure SSRS
20 Feb 2022 by Andre Oosthuizen
This might be server related as well, due to numerous factors i.e. maintenance etc. Might be browser or as you stated IIS related, quite difficult to pinpoint a service unavailable error. Have look HERE for possible solutions
20 Feb 2022 by M Imran Ansari
It seems to be SSRS services are not running. While setting of IIS, have you changed your application port? If yes, then restart the SSRS service. It will fix your problem. Further you can check the following link: How to fix problem 503...
25 Jan 2010 by mugamath
"select PK_CourseID_VC as CourseID,CourseName_VC as CourseName,No_Of_Seats as NoOfSeats,SectionCount as TotalSections from Course_T"from the above query,i want to display the fields in the crystal reportthe fields are CourseID, CourseName,NoOfSeats,TotalSections as column headershow to...
8 Feb 2010 by Garret H
Can someone tell me if there is a function in the forum that allows users to report posts? Thanks.
8 Feb 2010 by Smithers-Jones
"Vote to remove message" on the lower right hand side.
8 Feb 2010 by Avi Berger
In the right hand column, not very far down, there is a box labeled Tools. In that box there is an option, "Report".
8 Feb 2010 by Garret H
Great; thank you. I appreciate your responses.
9 Mar 2010 by Brady Kelly
I am trying to develop an A4 page size report for print using the RDLC report designers in VS 2008 and VS 2010. I'm finding this an infuriating and extremely frustrating task, as the smallest changes to the report disturb some kind of strange balance and result in a blank printed page after...
9 Mar 2010 by Sandeep Mewara
Yes!Looks like your changes are increasing the availalbe width of the report such that total width including margins are exceeding 8.5 inches for A4Make sure, after counting in margins you keep the report data in the left space.Like. margins .5 inch on left and right then, you need to...
25 Mar 2010 by Thiago de Arruda
Hello, This question is for the author of this article : An XAML Serializer Preserving Bindings[^] because I dont know how to contact him, if anyone can help me contact him plz answer it too. I made really good use of your XamlSerializer and developed a simple reporting engine for WPF...
25 Mar 2010 by William Winner
At the very bottom of that article is a forum. Click the words "New Message" and type this in there. It will send the author an email with the new post.
1 Apr 2010 by Wannes Geysen
Hi,I want to add the following expression to a textbox in my rdlc report:=Sum(iif(Previous(Fields!VWINKEL.Value)Fields!VWINKEL.Value,Fields!VAANTALNIEUW.Value,0))But it seems to be impossible to use the Previous expression in an sum function. I get this error message:"The...
2 Apr 2010 by leckey
Are you able to create another dataset in your report that has the first aggregate total? I've run into this issue before myself. I created a dataset that was the total, then the textbox was an aggregate of that dataset.
3 Apr 2010 by cursedsw
I have a datagridview. I need this datagridview to crystal report. How to send my datagrid's data to crystal report?:confused:
18 Apr 2010 by The Manoj Kumar
Actually the only thing that you can do is modify Axis options to show points but you can't show tooltips for values. If you strictly want this then you have two options:1. Try 3rd party controls like Dundas :sigh: .2. Create a report viewer at your own :doh:
21 Apr 2010 by Gumbatron01
Thanks Sandeep, I had read that forum post earlier (was a little more helpful the second time I read it) :) I'm pretty sure it's not related to interactive height settings, I've dealt with those issues before.There is only one option that I've been considering, which is to extract the...
7 May 2010 by Don Kackman
So my company has two distinct camps when it comes to databases. Operations is in the Oracle camp while R&D is in the Sql Server camp.The application group that I manage sits in the middle of this divide, storing data in Oracle, parts of which reference, by a weak PK/FK relationship, data in...
10 May 2010 by saurabhvaze04
Hi,We are using the ReportViewer control to display SSRS reports in our ASP.NET application. On pages where we use the ReportViewer control the session does not time out. The reason for this is the ReportViewer control emits a "setTimeOut" javascript function which reads the Session timeout...
10 May 2010 by DaveAuld
If you google ReportViewer Session Timeout, there are others discussing the same issue.There are suggested work arounds from MS etc on some of the threads, here is the first hit returned;http://www.velocityreviews.com/forums/t586187-reportviewercontrol-session-timeout.html[^]
12 May 2010 by Pavel Yermalovich
In my report i have multivalue parameter. From CheckBoxList i retrieve List. And then I want to pass my list with values to ReportParameter object. What should I pass into ReportParameter when my list is empty?
18 May 2010 by Soft009
Microsoft.Repo...
19 May 2010 by Sandeep Mewara
The error itself is saying what all you need to do.you have not posted what you have done and how you got this. Just the error. Reading it, your RDLC is missing at the said place. Check for security permissions on those folders such that temporary reports if getting created then go through...
19 May 2010 by radix3
Hers your answerSoft009 wrote:C:\Documents and Settings\COMPUTER7\Local Settings\Apps\2.0\39O7XVW2.G5E\Report1.rdlc'.The error itself is the answerReport1.rdlc file is missing at the said path so see to it that it exists in the said pathThanks & RegardsRadix :rose:
23 Jun 2010 by Amo Xu
In our project, we got some rdl files that contains dynamic column, User can decide which to show or which to hide by a Multi-Selection Report Parameter.then it comes some problems: 1.if there is a report contains 10 columns, and if select all columns to show, and print they will be...
22 Jun 2010 by Emre Gönültaş
-I dont know how many groups will be formed and I want the total rowcount of each group to be displayed.-I also want the total static rowcount, or some way to sum the rowcounts of each group.Thanks...I tried the Count, CountDistinct and CountRows functions but for some reason they...
22 Jun 2010 by Kschuler
It would help if you would post what DB you are using and the SQL you tried since we don't know your file structure...but I'm guessing you want something like this:SELECT columnYouGroupBy, count(*) FROM table GROUP BY columnYouGroupBy UNION SELECT 'TOTAL', count(*) FROM table
24 Jun 2010 by Emre Gönültaş
I have such a situation in my table:group1 5 membersgroup2 0 membersThe problem is when a group has 0 members its row is not displayed at all. I want it to report that it has 0 members.Thanks..
24 Jun 2010 by Andrew Rissing
Just perform a LEFT JOIN from your list of all groups to the data that produces your member counts. Then just make sure you replace the NULL with a zero.
28 Jun 2010 by Barry Gabriel
I have an implmentation of RS 2008 utilizing email subscriptions with a hyperlink for user access to the report. My intent is to have this link open the Snapshot which triggered the subscription for "that day". Seems to work well other than the hyperlink does not reference that specific...
7 Jul 2010 by shanticse
I want to display 30 records in one page 10*3 How is it possible?Give me answer...
7 Jul 2010 by Sandeep Mewara
So what is the issue? You can use a Matrix control to do the same. Read about how to use Matrix control here:Adding a Matrix (Reporting Services)[^]
7 Jul 2010 by shanticse
I want to merge 2 cells in matrix is it possible?
22 Jul 2010 by Sosyopat
Hi All!In reportviewer object, datetime parameter fields comes with just date selector. Could we customize reportviewer object? Add hour, minute and second selectors?p.s: sorry for bad english
22 Jul 2010 by Sandeep Mewara
Well, I doubt that. Though cannot surely say so. Lets see if someone else assures it.
25 Jul 2010 by hemachandrareddy
Hi friends,I am trying to put date and time in reporting services.If I use =Today() then it is showing date and 12amBut I want exact time like 11.20.It would be great if u can send the code for that.Thanks a lotHemachandra
25 Jul 2010 by bhavana.patel
Today().ToStri...
26 Jul 2010 by helelark123
If I understood you write you would like that your retrived data from database that it is some HTML code will be displayed like in browser? If yes, you can output the report in an html file, just write to file the html code and save the file wih .htm or .html extension. Hope it helps you -...
1 Aug 2010 by hemachandrareddy
Hi friends,I am retrieving data from a table which has HTML tags and data in one row. I retrieve data into a report by using a Stored Procedure. I want to print just the data in the report(SQL SERVER REPORTING SERVICES), but not the HTML tags. But, I want to execute the HTML tags. Could you...
1 Aug 2010 by laoyingisme
I used to do this by using asp:table 1.retrieving data to control;2. output data(.doc) function protected void OutExcel(Table dg, string name) { // dg.Visible = true; Response.Clear(); Response.Buffer = true; Response.Charset = "utf-8"; ...
1 Aug 2010 by hemachandrareddy
HI friends,I am new to reporting services.Could you please tell me the way of writing and calling user define functions in sql server reporting services???Thank you in advanceHemachandra
1 Aug 2010 by laoyingisme
If you want to post html, you need to change parameterprotected void OutExcel(Page dg, string name){// dg.Visible = true;Response.Clear();Response.Buffer = true;Response.Charset = "utf-8";name = "attachment;filename=" + name;Response.AppendHeader("Content-Disposition",...
8 Aug 2010 by abhijit_kadam
i have same problem i unable to create first aggregate total?i want as follow=Sum(iif(Previous(Fields!VWINKEL.Value)Fields!VWINKEL.Value,Fields!VAANTALNIEUW.Value,0))
9 Aug 2010 by Christian Graus
You should buy a really basic SQL book and read it. If you can't read this and see the issue, then you really should NOT be working on a system that has any sort of security requirement ( or indeed, be paid to write ANY SQL ). Copying random code off the web without understanding it is NOT...
10 Aug 2010 by jennGer
you should first know what i am, before you judge me for what i'm NOT! why is this site used for to ask question isn't it.first of all i'm not being paid for what i'm doing.but i aint gonna explain any thing to you cause i dont have time for such an arrogant comment. you could...
13 Aug 2010 by raymond amegadjin
Hi, i have a reporting service with various report all having different parameters.lately some of the parameters include special characters(+,-,' ,etc..) causing the report to be only generated from the report viewer.how can i encode the url so that the report server get it right?thanks
13 Aug 2010 by Yusuf
anything useful in this blog[^] for you?
13 Aug 2010 by Sandeep Mewara
You need to handle special characters using HttpUtility.URLEncode()Have a look at this blog entry for full detail:URL Encoding in Reporting Services [^]
17 Aug 2010 by shivtk
Hi Everybody,Can any one tell me how to get the number of days in the month, where we will be providing the month and year,I am using sql reporting services for generating the reportesThanks in AdvanceShiv
17 Aug 2010 by Ankur\m/
Get Number of Days in a Month Function - SQL[^]Select Statement for Get Number of Days in a Month[^]I must tell you I got these links by Googling[^] (The very first guideline for asking a question).
22 Aug 2010 by i gr8
My requirement is to create a prompt with Yes/No which in turn should convert to 1/0 from the Universe level. Any help would be greatly appreciated
17 Sep 2010 by venki111111111111
hiI have one query in SSRS. i have a report which should be in pdf format. in that i have a table which should have 5 details ( i mean lines).Here I have question, suppose if my dataset for the table is returing only 2 rows means, I need the report should be like first two rows should...
27 Sep 2010 by benFrenkel
on ReportServer Class Microsoft.ReportingServices.RdlObjectModel.ReportXmlSerializer serializer = new XmlSerializer(typeof(Report))ther is an error System.InvalidOperationException was unhandledInnerException: System.NotSupportedExceptionMessage=Cannot serialize member...
27 Sep 2010 by DaveAuld
Have you checked to see if IsSerializable?http://blogs.msdn.com/b/jaredpar/archive/2009/03/31/is-it-serializable.aspx[^]Doesn't sound like it is....
30 Sep 2010 by benFrenkel
error with RDCE Extenstion (Rdl Reports):Login failed for user NT AUTHORITY\NETWORK SERVICEthis user have all the access to report server databasethe error is when the report have RDCE Extenstionother reports working finetank's
1 Oct 2010 by Sandeep Mewara
I think this link should be helpful: Steps to deploy and use RDCE extension[^]. Have a look.
5 Oct 2010 by vinu.1111
Hi everybody,I've created one SSRS in that I've connected to the database having four fields.Now what I want is to calculate the salary page by page and at the last the grand total.I've kept one extra column in table and kept one running field and made it as hidden. I've taken one...
20 Oct 2010 by vinu.1111
Hi.I've created one ssrs report it works well in my system.i.e http://localhost/reportserver$sqlexpressbut how should I execute in different system?If I enter the system name then it is showing page cannot be displayed.i.e http://sys1/reportserver$sqlexspress (page cannot be...
26 Oct 2010 by anil_kumar_bhakta
hi experts,i am using ms report-viewer with group. group data is of 40 chars and detail-data(below group-header in report designer) is of 4 chars. the problem is that when we go thru the length of group data the cell containing detail-data also grows as per the group-data length. when we go...
3 Nov 2010 by Ming Luo
Dear all:I am developing a win app which process and generate data dynamically. I want to use the Microsoft reportviewer to analyse the generated data. I have a few problems about the report.Firstly, can I manage the report dynamically? Can I access the report items like matrix, chart...
4 Nov 2010 by Radhakrishnan G.
HiI think we can use globalization features' For globalizationImports System.Globalization' For Indian currency formatDim ci As New CultureInfo( "en-in" )Dim someRealValue As Double = 1234.567Dim currencyFormat As StringcurrencyFormat = someRealValue.ToString( "C", ci );
8 Nov 2010 by Natongm
I am trying to dynamically render an SSRS report in PDF using the URL option. Question: Does it make a difference if the report is password protected?
12 Nov 2010 by Boroumandan
HelloI have a big problem with my Reports in asp.net.I explain it for you and I hope you can answer me, because it makes me crazy.I created a simple Report with Microsoft Report ViewerVERY SIMPLE (HELLO WORLD !!!)It works fine, but when I publish it in webserver (any webserver,...
22 Nov 2010 by ghazalekh
I need a pdf that describes microsoft report completely.Please help me!
22 Nov 2010 by Abhinav S
This[^] may help.
22 Nov 2010 by Sandeep Mewara
Google about specific things about report that you need to learn. You won't find a comprehensive PDF. Just a suggestion, demanding anything like this would not help much!
24 Nov 2010 by alex_xu0320
Hi Mark,I don't like the idea of rendering for the second time to just get the page count.Instead, I went down to the reflection path.As Mark mentioned, ReportViewer.CurrentReport.FileManager.Count will have correct physical page count for print preview mode within the event handler...
1 Dec 2010 by Sandeep Mewara
These links should help you out:Similar discussion resolved[^]Known issue with older version[^]
10 Dec 2010 by G-Tek
Hello all - we have what I believe is a relatively unique report problem (using SQL 2008 Reporting Services). We have a system where a Customer can have multiple Sites. Each Site has the need to run a report, but each Sites reporting requirement is different - so there may be multiple report...
15 Dec 2010 by makwith9789
The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. i tried to google a lot but no use ,but i figured that i am getting this error because my report server is in 2005 and i am usin 2008...