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

Loop in a .bat file with different parameters

I have a .bat file which renders SSRS reports in PDF format. The report accepts 2 parameters studentID and SubjectID. This runs fine when I try to pass in each studentID and SubjectID. I would like the .bat file to execute a stored procedure which…
sqlsleepless
  • 11
  • 1
  • 5
0
votes
1 answer

Migrate ssrs 2008 r2 to ssrs 2016

The current setup of the server is Windows Server 2008 sp1, with SQL Server Reporting Services 2008 r2 installed. The databases are on a separate server which is using SQL Server 2008 r2. I have a new server with Windows Server 2012 r2, I have…
DafyddNZ
  • 234
  • 2
  • 12
0
votes
1 answer

SSRS report : How to change DataSource dynamically

I have 5 different sql servers instances with same initial catalog/database and I want to create a consolidate SSRS report which can hit all these 5 servers dynamically. To achieve this I have created a datasource DDL with hard coded values as…
Shakti Singh Chauhan
  • 530
  • 5
  • 15
0
votes
3 answers

Sort Column Group in SSRS Matrix

I created a report using matrix and I want to add interactive sort for it's column group. When I add interactive sort for Sales Amount it does not work. This is my first look of my report: and when I click on sort arrows it turn to this…
Arian
  • 12,793
  • 66
  • 176
  • 300
0
votes
2 answers

Find Row Changes and Output to Table

I have an SQL Server table of the following structure: id TransDate PartType ====================================== 1 2016-06-29 10:23:00 A1 2 2016-06-29 10:30:00 A1 3 2016-06-29 10:32:00 A2 4 2016-06-29 10:33:00…
controller
  • 185
  • 1
  • 2
  • 11
0
votes
1 answer

Dataset from a Dataset in SSRS

I laid out the report, and I do a query that returns 30+ rows for a given period of time. One for each workflow. Now, I want to take that dataset (so the query only runs once) and define 6 datasets from it that filter it based on a single selected…
Traderhut Games
  • 1,222
  • 1
  • 15
  • 30
0
votes
0 answers

Is there a limit of the output of a JOIN statement

In reporting Services, the user can choose a list with different customers. The report then generates total figures for the chosen customers. I have 2 tables in the report that incorporate the total revenue. However, when you choose all customers,…
user1261104
  • 315
  • 4
  • 14
0
votes
1 answer

SSRS: How to add Calendar Dates in Columns (tsql)

I've got the needed query to extract what data I need, but I'm having issues on how to manipulate them in Visual Studio 2008 and/or Report Builder 3.0. I want to add the calendar days of the month as a column horizontally in SSRS and I've tried many…
user3571153
  • 129
  • 1
  • 9
0
votes
0 answers

Add Barcode font to SSRS report server side

Trying to add the font barcode3of9 to ssrs report. It works perfect on local machine as the font is installed on it. I put the report on reporting server and installed the font as well on the reporting server and other end users are unable to see…
scubieman
  • 49
  • 1
  • 8
0
votes
1 answer

Parameterised report in PowerBI

I'd like to make a report in PowerBI. This report will contain graphs and details for a particular product in my system. I'd like to paramaterise this report with the product code so that I first select a product and then the report is generated. Is…
Stu
  • 2,426
  • 2
  • 26
  • 42
0
votes
0 answers

SSRS Returns Wrong End Date Parameter

From my internet page/portal I generate my report: http://localhost/BOPortal/Reports/View/Events?FromDate=2016-06-22%2022:00:00&ToDate=2016-06-23%2021:59:00&Language=en-GB&User=admin When it is run the ToDate parameter is wrong. It gives me the…
user2171512
  • 531
  • 1
  • 11
  • 28
0
votes
1 answer

Multiple OR statements in SSRS expression

How can I have multiple OR statements in an SSRS expression? Seems to be giving me an error. Here is what I have now: =IIF((Fields!PART.Value LIKE '*A2*') or (Fields!PART.Value LIKE '*A3*') or (Fields!PART.Value LIKE '*A4*') or (Fields!PART.Value…
Dom Vito
  • 507
  • 8
  • 38
0
votes
1 answer

What are the differences in drilldowns and drillthrough reports?

In SSRS, what are the differences in drilldowns and drillthrough reports? Only developers experienced working on both kind of reports can answer this. Please suggest.
Vaibhav Survase
  • 19
  • 5
0
votes
1 answer

SSRS: How to pass rowcount of a dataset from main report to subreport (child)

I have one dataset (DataSet1) in main report. The main report contains a subreport (child report). I would like to know how can I pass rowcount of dataset (DataSet1) in main report to subreport (child report). DataSet1 returns 1, 2 o 3 rows…
Willy
  • 9,848
  • 22
  • 141
  • 284
0
votes
1 answer

SSRS Formatting Number

I'm having troubles using an expression in one on my textboxes. I need all null values to display as 0, which I have done correctly. However, if the number is a decimal, say 126.5000, I need it to just display as 126. I was thinking about using the…
AdamK
  • 63
  • 8
1 2 3
…
99 100