Click here to Skip to main content

Submit your article

SSRS

SSRS

Great Reads

SSRS Multi-Data Source DPE (Data Processing Extension)

by jkrebsbach

A way to combine data from two different sources into one datasource for SSRS reporting

System Availability Charts in SSRS

by Sichen D

How to build system availability timeline in SSRS

Get SSRS Report Information

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.

Create a custom report for displaying SSRS report usage details in SharePoint 2013

by senthill

This article describes how to create a usage report for SSRS reports that are hosted in the SharePoint Site.

Latest Articles

Running a RDL/RDLC (SQL Report) in ASP.NET without SSRS

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

Install and Configure SQL Server Reporting Services (SSRS)

by Hardik.Sheth1717

How to install and configure SSRS

Publish RDL Files To SSRS using C#

by Sameh Abdel Mongy

Deploy Reports rdl files to SSRS using C# script

SSRS Reports: Show Data from Non-standard Provider

by Michael Ecklin

SSRS Reports: Show Data from Non-standard Provider

All Articles

SSRS

convert varchar to datetime

21 Jan 2011 by #realJSOP

google "t-sql convert var char to datetime" for more info, but basically, it goes something like this (your needs will most likely be different):CONVERT(DATETIME, SUBSTRING(datefld,5,4)+SUBSTRING( datefld,1,4),112)

SQL-Server-2005

Variable not defined message is being thrown

8 Feb 2011 by #realJSOP

Make sure the variable's access level is public.

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

reporting-services

Get list of catalog items for a particular user using SSRS REST API

1 Dec 2021 by #realJSOP

I have never had to deal with SQL reporting, but... 0) There doesn't appear to be a Rest API that provides that functionality. 1) You can use ADO.Net to submit that query to the report server. 2) I suggest changing the query to this, so you...

How I Integrate SSRS Reports In VB.NET Project .

6 Dec 2014 by /\jmot

Repost of this..How Do I Integrate SSRS Reports In VB.NET Project .[^]Few Links..Building Your First SSRS...

How to email Rendered Report in diffrent formats like pdf,excel,word in Report Viewer in Local Mode and Modify Tool bar of Report Viewer

15 Jan 2013 by 187ShashankJain

Hello,I have an issue related with Report viewer control Version=10.0.0.0i am showing SSRS Report(.rdl) file on report viewer in Local Mode.I need two things to be done,1. How can i email the rendered report in diffrent format like pdf,excel,word. 2. Add an email button in Report...

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

reporting-services

How to use multiple iif in ssrs?

26 Dec 2012 by __TR__

Try using the Switch function.Here is an examplehttp://www.bidn.com/blogs/ChrisAlbrektson/bidn-blog/1478/ssrs-switch-function-examples[^]Edit:If using Switch function is not an option, you can use nested If as shown...

get Only single column value

16 Jan 2014 by _Kapil

When I hanve data with more then one row ,I have a column where i want to show column value into the text box.But unfartunate it get sum of all value in same column.eg dataset structerid name marks totalmarks1 kapil 10 502 kapil 20 503 ...

Showing custom Progress Indicator while loading report in SSRS

12 Apr 2011 by a.g.mohod

Hi All,My reports shows an animated GIF image as Progress indicator. But few of reports are too large and to endusers, they seems to be hanged. So is there any method to show more specific upload progress? like displaying something like : "Page 12 of 700 Loaded.." or "500 More Pages to...

Send Data from Front end to ssrs reports

4 Oct 2013 by a.pkumar

Hi, I was new to SSRS reports. At present i was fetcing values from back end(Sql) and calculate as per client requirement. After completing calculation displays the list to aspx pages using html tags. I need to show the calculation details in SSRS report. As per my knowledge we can send...

SSRS Report header invisible

25 Nov 2013 by a.pkumar

Hi, I am new to SSRS reports. I need to show multiple headers in the report.ex:Jan Feb Mar AprData from Back endMay Jun July AugData from Back endSep Aug Nov DecData from Back endproblem was when data was not found, i need to hide all...

populating rolling 12 month figure

12 Dec 2011 by A180884p

Hi,I was wondering if anyone could assist. I need to populate a figure in a ssrs reporting that showing a rolling 12 month figure. My codes consists of data for 24 months. should i populate this field in the SQL or is it better to calculate it in reporting services?Kind Regards

