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
2 answers

SSRS search multiple parameters allowing some blank

I am looking to be able to search locations of orders using any of 4 parameters. What I have works when looking for a set pair of complete parameters but when any of them are left blank no results are returned. (all 4 parameters are declared as…
Dallasdhu
  • 1
  • 1
0
votes
1 answer

SSRS: Split a String into Multiple Lines in a Text-Box

I'm having a problem with my SSRS report. The data that i'm showing in some of the fields is larger than the max-width of the textbox. How i can implements something like word-wrap in CSS, so the text can be split in multiple lines?
Stefan Taseski
  • 242
  • 2
  • 24
0
votes
1 answer

SSRS data drive subscription with multiple formats?

Is it possible to send multiple types of auto emails such as MHTML and PDF? I only see 1 option to select from so i was just wondering. Since our SSRS server is internally hosted the person being emailed can not go to the report directly to…
T Dang
  • 157
  • 3
  • 17
0
votes
1 answer

How to ENABLE the Advance option in Report Server Web Service URLs (Reporting Service Configuration Manager)

To start with, I am completely new to SSRS reporting. Please excuse me if I miss any basic details here. I am trying to create a reporting service.I want to work on the Advance option in Web Service Url, but it's disabled. How can I enable the…
Mahatma Aladdin
  • 2,027
  • 3
  • 17
  • 31
0
votes
1 answer

Page break between multiple instances of a group in SSRS

I need to be able to have a page break after a group has repeated three times on a page, my resulting report is a tablix of customers and details that repeat for each differnt cutomerID but I want to limit the repeating tablix to three instances per…
SSMSJ
  • 219
  • 3
  • 14
0
votes
1 answer

What is the logic of server side pagination in SSRS reports

As I am working on SSRS reports (.rdl), I need to do pagination within reports. Usually for pagination as a asp.net developer, I add few statements in my procedure with page num and rows logic. But as my SSRS report is also using a store procedure,…
Sandy
  • 275
  • 3
  • 8
  • 25
0
votes
1 answer

Matrix year to year percentage calculation

Looking for a way to calculates the yearly growth in ssrs matrix. for eg. for May 2017 it ll do- (May-2017-May2016)/May2016. Attached the screenshot. Unit is a column. I am using running values function inside the data . Row group- Type Column…
Parkin
  • 13
  • 6
0
votes
1 answer

Using report viewer in asp.net to consume rdl file from server

I have deployed my ssrs project and reports on server. And now I have to consume those in my asp.net application. I have written basic code as I found on few links. But I think i am not passing correct server uri and rdl file path. Could you please…
Sandy
  • 275
  • 3
  • 8
  • 25
0
votes
1 answer

ssrs 2008 r2 sort on a group displayed in a tablix

In an existing SSRS 2008 r2 report, I am trying to determine how to change the sort order of a grouping called termName in a tablix. The school terms are sorted in descending order. The termName column is defined as varchar(10), not null . The…
user1816979
  • 511
  • 4
  • 13
  • 25
0
votes
0 answers

SSRS text box value

I am trying to enter a value from textbox in SSRS, but its not giving the value from that textbox. Instead it is showing value from another textbox. Example: The below is my table structure with groups. When I try to use Week1 value, it displays…
Shivang
  • 231
  • 1
  • 5
  • 17
0
votes
1 answer

Send Email with Attachement using SSRS Action Property

For the customized reason, I developed a report that is reporting on the SharePoint document lists and so far it's all good. By using Action property, I linked the original SharePoint path to SSRS and user can open the document using the link from…
ViKiNG
  • 1,294
  • 2
  • 19
  • 26
0
votes
2 answers

Creating a Report in SSRS

I am attempting to create a report to change Values to Red, Yellow and Green based upon the last inspection date. Inspections are every three years if DUE is in the last inspection then I want the cell to turn red, if the last inspection has been…
RCapps
  • 1
  • 2
0
votes
1 answer

Embedding SSRS in my webpage

I am trying to use existing SSRS report in my web page (ASP.net) I am using ReportViewer in my page and setup Server Report and Report Path yet the report does not show and getting this error The path of the item '/TEST/Financial/WIP+Account' is not…
asmgx
  • 7,328
  • 15
  • 82
  • 143
0
votes
1 answer

SSRS data driven subscription email to : parameter dependent on report parameter?

Hi I am using visual studio 2015 to make an SSRS 2014 report. The place I am stuck at is my email recipient is dependent on what company is selected from the SSRS report. Not that it should matter but my report parameters are Company (really…
T Dang
  • 157
  • 3
  • 17
0
votes
0 answers

SSRS 2008 R2 Query Timeout Works Intermittently

I have a SSRS report with the query timeout set to 30 seconds: 30 We have it set up to run from an ASPX page. When I run it with parameters that cause the query to take more than 30 seconds it times out after running for…
TechSavvySam
  • 1,382
  • 16
  • 28
1 2 3
…
99 100