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.

Using Recursive Hierarchy Group in SSRS 2012

by Ahmad A.A. Ahmad

All Articles

top

Reporting services

Variable not defined message is being thrown

8 Feb 2011 by #realJSOP

Make sure the variable's access level is public.

SSRS

reporting

reporting-services

Custom ssrs expression not working when trying to connect SQL server 2008 servers

6 Sep 2018 by #realJSOP

I found this with a google search: "SQL Server 2012 Reporting Services can use SQL Server 2005, 2008, 2008 R2, or 2012 databases as the data source. Besides, SSRS 2012 report server catalog database can also be hosted in SQL Server 2005, 2008, 2008 R2, or 2012 instances. Since you have turned...

How to stop/remove duplicating rows in ssrs

14 Mar 2017 by $*Developer - Vaibhav*$

Please refer [^]

SSRS-2008

reporting-services

Group by query in linq

20 Nov 2014 by /\jmot

see this..Updated...

Deploying SSRS Reports on client's location

22 Jun 2011 by 2irfanshaikh

I think the links given below will help you.http://reportviewer.codeplex.com/[^]http://social.msdn.microsoft.com/forums/en-US/vsreportcontrols/thread/5aa7eee7-d4a7-427a-ab8d-7a3d4d4f0bf3/[^]

Crystal Report with HTML Parameter

28 Sep 2013 by _ProgProg_

hi Guys,I've a serious problem in dealing with Crystal Reportsi am sending the to my report a string parameter called 'MyContent' which contains HTML Text with some beautiful designI Formatted this field's (Text Interpretation) -in crystal report- to be 'HTML Text'I also changed...

ASP.NET

CrystalReports

reporting-services

Error When ASP.Net Website with Crystal Report is deployed on a a dedicated server

29 Sep 2013 by _ProgProg_

Hey Every one,I am facing this Problem While Deploying my website with Crystal Report on a dedicated serverERROR:Retrieving the COM class factory for component with CLSID {059AC10F-0010-4C43-8876-1FC7BEAF218B} failed due to the following error: 80070005 Access is denied. (Exception...

ASP.NET

CrystalReports

reporting-services

Merge two array of bytes in one pdf file

27 Jun 2016 by _ProgProg_

Dears,I have two array of bytes each one of them represents a report of one page.i want to to merge them and generates a pdf report of two pages.how can i do that?What I have tried:byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out...

Convert a multiple page rdlc report into one page with vertical scroll bars on the web

27 Mar 2017 by AbdAlbaset AbdAlsamed

Hi, For me since I've static content (typically legal contract) to be shown in one page with vertical scrolling without pagination. it was just on report go to properties box, InteractiveSize => Height:0

.NET

.NET3.5

reporting-services

Incorrect total pages in SSRS (2014) report for PDF

16 Jul 2021 by abhi22bhosekar

I am working on the Invoice Report(SSRS 2014) which is a huge report consist of multiple sub-reports for notes and Terms and conditions. I have used Standard Global Variable to show the page numbers as : Globals!PageNumber & " of " &...

SSRS

reporting-services

conditional sum in rdlc

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))

reporting-services

datagridview to crystal reports

2 Apr 2010 by Abhinav S

See here[^]. This article covers datagridview to crystal reports.

C#3.0

CrystalReports

reporting-services

microsoft report

22 Nov 2010 by Abhinav S

This[^] may help.

reporting

reporting-services

Which reporting software is free of cost and open source ?

14 Dec 2017 by adriancs

Option 1: Do a HTML page and print it. Option 2: Do a HTML page, convert it into PDF, transmit it to the client and let him decide whatever action he (i.e. print)

reporting-services

Use Chart Item in Your SSRS Report (% Labeling)

3 Jan 2015 by Ahmad A.A. Ahmad

How to use chart item in your SSRS Report (% labeling)

Using Recursive Hierarchy Group in SSRS 2012

5 Jan 2015 by Ahmad A.A. Ahmad

SSRS

recursion