Danish Language Installation for Full Text Search Index

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.

Create job to export Stored Procedure daily

27 Nov 2012 by Aadhar Joshi

Creating job in sql server which automates taking backup of all stored procedures and functions in physical drive.

SQL-Server-2008

SQL-Server-2005

Suppressing page breaks when multiple SSRS reports are rendered on a single web page.

30 Apr 2012 by aakar

I have 3 SSRS reports displayed to the users on a single web page.I have added page breaks so that when the users want to export these reports to excel, they get exported to separate worksheets in excel.However, when the users view these SSRS reports they need to be shown on a single web...

Multi value parameters with the 'IN' query.

17 Nov 2012 by aakar

Hi,I have an SSRS report with @Region as a parameter used for filtering values as per the region.The @Region parameter can take the following values :AmericasAfricaAsia-PacThe report works fine if the user chooses Americas or Africa but if the user choosesAsia-Pac, the...

Report using excel sheet as data source not working when deployed to production.

14 Dec 2013 by aakar

Hi!I have a set of SSRS reports that use an excel sheet as a datasource.Now when I preview the reports or run them in the Visual Studio IDE on my local machine i.ethe development machine, the reports run fine & display all correct results.However, when we deploy the reports to the...

SSRS and .net tutorial

2 Jan 2013 by Aarti Meswania

I need some guideline for start working with ssrs and .netI have familiar with .net, sql and crystal reports...so, please suggest some good articles. Thank you, in adv. :)

Is it possible to use SSRS for Winform for Standalone PC

2 Jan 2013 by Aarti Meswania

I have learn easy tutorial for SSRS,...Getting started with SQL Server Reporting Services[^]Now, I want to know can I use it without deploy on serverBecause I am using Winforms, I require it for stand alone machineIs it possible? thanks for read, please reply and clear doubts if...

Is it possible to use SSRS for Winform for Standalone PC

2 Jan 2013 by Aarti Meswania

I have got a solution,useful links are as below...http://pashamblog.wordpress.com/2011/04/07/creating-local-report-using-ms-reporting-services/[^]Microsoft Reporting Services - Part II[^]Happy Coding!:)

Repeat textbox in each page in SSRS.

19 May 2013 by Aarti Meswania

Try this...insert table in report body partin table header put title for subreportin table body put sub reportHappy Coding!:)

Average between two date columns

24 Jan 2016 by Aarti Meswania

hello,There is something wrong in logic.Logic should be as below.. prepare formula accordingly.VAR AverageDiffInMinute = Datediff(Hours, AppDate, DecisionDate) / 2( AverageDiffInMinute % 60 ) % 24 = AverageDAYSAverageDiffInMinute - (AverageDAYS * 24 * 60) =...

Sorting issue when SSRS report is viewed without toolbar in sharepoint 2010

9 Nov 2010 by AbbasKapasi

Hi,We have created a SSRS report over the analysis services database.This report is added to a web part in sharepoint 2010. When we sets the toolbar to be visible, sorting works fine but when it is made invisible, the request is not going to the report server and it shows report server...

Microsoft Report Viewer Not working on live server

8 May 2013 by Abhai Oza

Some server support report viwer so change server or report display on excel or pdf format.

SubReport not showing Mian Report rdlc

9 Dec 2014 by Abhi KA

I was generating rdlc reports like below code:var proposalFor = ecmClient.ServiceProxy.GetProposalFor(projectId); LocalReport localReport = new LocalReport(); localReport.ReportPath = Server.MapPath("~/Reports/TCOSummary.rdlc"); ...

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

reporting-services

If I Change The Data Source Then How It Will Apply To All Rdl Files.

14 Sep 2014 by Abhijit Parab

Hi, My query is regarding SSRS. I have one ssrs project. I am using same for two different web applications.Difference is that both web application has different database so accordingly i have to change the SSRS settings before deploying the ssrs project. Whenever i change the...

Can't connect to Report Server Server via SSMS

21 May 2012 by Abhinav Alok

Hi All,I have a local installation of SQL Server 2005 (standard) on window XPsp3, with Reporting Services, Integration Services, and Analysis Serverinstalled.I can connect to Integration Services and Analysis Server via the SQL ServerManagement Studio, but not to the Report Server....

SQL-Server-2005

