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

dataset with 2 cascading parameters

I have a dataset that populates a drop down list, and the query behind the dataset uses two cascading parameters. Basically it looks like this: choose an engine: [drop down list] //defaults to 0 choose a transmission: [drop down list] …
SkyeBoniwell
  • 6,345
  • 12
  • 81
  • 185
0
votes
1 answer

Removing blank spaces

My requirement is remove blank line from the address. I am doing it like this: =Ucase(REPLACE(REPLACE(Fields!Address.Value, CHR(13), ""), CHR(10), "")) It removes the blank line, however the line-breaks is inserted into the middle of the zip…
Gainster
  • 5,481
  • 19
  • 61
  • 90
0
votes
1 answer

Horizontal matrix - How to make fixed-width without paddings and having a break between values

I have a matrix in SSRS 2008 like: Teacher [TeacherName] # of Students [Count(studentId)] What I want is to fix the width of the column. I am changing the padding values but the spaces are not going away. How can I get rid of the empty spaces…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
0
votes
1 answer

SSRS report not creating sometime

I have a SSRS report and it is generating from 4 dataset. This report sending to client by email from console application in every 1 hour. Issue : Report working completely as expected but sometime its throw error as below. Please let me know if…
Ashish
  • 321
  • 1
  • 2
  • 13
0
votes
0 answers

How to get first week of the every month ends with Thursday in SSRS?

i have a difficult requirement that i need to show the first week of the every month should end with Thursday and second week start with Friday and ends with Thursday, for example may first week should be 05/01/2016 - 05/05/2016 and second week…
navyeen
  • 1
  • 1
0
votes
0 answers

SSRS Report show all tables in one Report

Creating the SSRS report for First time and i wanted to show my Report as below image, I have a Task table and related product, equipment table , how do i create report to show all tables in one report like Image. Created a separate dataset for…
prasy
  • 250
  • 1
  • 14
0
votes
2 answers

SSRS Report Timeout From Site - From Report Builder Works Fine

I'm working on SSRS report. It works fine when I run it from Report Builder. Now, when I run the same report from my site, which uses Report viewer to show the report, timeout issue occurs. So I have observed that it times out after 90 seconds. Can…
Pedram
  • 6,256
  • 10
  • 65
  • 87
0
votes
1 answer

SSRS IF Statement with Less-than equal to returns bad counts

SSRS 2008 R2 - Report Builder 3.0 - Querying SQL Server 2008 R2 I have a report that is getting data from a database that has a "Last_Executed" column. My data set is returning a query that has a column dedicated to a DATEDIFF() that returns the…
S.G.
  • 109
  • 14
0
votes
1 answer

SSRS Multiple Field Values Not Passing As Parameters To Drilldown Report

I have not found a suitable answer to my following problem after much searching. I have a summary report which shows the total number of appointments by month grouped by specialty name and diagnosis. Specialty_Name Diagnosis Code Feb Mar …
Gareth
  • 15
  • 4
0
votes
0 answers

SSRS Reports - Moving from one cube to another

I've been tasked with moving some reports/solutions that point to our OLD cube to point to our NEW cube. The structures are the same but the name of dimensions/measures have changed. What would the best tool for the job be or would it need a manual…
pee2pee
  • 3,619
  • 7
  • 52
  • 133
0
votes
2 answers

How to work with folders using Msbuild?

I am using msbuild script to deploy ssrs reports. Previously all reports used to be in one folder and I have written a msbuild script to deploy these reports to report server. Now we are maintaining reports at folder level such as customer service,…
Mahesh kumar Chiliveri
  • 484
  • 2
  • 5
  • 20
0
votes
1 answer

formatting comma delimited string

Is there a function or method of dealing with comma-delimited fields? I have one field in my dataset that looks like this: Steelers, Cowboys, Patriots, Ravens Is there a way to remove the commas, and display like…
SkyeBoniwell
  • 6,345
  • 12
  • 81
  • 185
0
votes
2 answers

How to display all the dates on current month in ssrs expression

Consider May is current month I have list of dates Ex: Date No of Items 05/3/2016 4 05/3/2016 5 05/4/2016 7 05/10/2016 10 05/11/2016 …
Prasanth
  • 3
  • 5
0
votes
1 answer

SSRS - simulate slicers using filtering

I've seen websites explain how to use a tablix to list possible parameters for a report (another tablix) to simulate slicers. This technique relies on passing parameters and the report being refreshed. The issue is, this is slow for where I want to…
user1612851
  • 1,144
  • 4
  • 18
  • 32
0
votes
1 answer

SSRS String null check on MS CRM TwoOptionsetValue="True"

I want to concatenate 2 twooptionset values from MS CRM on true condition seperated by commas on a textbox and leave a blank if 2 twooptionset values are false. I have writen an Expression in…
Prasanth
  • 3
  • 5
1 2 3
…
99
100