reporting-services

How to display image from access database 2007 although all data display in rdlc

9 Mar 2017 by ahmed_sa

I have problem in display image from access 2007 database to rdlci work in windows form c# vs2015Actually i need to display image from database to more records from access 2007but i cannotin rdlc i do as following :In RDLCdrag image control to report source...

How to leave space between tables border in details section

11 Mar 2017 by ahmed_sa

I work in web application support rdlc reportmy problem i face it that no space between borders in details section i put all data in matrix control then it loop within it in detail sectionmy question how to leave space between table and another .report picture in red circle...

Margin different from first page to another page when print

12 Mar 2017 by ahmed_sa

I work in report rdlc windows form applicationI face problem the top margin of matrix control different from first page to another pagesmeaningif starting of showing data from first page is start from 2cm from top of pagein another pages it start from 0.5 cm from top of pages...

How to set number record per page for 6 ?

13 Mar 2017 by ahmed_sa

I work in rdlc reportMy problem how to set fixed number of records per page to 6 recordsin detail section i have matrix and inside it have rectangle have my datamatrix have rowgroup inside group i write=Ceiling(RowNumber(Nothing) / 2)and it have also column group and inside...

How to set an alternate row color in SSRS 2005

26 Aug 2010 by Ahmed_Said

Editing the .rdlc files

31 May 2011 by ahsan.subiya

Hello all,I have generated some reports in Visual Studio 2008.Which means I now have some .rdlc files, now I want to make some modifications related to the formating.Can any body tell me is there any feature in VS 2008 to open that files in design view?I installed the "Microsoft...

How can I display stored procedure result set rows as columns in RDLC report?

18 Oct 2011 by ajaad.md

use pivot concept

SQL-Server

ASP.NET

reporting-services

How to show tooltips in line chart of rdlc

18 Apr 2010 by ak99372

Hi, not sure if I can help as I have the same problem but I read online that this a (quoting) "known ReportViewer limitation"... I assume Microsoft is the only one who knows about this and they know it since 2006 but as "we know" they won't do hack about it. They will probably release some "new"...

ASP.NET

reporting-services

Remove extra space between body and footer SSRS 2005

13 Jan 2013 by akosidab

Hi,I have a report that looks good in view report, but when I print the report there is an extra space between the body and the footer.Any help would be appreciated.I'm using SSRS 2005.Thanks!

SSRS

reporting-services

How can I display stored procedure result set rows as columns in RDLC report?

16 Oct 2011 by al_momani

yes use report viewer it's very good and you can find very nice articles herehttp://engthunder.wordpress.com/category/reportviewer/[^]

SQL-Server

ASP.NET

reporting-services

ReportViewer (SSRS 2005): How to get correct page count in Print Preview mode

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...

SSRS

reporting-services

Sql Service Reporting In Asp.Net

2 Dec 2013 by AlexDpars

This will help you to deploy your reportsThis will help you to setup the control into you aspx webpageFor the informations concerning your server address directories will be found on you ssrs management tool on the web service tab... And the directories will be created when you will...

Change the value of a textbox in a report viewer from code VB.NET

17 Jan 2022 by alip1

I have a report drawn through SSRB 3.0. The report is of the .rdl type so through VB.NET code and Report Viewer is hooked and displayed. The data set is managed dynamically so that records can be filtered according to the user's needs. The...

Print .rdlc report without preview

23 Aug 2017 by Allan Chong

Adding on to the solution, to print directly to default printer Usage PrintRDLCReport.PrintToPrinter using System; using System.Collections.Generic; using System.Drawing; using System.Drawing.Imaging; using System.Drawing.Printing; using System.Globalization; using System.IO; using...

reporting-services

Speed up Microsoft ReportViewer and Report (.rdlc)

21 Mar 2011 by Aman4.net

Hi All,I am using Microsoft Reports for reporting. I feel its working very slow. However, Neither Data is in huge amount nor I am using join with multi tables.It takes 2.70 secs to normal view and 9 secs for print preview.if I print the report It shows Not Responding message for...