How to authorize user to view report in SSRS 2005

18 Jul 2012 by Abhinav Alok

Hi All,I have created an ASP.NET 2.0 web application and would like to use SSRS 2005 for reporting purposes.The web application uses forms authentication and custom roles for authorization. I have created reports and deployed it to a our SQL Server 2005 box.I have Used ReportViewer...

how to make a link in one of the column in the main report to go to another sub report.

9 Mar 2011 by Abhinav S

Maybe this[^] discussion can help you.

How to develope Mobile Application using Asp.net to generate reports

20 Dec 2011 by Abhinav S

Read more about this topic at these links...

SQL-Server-2008

Comparison between Crystal reports and SSRS

16 Jul 2012 by Abhinav S

I guess based on this article[^] on msdn, you can export to PDF.Regarding speed, I guess it could depend on your scenario.These posts compare the two...

How to Sum In SSRS in grouping

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

How to Disable windows security popup using web.config or Asp.net application

23 Sep 2013 by Abhinav S

You need to try by disabling windows authentication in IIS (where the site is hosted).

Local RDLC tablix get expand from second page

8 Sep 2014 by abhipriy

I am using Rdlc report in windows application. rdlc report is working perfect but the only problem with the design. when running the report in reportviewer design is constant on first page but from second page TABLIX get expand around 1" Right and Top.Properties I have...

Create an assembly to decrypt data in SSRS 2008 R2

3 Nov 2012 by Abhishek Pant

Hi,have a look at this-Encrypt and Decrypt function in SSRS[^] &Recover SSRS Encryption Key[^]

How to convert Blank and null values to zero in ssrs expression

18 Dec 2012 by Abhishek Pant

this may help you-convert null to 0 in ssrs[^]Using Custom Code References in Expressions (Reporting Services)[^] ISNULL( fieldname, 0 ) or IIF( fieldname IS NULL, 0, fieldname )

Deploy ssrs 2008 on win xp, win 7

22 Dec 2012 by Abhishek Pant

Have these article/tutorials for deployment of ssrs reportsSSRS Series Part I: Various ways of Report creation, deployment and invocation[^]Deploying Reporting Services[^]Deploying SSRS reports 2008,R2 and 2012 , fixing Rsaccess denied[^]Deploying a report to the Server[^]It...

SSRS and .net tutorial

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

Report Server URL in SSRS

2 Feb 2013 by Abhishek Pant

Error Message: 403.2 Forbidden: Read Access Forbidden[^]FIX: You receive a 403.2 error message [^]

Adding a column in sql result set

7 Oct 2015 by Abhishek Pant

Hi,I have two table valued functions as T1 and T2and executing this I get T1 data as ParameterID Parametername ParameterDoc 1 French French Data 2 German German Data 3 Polish Polish Data ...

SQL-Server-2012

External Images are not getting displayed

20 Mar 2014 by abhishek.mumbai

Hi GuysI am trying to use external image in SSRS rdl. it is displayed correctly in rdl design windowbut when I try to view in preview the image is not displayed.I have been using the following url to get image (due to security issue I cannnot directly point to...

The permissions granted to user IIS APPPOOL\ASP.NET v4.0 are insufficient for performing this operation. (rsAccessDenied)

20 Mar 2014 by AdamASPGeek

Hi Rajesh,Please just test to grant full permission to your folder. Access is denied basically happen when you dont have full priviledges.

Reporting Services paging and sorting issue

3 Dec 2013 by AdhocReporter

I have a ssrs report with paging set to 20 records per page . I have used interactive sorting to sort the data . When i sort the data it is sorting for that page only . I want the whole dataset sorted and then rendered by paging . It is splitting and sorting ... what i want is to sort and then...

How to convert Big integer value to string (as Million)

18 Nov 2014 by Afzaal Ahmad Zeeshan

You should be converting them to words, by checking their range of size. Read the number, and convert it to a user-friendly string.This[^] one blog post has the source code for a simple application to get the numeric data, and convert it to its representative string, spanning upto "million"...

If I Change The Data Source Then How It Will Apply To All Rdl Files.

25 Sep 2014 by Ahmad A.A. Ahmad

Hi, make sure all reports use the SharedDatasource, so when you change the setting of the shared datasource it will apply automatically to all reports in the project.I hope this help. tell me if not.Regards, Ahmad

Generate Row Number Of only Visible Rows In ssrs?

25 Sep 2014 by Ahmad A.A. Ahmad

Hi Jigs,try this =RunningValue( IIf(Fields!StepID.Value = 5, Nothing, Fields!StepID.Value) , CountDistinct , "Tablix1")change the condition in IIF statement with the condition you used to hide the rows, if it doesn't work please provide me with the result set in details....

Combining MDX with T-SQL in One Result Set for SSRS (Hybrid Query)

27 Sep 2014 by Ahmad A.A. Ahmad

Combining MDX with T-SQL in One Result Set for SSRS (Hybrid Query)

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)

