Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008-r2]

Microsoft SQL Server 2008 R2 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed.

Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.

This is a version of Reporting Services provided by SSRS

2305 questions
0
votes
1 answer

SSRS - Print tablix row header on each new page

I have a tablix which it has assigned a dataset. Tablix iterates over the dataset returned. I have placed a rectangle object with content within tablix row header and check the option to print row headers on each new page in tablix properties. First…
Willy
  • 9,848
  • 22
  • 141
  • 284
0
votes
1 answer

How do I create a csv file in SSRS with a .txt extension in the file name?

I have a report where I have added a data driven subscription that writes the report to a folder location on a daily schedule. The report is rendered as csv. the file name comes as MyReport1234.csv. I need this to be Myreport1234.txt. How can I do…
Nandun
  • 1,802
  • 2
  • 20
  • 35
0
votes
1 answer

SSRS create Age range

I'm trying to make a report that will display how many patients came in during a specific time frame for an age range. This is what I got so far, but the numbers its outputting are wrong, so I'm not sure what I missed. I've followed a couple of…
mol
  • 73
  • 10
0
votes
1 answer

Subtotal filtering without a group

I have a report with 5 groups in a Tablix. I want to have 15 total lines based on a filter of amounts within that group. A simplified version: Group1 Cost Center Relationship Type Amount A 100 Rel1 Small 100 A 100 …
user1612851
  • 1,144
  • 4
  • 18
  • 32
0
votes
3 answers

Filter is not working with charts in SSRS

Today i have one problem with charts in SSRS as per below i want to generate filter on charts so for that i added one parameter(@SaleYearParameter) in dataset query. SELECT COUNT(*) AS SaleCount, pc.Name, YEAR(so.ModifiedDate) AS SaleYear FROM …
Nikhil.Patel
  • 959
  • 9
  • 17
0
votes
1 answer

#PERCENT with a Map in SSRS 2008

I am using SSRS 2008 R2 and have the following map. In my opinion, it looks very ugly with all of the zip codes showing for each area so what I would like to do is only show the zip code when the area has more than 10% of the total number of people…
K. Fenster
  • 91
  • 3
  • 15
0
votes
1 answer

SSRS - One Tablix with two datasets not using lookup or inputting a tablix within a tablix

So Here is my dilemma, I have a sql table named Column_Names that has a column that displays names (field names in an application) and another column that displays sort_order. I then have a view named A_to_B that I created that has all the values…
ItalianStallion4215
  • 139
  • 2
  • 11
0
votes
1 answer

Can an SSRS report be aware of its filepath?

I'm working on SSRS reports and I'm trying to dynamically change the SQL based on which folder a report is in. The same report will be deployed into two folders but the SQL needs to be different based on the folder. My thoughts is that if I can…
Dexter
  • 337
  • 1
  • 3
  • 12
0
votes
1 answer

Pivot a table in MySQL and add column headings

I have a very small set of results generated in MySQL. These results need to be displayed on an SSRS report line graph, but in their current format this seems to be impossible. This is the current result set: and this is how I think it may work I…
Mac
  • 15
  • 3
0
votes
1 answer

Formatting Day Time X Axis in SSRS Charts

I am working on a SSRS report which compares data of 2 given months. I'm categorising the chart based on Day and time in the following format 1, 6:00 AM. I get this column from the T-SQL itself. But the axis does not come properly. It looks like…
RMu
  • 817
  • 2
  • 17
  • 41
0
votes
2 answers

SSRS background color expression based by date value

Here is my issue, I have a table in SSRS that I've created that has a due date field (RegulatoryDateDecisionDue). Based on that date field, I need to change the colors of the rows if today's date is past the due date the field should be red. If the…
ItalianStallion4215
  • 139
  • 2
  • 11
0
votes
2 answers

SSRS How to create horizontal straight line in a Line chart

I am trying to create a straight line on a line chart showing other data. The line will present what is the good level within the levels for what the original data is actually presenting. I am trying to create the red line on the attached image:
user3382674
  • 7
  • 6
0
votes
1 answer

SSRS big gap between chart and table beneath

I use SQL server 2008 R2 Report builder 3.0. There are one chart and one table in my SSRS report. When I preview the report, there is no gap between the chart and table. However, when I receive the subscription of the report in MHTML format. There…
Ice
  • 429
  • 2
  • 6
  • 19
0
votes
1 answer

Asp.Net Core 1.0 and SSRS

We are working on Asp.Net Core 1.0 application, and we would like to display SSRS reports from the application but unfortunately SSRS is not supported in Asp.Net Core 1.0, may any one help with this dilemma?
Shaban
  • 11
  • 4
0
votes
1 answer

SSRS Subtracting matrix column based on value to total

I have a data grid using Matrix that contains 3 columns (PADate, LineOfBusiness and Total). PA date is the row group and the Line of Business is the column group and I'm adding the total records in the line of Business. The line of business has…
Arsee
  • 651
  • 2
  • 11
  • 36
1 2 3
…
99 100