ASP.NET

reporting

reporting-services

Printing Problem in Report (RDLC)

21 Apr 2011 by Aman4.net

Hi All,I am using RDLC with custom page setting (size=> W=5.75in & H=8.5in) with Margin=0.25 (All).It print/view/export prefect copy except one problem i.e. it print four copies instead of one copy.* When i check page setup it shows pagesize as Letter.Regards!Aman

reporting-services

Call Custom Code in RDLC

29 Apr 2011 by Aman4.net

Hi All,I have made a function in Code window of Report(.RDLC) by selecting its property.Neither I can see it intellisense (e.g. =Code.FunctionName) Nor It is working If I just call it. How Should I call that function in Report?Regards!Aman

reporting

reporting-services

Report Viewer Not Displaying Selected Fields in an Embedded .RDLC Report

11 Apr 2016 by Amar Kapadia

Hello:Although I am very new to using embedded Reports (.rdlc) in WinForm applications (in C#), I think I understand the basic concepts. I've been experimenting and practicing to get better at this. Yet, I am having one strange problem. I've Google searched all this morning for a solution...

Report Viewer Not Displaying Selected Fields in an Embedded .RDLC Report

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...

SQL Server Reporting Content Type is missing

19 Nov 2013 by amirrajaee

I am trying to configure Sharepoint 2013 for Power View and I followed all the steps from this article Install Power View for multi-dimensional model[^]but I miss SQL Server Reporting Content Type in SharePoint > add content type.I appreciate if anyone knows how to fix it.Regards

reporting-services

How to Add an Image in RDLC..

22 May 2011 by Amit Kumar Tiwari

Refer to discussion @ http://www.codeproject.com/Messages/3291203/Dynamic-Image-in-Report-Viewer.aspx[^]It states that you can get the path to the folder that your app was launched from using Application.StartupPath and build the fully qualified path to your file using the Path...

C#2.0

reporting

reporting-services

I need a good material for SSRS

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...

SQL-Server

reporting-services

How To Change PageSize of RDL Reports dynamically?

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...

reporting-services

SSRS reports are not downloading

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

Displaying the groups even though they have no members

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.

How to show tooltips in line chart of rdlc

16 Feb 2010 by Angsuman Chakraborty

hi there,Can anyone help in the following issue?I have a line chart report in rdlc using asp.net.I want to show tooltips when the user positions his mouse on that line. There is an option in the properties window to set the tooptips.Suppose I set the tooptip to an expression such as...

ASP.NET

reporting-services

Customize paramter in report viewer.

23 Jul 2013 by Anh Nguyen Trong

It is easy to create paramenter in SSRS.Let try this:Normal query: Select * from Orders where OrderID > 10248. That is static condition.you change the query as Select * from Orders where OrderID > @orderidFilterThe parameter @orderidFilter will be generated automatic.You...

reporting-services

ssrs live deployment

11 Sep 2013 by Anh Nguyen Trong

let try this:1. you to report manager of live server add user that you want to deploy. liveserver\youruser2. grant all permission for that user.3. go to deploy for your reporti recommend you shuold you integration authentication and domain are the same of two computer.I have done...

Save SSRS Report as pdf using Reporting Services

3 May 2020 by Aniket Banerjee

I've been trying to convert a SSRS Report to PDF and save to my local drive using the Reporting Web Services. Though I'm able to generate the corresponding pdf file but the contents of the file are missing. I've checked that the report I'm trying to convert is not an empty one. Only the header...

SSRS

reporting-services

PDF

ms reportviewer

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...

reporting

reporting-services

How to get the number of days in a month when month name or value is provided

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).

SQL-Server

reporting-services

How can I display stored procedure result set rows as columns in RDLC report?

12 Jan 2011 by Anupama Roy

Use ReportViewer control. Have a look at this Dynamic Binding Of RDLC To ReportViewer[^]

SQL-Server

ASP.NET

reporting-services