SQL-Server-2012

reporting-services

Using Recursive Hierarchy Group in SSRS 2012

5 Jan 2015 by Ahmad A.A. Ahmad

reporting-services

I am getting an error "A connection attempt failed because the connection party did not responded"

15 Oct 2015 by Ahmed Abdulrazik

Hello everyone, I am changing all reports in our system from crystal reports to SSRSall the reports are located on a remote server, when I try to connect from localhost to the server using VPN no problems happen and the reports work fine but when I hosted the website on IIS of a server and...

My Report Doesn't show any Data

11 Nov 2015 by Ahmed Abdulrazik

Hi All, I have a report made with SSRS, the report data doesn't show up the SQL stored procedure is working fine the report is working fine on my PC and on the server and showing data. The problem is when I add a webpage with a report viewer in my website toshow the report it only shows the...

How to set an alternate row color in SSRS 2005

26 Aug 2010 by Ahmed_Said

reporting-services

SSRS and N-Tier Architecture

8 Feb 2013 by AhmedYehiaK

Hi all :)I'm new in reporting service so i'm very confused about interactions between application designed in 3-Tier architecture and reporting service reports How i can dealing with reports??What is the best practice in 3-Tier and reporting service??What about report server??Where...

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

reporting-services

The item '/Report' cannot be found. (rsItemNotFound)

10 Apr 2019 by ajays3356

Hello I had created an ssrs report but while viewing it on browser I am Getting an following Error..The item '/Report' cannot be found. (rsItemNotFound)My source file

SSRS Report with Single and Multi Selection Parameter using MDX Query

22 Jul 2014 by Ajit Kumar Thakur Microsoft

This article is based on SSRS report with single and multiple selection parameter controlled through MDX query. SSRS report passes parameter. MDX query reads record from cube based on given parameter.

Get SSRS Report Information

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.

How to Make a report automatically render to excel

15 Nov 2012 by ajulot

Hello All,I have a report that I created with multivalue parameters (some which have default values and some which don't). The user selects relevant parameters and subsequently clicks on the format he/she wants to view it which in this case is in Excel format.My question is how do I...

Get the background value of a table row in reporting services

26 Sep 2012 by akosidab

Hi,I would like to ask if there is a way to get the background color value in reporting services 2005?Thank you in advance :)

SSRS 2005 not rendering in Google Chrome

8 Oct 2012 by akosidab

Hi,My report renders good in IE and FireFox, but in Google Chrome, the report does not shows any data. I'm using SSRS 2005. Is this a bug in Chrome?Thanks

Change the text of (Select All) in multi-parameter in SSRS 2005

9 Oct 2012 by akosidab

Hi,I would like to ask if it is possible to change the text of (Select All) in a multi-value parameter in SSRS 2005. Thank you.

SQL-Server-2005

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!

reporting-services

How to break large data into worksheets while exporting to excel in SSRS

10 May 2011 by Aksh@169

Hi,I have an rdl that is mapped to a stored procedure that fetches 2 lac rows.I need to export this data into excel but to to upper limit on the row count in excel I am getting an error that says that max row count exceeded.Can anyone help me figure out how can i split this 2 lac row...

ssrs export to excel wrap text issue

21 Jun 2017 by Akshat Bhasin

Hi AllIn ssrs reports (sql server) when I try to export the report in excel, the columns have wrap text option as enabled. I want to disable it. Please suggest..

Is there a way to add datasource of Analysis Services intead of SQL server ?

10 Mar 2010 by Alaric Dailey

Here is the page from MS on how to do just thatCreating Report Datasets from SQL Server Analysis Services

web_development

grouping for a mtrix table ?

