Tagged Questions

SQL Server Reporting Services (SSRS) is server-based report generator from Microsoft. It provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your ...

I created a report in SSRS reporting tool,
then i uploaded it to my dynamics CRM.
the reports run against the CRM database, the report tested from my VS data tool.
but after uploading it to MS CRM the ...

I have the follow custom function that I am using in an SSRS report in order to calculate an average value using the LookUpSet function. I have a number of results in the set that are returned that ...

I am using SQL Server 2008 R2 and I would like to use CIRCULARSTRING to draw a circle. I could use the POINT and STBuffer but then the circle is filled with a color, while I want the outline. Trying ...

I create reports using Microsoft reporting services with Oracle database. All stored procedures are contained in the package. I can't deal with the package. If you have any advice, I will be happy and ...

I have 2 columns next to each other in a report I'm building. They contain the same structure, with one small difference. One column looks back in time a little further then the other. I have verified ...

From a database I get information about collaborators. The collaborators can have a different number of images. E.g. one collaborator has four images, another one only one. In this example I would get ...

I am creating a report and have an issue to concatenate strings within a group. E.g. I have the following structure of a table
NameOfPerson | Country | State
I grouped the table by NameofPerson and ...

I have a report which shows an image from the database and some text below and above it. The size of the image can vary.
At the moment I have the image in the same table as the text. I basically want ...

How to add summary row per page without group in SSRS. I don't know how long per page is. and I don't want to fixed on row number because i don't know how long of content per cell.
So Is there anyway ...

I'd like to create a pie chart from a dataset that returns a single row with multiple columns in SSRS. Is this even possible?
I've tried unpivoting the data so I can have multiple rows, and I can't ...

My customer has a SSRS report deployed on their SharePoint Site. I am supposed to use ReportViewer to access that SSRS report in asp.net
Here is the code I implemented,
public partial class _Default ...

I have to create a report that looks like below. All the months are dynamically called through Matrix report. And i am not able to place the heading "Yearly Counts" that also dynamically varies with ...

Microsoft says that you cannot allow multiple values for a parameter in Report Builder 2.0 when using stored procedures.
https://technet.microsoft.com/en-us/library/Dd207127(v=SQL.100).aspx
I cannot ...

I am working to develop a Java application that will eventually print out SSRS reports developed for specific queries.
The application begins with a form that queries a database for members that fit ...

I have a table with latitude and longitude data. What I want to do is plot it on the map so that I can visualize the locations a user has visited. In my table I have userid, latitude and longitude of ...

I have URL to SSRS 2008 r2 server which respond with dynamically generated png image with report.
When I paste this url into the browser the image is downloaded and saved.
On the other hand, I have ...

I'm new to SSRS and have been asked to add custom authentication for access to Report Server and Report Manager on SQL Server 2012
I have been following the instruction by Codeproject
In detail:
My ...

I am using sqlserver 2012 Reporting service,
How to achieve custom authentication in SSRS report access.
In detail:
to achieve custom authentication in SSRS report,Need to call logonuser method from ...

I am new to SSRS but have plenty of experience with Crystal Reports and am trying to do something that in Crystal is fairly simple but after hours of frustrating research it appears is very difficult ...

My issue is that data is getting repeated on the next page if the data is not able to complete on the previous page. For example, I am displaying information on a person. The information will start at ...

My team are in the process of recreating BO reports (infoview) in SSRS via oracle stored procedures and some of these reports have custom variables at report level (equivalent of expressions in SSRS)
...

I look on www and see some post how to do this, but I could not complete it.
I have mean and median on my chart, and I want to display their values (no data point as there are too many of them, this ...