Static Rdlc reporting in asp.net

11 Sep 2014 by AnvilRanger

Your situation is odd, but you have a few options1.Save this "manipulated" data back to you db and generate your report from that.2.Take this "manipulated" data and create some object in memory to hold it. You can use a datatable a dataset, or even a customer object. Then use said object...

crossview in fastreport

26 May 2011 by arasharash0121

hi,excuse me for my English!!i have a crossview in fastreport in my project,my cross's headers are created in runtime by (addvalue) method, i want that after completing headers, my cross is shown in center of page, but i can not do this, please help me.thanks a lot.

Delphi

reporting-services

How do I connect a PLC Rockwell Logix Controller into a SQL Database

18 Apr 2014 by Archie Jacobs

Start with AdvancedHMI. It will let you get the data from the PLC very easily. Then you can write some VB code to store it in a database.

crystal reports in vs 2008

23 May 2013 by Arun Vasu

Please check it may be help ful for youl[^]

Prepare yourself before you start migration of sql server reporting services 2005 to 2008

21 Nov 2012 by Ashrafur Rahaman

This article might be helpful for the developers who are thinking for the migration or having trouble with migration of sql server reporting service (SSRS) 2005 to 2008.

SQL-Server

Dev

reporting-services

Is there a "report this post" function in the forum?

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".

reporting-services

Customize paramter in report viewer.

23 Jul 2013 by baotdinh

Hi bro !!! I am using SSRS. I have a mone parameter. I want to mask $money for it. Example: when i input money into textbox it will auto add $ for textbox or when i preview report , it has $ before textbox parameter. I have read many topics. All of them say SSRS doesnt support it....

reporting-services

Validate date in report viewer

30 Jul 2013 by baotdinh

Hi bro !!!In SSRS, i have created 2 date parameter. But i want to validate fromdate and todate in preview screen.Example :- From Date> To Date: "From Date must be smaller or equal to Through Date.- From Date> Current Date: "From Date must not be greater than Current Date"I have...

reporting-services

Message popup in preview screen SSRS

30 Jul 2013 by baotdinh

Hi bro !!!When i view report in preview screen SSRS, if any field is blank, it will display dialog message.I want to customize validate format date same it.Now i am using display message in content...

reporting-services

Prevent view report in ssrs

30 Jul 2013 by baotdinh

Hi bro !!!I have a report when i preview , i will run automatically.Now i want when i preview, i must press "View Report" to run it.I have read :http://stackoverflow.com/questions/9154144/setting-reports-parameters-but-i-dont-want-the-report-run-automaticallyBut i want to visible...

reporting-services

Validate format date MM/dd/yyyy in preview ssrs

30 Jul 2013 by baotdinh

Hi !!!I am coding with SSRS. i dont use reportserver control. So that, i meet some problem.- I have a date parameter, when i input wrong format -> view report , it will display error message. "the value provided for the report parameter is not valid for its type."I have searched some work...

reporting-services

using Err.Raise in SSRS 2008

31 Jul 2013 by baotdinh

Hi bro !!!Now i want to custom validate for some field by using Err.Raise.I code in code tab(report property):Public Function CheckDate(StartDate as Date, EndDate as Date) as IntegerDim msg as String msg = "" If (StartDate > EndDate) Then ...

reporting-services

Blank page when visible tablix in SSRS

1 Aug 2013 by baotdinh

I have data table A, i add a tablix B contain a textbox. I set visible B, it will display a blank page. When i remove tablix B , it is OK. How can i visible tablix B and avoid blank page ????

reporting-services

Font error message in ssrs

1 Aug 2013 by baotdinh

Hi bro !!!In SSRS i have a date parameter , when i input wrong format .It informs "The value for the report parameter......"I want to know its font .Please tell me know .Thank !!!

reporting-services

Prevent auto generate Report in SSRS.

7 Aug 2013 by baotdinh