1 May 2011 by Albert Holguin

No code? You have to try to get people to want to help.

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

reporting-services

need tool for rpt to SSRS conversion but free

2 Aug 2012 by Ali_100

I have approx 80 rpt files ,the client want to convert them in to ssrs, is there any free tool?

Download & installatio of SSRS in MSSQL 2005

5 Aug 2012 by Ali_100

Hi,folks.I have installed sql server 2005 express edition from visual studion 2008,now i want to install sql server reporting tools.from where i can download which is compatible with my MSsql2005.

SQL-Server-2005

conversion rpt to rdl(SSRS)

9 Aug 2012 by Ali_100

I have a project in V1.1,Now we have to convert in VS2010 V4,so we have to convert many rpt files to SSRS(rdl), if any one knows how to convert RPT to RDL then give me a better example to understand,actually i am also well expert in rpt.any suggestion will be also appreciable

SSRService with sql 2005

11 Aug 2012 by Ali_100

I have sql express which was installed when i was installing VS 2008.. now i want to install SSRS, i know sql 2008 can have SSRS but i can't install SQL 2008,, is it possible SSRS can be installed with having compatiility with sql 2005,?& from where i can download the package?

SQL-Server-2005

Download SQL 2008R2 (Suggestion required)

11 Aug 2012 by Ali_100

I am going to download SqL2008 R2 ,, actually i want to work on RDL files(SSRS) so which version should i download?my PC ram is 1 GB only,processor is 2.8

SQL-Server-2008

SQL-Server-2008R2

configuration of Reporting services

13 Aug 2012 by Ali_100

The configuration of Reporting services is neccessary for what purpose?even i can run the rdl file in the project,.?

the source of report definition has not been specified

17 Oct 2012 by Ali_100