Hi all !!!I have a report with default parameter, when i preview , it auto runs report. I want report will run when i press view report . I have tried to create a blank textbox, it is right. But i want to hidden textbox when preview.If i hidden textbox, it will run auto.How can i do...

reporting-services

Add dynamic sub report

18 Feb 2014 by baotdinh

Hi pro !!!I have a context. I have a main report. In form, i have a dropdownlist to list sub report's name.When i check sub reports and press View, it will add number of sub report to main report.How can i do ???I have a way : i add sub-report to report and visible when check...

SSRS

reporting-services

Reporting Services Subscription Delivery

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...

reporting-services

XmlSerializer

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...

SQL-Server

reporting-services

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

reporting-services

Want code for date and time in reporting services

25 Jul 2010 by bhavana.patel

Today().ToStri...

reporting-services

Making text bold in SSRS depending on field's value

11 Jul 2011 by bishal agarwal

=iif(Fields!He...

SSRS

reporting-services

Sample Certificate created in SSRS

5 Jan 2016 by bjay tiamsic

Hi. Can someone help me create a sample certificate (e.g cert of employment) using SSRS. I'm having a hard time formatting it like in MS Word.Thanks!

SSRS-2008

reporting-services

Place the subreport in new page always SSRS

12 Jan 2016 by bjay tiamsic

Is it possible to place ALWAYS a subreport in a new page? Doesnt matter if the main report has no record or whatever.

SSRS-2005

SSRS-2008

reporting-services

Render and open SSRS report to PDF in another window (instead of downloading)

29 Mar 2021 by Bob Jason Tiamsic

I am having an issue rendering an SSRS report to PDF in MS Edge. It presents a new window as desired but instead of opening the SSRS report in PDF, it downloads the file directly and not showing the report. What I have tried: string...

SSRS

reporting-services

I need your help (Report Viewer Question)

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,...

reporting-services

Extra page in Reporting Services reports.

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...

reporting-services

what is wrong with this vb code in reporting?

31 Mar 2011 by calcushtag

First I know C# not VB but a littleI want to report my database with Microsoft Sql Server Report Service (it's better to say: the visual studio 2010 default reporting tools) for a windows form application.In a matrix table I have a column "result" that every time contain a float value...

table location or alignment in ssrs

31 Mar 2011 by calcushtag

In report Document I have an image, textbox, table, etc. each tools has a location property that set from left and top of page. This is good but not for RightToLeft languages! Is it possible to align a table from right edge of page for example 1cm form right edge of paper?

Custom Print Functionality for Microsoft Report Viewer (RDLC)

1 May 2012 by Chamila Nishantha

This tip describes how to create your own printing functionality rather than using built in print functionality on Microsoft Report Viewer.

How to set number record per page for 6 ?

13 Mar 2017 by CHill60

No response to comment therefore assuming this is the solution...You have =Ceiling(RowNumber(Nothing) / 2)(and also Mod 2.If you want 6 rows per page your going to need to change it to =Ceiling(RowNumber(Nothing) / 6). Because of your column grouping though I think you need to retain the...

Trim in SSRS expression

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...

SQL

SSRS

reporting-services

Required help in Jaspersoft IReport Designer

15 Nov 2012 by ChiragL

I am using Jaspersoft IReport Designer for creating a single page report to be used with my Java application. I have created the report on A4 sized page. I have added only static content on my report.....will use dynamic content also. The contents of my report do not exceed the page...

Java

reporting

reporting-services

sql query for login user id

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...

SharePoint

reporting-services

SQL Query Assistance

19 Dec 2012 by Christian Graus

This makes no sense. IF you're using the where, then you're filtering. Why do you want to filter on things you don't care about ? Why is it the case that the records you get when you don't filter, are not needed ? Are you getting duplicates and need to use DISTINCT ?What is not clear here...

Username and Password In SQL Server Reporting Services

5 Jan 2014 by Christian Graus

The username and password are the ones set up in SQL Server. You can create users in SQL Server, there is already an sa user, even if you're using integrated security instead of specifying it.Look under 'Users' in management studio, add a user with a password, then use that.

SQL-Server

reporting

reporting-services

Validate date in report viewer

30 Jul 2013 by Code-Hunt

validating-date-parameters-ssr...

reporting-services

STG_E_FILEALREADY Exists 0x80030050 ssrs while preview the report

8 Oct 2013 by coded007

Please go through below link it will solve your problemhttp://ddkonline.blogspot.co.nz/2009/07/fix-sql-reporting-services-2008-error.html[^]

Changing Calender control for SSRS Report

20 Jul 2014 by coded007

Hi All,I have question regarding SSRS reporting services. I want to change calendar control in SSRS report manager(after deploying report). Presently it is giving calendar provided by Microsoft as shown in system calendar. I want to change it. Is it possible?Thanks in advance for...

SSRS

reporting-services

Open SQL Server Report by clicking asp button

25 Aug 2014 by coded007

use this article for understanding how to call report in your asp button.Call SSRS Reports by using C#[^]for more searchgoogle[^]

reporting-services

Datagridview to crystal reports

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:

C#3.0

CrystalReports

reporting-services

Writing vertically in SSRS

9 May 2011 by cuteband

I remember there is a properties on this on how you want to display the result

SSRS

reporting-services

Calculating time interval in SSRS

29 Jul 2011 by D T B

I want to summarize a column with time intervals (total duration of conversations). Data type of the field in my database is string (varchar). I tried to convert the string to datetime, but I always got same format: 1900-01-01 hh:mm:ss. I tried to convert with 108 or 8, it doesn't matter what I...

SSRS

reporting-services

ASP.NET Session does not timeout on using ReportViewer Control.

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[^]

SSRS

reporting-services

XmlSerializer

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....

SQL-Server

reporting-services

Sql Service Reporting In Asp.Net

2 Dec 2013 by Diya Ayesa

i create sucessfully sql report in asp.net using visual stduio 2008 with sql server 2008 r2i have a report name report1.rdllnow i have a form admin option and i add tab like reportshtml ...

Username and Password In SQL Server Reporting Services

5 Jan 2014 by Diya Ayesa

I use SQL Server Reporting Services for reporting purpose and create reporting using and attach database then when I deploy any report it shows me username and password in SQL Server Reporting Service.So what does it mean by password and username and where do I get this username and password...

SQL-Server

reporting

reporting-services

Display Reports SUing Sql Reporting

2 Feb 2014 by Diya Ayesa

Using SQL Reporting i successfully deploy reports pichttp://i.stack.imgur.com/FCHen.png[^]now i want to call this reports in .aspx form and there in .aspx form there is a reports tab now i want when user click on this tab then how to link this reports to .aspx form and also i want to show...

Need some suggestions for reports that link Oracle And Sql Server data

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...

Oracle

SQL-Server

reporting-services

table adapter in vb.net frame work

18 Jun 2011 by Dr.Walt Fair, PE

Are you refreshing the report after updating the database?

Reg: Crystal Report Report Document

31 Mar 2013 by drveera

Hi,Am using crystal report in Win Forms. The record values fill in to data table, but not shown in report document. How can recover this one?. Here my code.How can recover this one? Query = "Select StudentId, TypeofInome, CourseName, CourseFee, BookFee, Paid, Balance, BillNo, Total,...

CrystalReports

reporting-services

Error when trying to access a RDL in .aspx page

15 Dec 2010 by E.F. Nijboer

Doesn't look very promising when looking at this link:http://geekswithblogs.net/juang/archive/2007/12/12/visual-studio-2008-will-not-support-sql-server-2005-reporting.aspx[^]Good luck!

SQL-Server

reporting-services

download all rdl file from server together not one by one

1 May 2013 by Elcoyote9

HiYou can see these articleshttp://sql-articles.com/blogs/download-export-rdl-files-from-report-server/[^]orhttp://www.eklectopia.com/copiar-reportes-de-reporting-services-con-reporting-services-scripter/[^]

RDL

reporting

reporting-services