I am getting the error "the source of report definition has not been specified",kindly help me this is my codeReportViewer ReportViewer1 =null; try { rptData = new DataSet(); objReportHelper = new ReportHelper(); ReportViewer1 = new...

Embedded image in ssrs

22 Oct 2012 by Ali_100

I have an image in binary form that is called embedded image,If I included an image in report by any folder is this also call embedded image?

want to use 3 tablix in a SSRS in 1 page

1 Nov 2012 by Ali_100

Hi,I am new in SSRS ,actually i have a situation here that there are 3 tablix in a rdlc page.it is ok.but the issues raising is that in display mode it shows all the data of 1st tablix,later it shows 2nd tablix data ,& in the last it shows the 3rd tablix.I need to show all the three...

How to sync parent & child data per page?

1 Nov 2012 by Ali_100

I am migrating crystal reports to ssrsIn crystal reports:there are two Details section i.e. details section A and details section B. section a contains parent data in tabular form hooked with a dataset and in section b there is a subreport containing corresponding child data hooked with...

Extra page issue in rdlc Main report with 2 sub reports

14 May 2013 by AliBasha

Hi, I have set everything which need to be done to avoid extra page issue in rdlc, that is all Margins 0in and Width 8.5in and Height 11 in. And I resolved extra page issue in all rdlcs, but I have struck with one Rdlc which contains 2 subreports. Previously It was giving 2 empty pages,...

Extra page issue in rdlc Main report with 2 sub reports

14 May 2013 by AliBasha

The only solution to resolve these kind of issues(extra page issues in rdlc) is ....In the report designer, reduce the width of the table and report body.Keep this relation in mind:report body width must be

SSRS Connection Error

23 Sep 2015 by AlRosner

am getting the following error when attempting to run an MVC website in VS2013 and SQl Server 2014 using the ReportViewer control and accessing a report from the report server:RSExecutionConnection MissingEndpointException: The attempt to connect to the report server failed. Check your...

How to get total of a column in ssrs

29 Mar 2015 by amazingavis

how to get sum of a column in SSRS using matrix.

what's the difference between .rdl and .rdlc reports

23 May 2011 by ambarishtv

this link will give the difference between .rdl and.rdlchttp://forums.asp.net/t/1173578.aspx/1?Difference+between+rdl+and+rdlc+files+[^]http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/a5f67556-7223-492f-b8d8-77b118b2cb2c/[^]

In ssrs report when export report in pdf along data generated properly but chart display on next page

23 Sep 2012 by Ambesha

please use a group container for same or if nessesary then use the page break at desired location.

Getting error in SSRS

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

How to Save the PDF by Specific name in I.E

15 Sep 2013 by Ambivert

Hi all,I have one requirement when we save any generated PDF it's taking the name of page but I want to give the specific name. I have tried it with code change but no help,In Mozilla its working fine but in I.E. its not working , Any one face the issue before please help me.Code :Dim...

How to get rank in SSRS? Similar to DENSE_RANK Function in SQL Server

6 Feb 2012 by Amir Mahfoozi

Here it is :SELECT * , rank() over (partition by shift order by total desc) ShiftRank , rank() over (order by total desc) AllRank FROM AgentsHope it helps.

SQL-Server-2005

New BI Semantic Model Connection

12 Jul 2013 by amirrajaee

I am trying to create a BI Semantic connection in SharePoint 2013 but I face the following error:The database is not using in memory storage engineI have:SQL server 2012 Business Intelligence SP1SharePoint 2013AdventureWorks2012 multidimensional DBAppreciate any help to solve...

microsoft bi semantic model for power view is missing in data source

6 Aug 2013 by amirrajaee

I want to create PowerView report from shared data source and create .rsds file in data source. but i can not find the "Microsoft bi semantic model for power view" in drop down listsharePoint site> Documents> files> new file> Report data source> Data source typeAppreciate any help how to...

SSRS on Sharepoint looses stored credentails for datasource library every night

12 May 2014 by Amit Sk Sharma

Hi ,I am facing a strange issue here, where the credentials configured for SSRS integrated on sharepoint are lost. we are providing database level credentials every day to SSRS reports configured on SharePoint.I need some direction to investigate the possible reasons for this, and it...

Display some text from database in every page in rdl report

20 Oct 2012 by AmitGajjar

Hello,I have never worked on RDL reports but i need to fix one issue. i have search in google but coudn't find any workarround.Here is my issue,I have one report which group some filed and display page wise in rdl report. now i would like to display some value(from database) after...

SQL-Server-2005

I have to dynamically create a report. This report should be opened in pdf format. I have to do this task using asp.net and sql. How to achieve the same.

29 Oct 2012 by AmitGajjar

Hi,Hope ReportingService.Render[^] may help you to generate PDF from your SSRS report.Best luck.

Is there any way to set order of parameter

25 Apr 2013 by AmitGajjar

HiAs per your information from the comment, below solution may work for you.you need to pass index of the column in the query to sort your data.like select * from table order by 1above query will sort your table with order by first column. so from database you need to pass index of the...

How to color region between line charts in rdlc report?

3 Jul 2015 by Amol_Khairnar

How to color region between line charts in rdlc report I have various line series in my line chart graph and I want to color between the two line charts in RDLC Report??

Hi bill, do you still having the barcodelib.dll?

28 Apr 2022 by ana_naye

I Want to publish my report in ssrs but the barcode font did not work, so I found this article about the .dll you developed, I was hoping it can help me. What I have tried: I installed the barcode font but it did not work when I try to publish...

Export to TXT format

15 Jul 2010 by anandhakrishnabca

Hello Friends,My requirement is bit weird. I am using SSRS 2008. I have created a report and the datasource is SQL sever 2008. When i export to TXT format i have to have a record limit of 80,000. If it crosses 80,000 records, i have to export it into another file. I have actually created a...

Export to TXT issue in SSRS

10 Aug 2010 by anandhakrishnabca

Hello Friends,I have written a stored procedure in SQL server 2008 and that will return records like below format.Report Title|Todays date1|Anand|Soft Engg|20-oct-19872|Gowrish|Soft Engg|07-DEC-1987Total Records CountThe first line is nothing but Header and the last line is a...

Cascading input parameters

4 Dec 2011 by anandhakrishnabca

Hi Friends,I have created a report in SSRS 2008 (SP1). It has three input parameters (Division, Business Area, Business Unit). My requirement is when i select a value from Division, the corresponding business ares to be populated in the second drop down Business Area. When i select a value...

SSRS 2008 Report Model

24 Aug 2011 by anandhakrishnabca

Hi Friends,I supposed to create a Report Model which will be consumed by the End users to create ad hoc reports using Report builder tool. The Report Model can be created using the Report Model Project in Business Intelligence Studio. It has 3 stages to create the Report Model.1.Data...