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 - Adding several tables in one report with different parameters

I am developing a SSRS report for the first time from scratch. I need to develop 3 reports (Ex: R1,R2,R3) in one main report. But the 3 reports have different parameters. Is it possible to do so in one report such that, if R1 requires parameter P1…
Shivang
  • 231
  • 1
  • 5
  • 17
0
votes
0 answers

SSRS report parameter grayed out when running from snapshot

I am running SSRS 2008 R2. I have a report with a parameter that allows the user to type in a text value. I have the report setup to run on a snapshot, so it required me to enter a default parameter for snapshot purposes. When I run the report,…
Aaron
  • 75
  • 7
0
votes
0 answers

SSRS Subscription strategies

I'm hoping someone with a little more experience than me will know a better way to schedule SSRS reports. Here is my situation: I have a report on my SSRS report server which takes about a minute to run. I have about a dozen subscriptions setup on…
Slider345
  • 4,558
  • 7
  • 39
  • 47
0
votes
0 answers

Allow multiple values with SSRS

I want to use IN @Parameter while using dateadd function in below code declare @interval int --set @interval SELECT ROW_NUMBER() OVER (ORDER BY datetime) AS Row, RIGHT(LEFT(E.Name, 11), 8) AS Device, P.[DateTime], day(p.DateTime) AS…
Piyush Jain
  • 5
  • 6
0
votes
1 answer

MDX of records returned

I'm building SSRS report. In Query Designer I have a report query. I need to count total records returned by this query. How I can achieve this?
Vnuuk
  • 6,177
  • 12
  • 40
  • 53
0
votes
0 answers

How to Check If a Parameter Contains a Certain Value in SSRS?

SQL Server Reporting Services (SSRS) - How to Check If a Parameter Contains a Certain Value in SSRS ? Example: I have a paramter named SubjectID which has few subjectID's say 603,604,605,607,608 . I want to return "Y" if the subject ID is 603,604…
VVN
  • 501
  • 1
  • 9
  • 21
0
votes
1 answer

How to deploy SSRS report with multiple data sources?

I have two different databases on two different servers and I need data from both the databases for two different datasets associated with two tables in report. The problem is I am not allowed to deploy the report from BIDS and report will be…
Naim Halai
  • 355
  • 1
  • 8
  • 27
0
votes
1 answer

SSRS Error, Invalid Sheet name

I have a report that creates multiple tabs will export to Excel grouping on the account number, all of a sudden on export it tells I Have an Invalid Sheet name and creates something weird on sheet 212. Please help. accounting is on me. Not SSRS…
user5495350
  • 3
  • 3
0
votes
2 answers

SSRS Report query syntax

I'm wondering what is AMP (&) sign in report parameters means? Is it required for the query? F.e. [Life].[Year].&[2015]
Vnuuk
  • 6,177
  • 12
  • 40
  • 53
0
votes
1 answer

sql ssrs returning multiple selected @parameter

I have a multi value parameter which is a combined string of two fields with a space separating them i.e productID productName. I want to pass just the parameter with just the id portion only. I tried the expression: =join (left…
Trang Le
  • 87
  • 1
  • 9
0
votes
1 answer

Trend Chart SSRS 2008 R2

I Have 3 columns OUTPUT,INPUT And WIP. Is there any way or chart expressions that will help me to achieve this kind of image above? I am using Report Builder. TIA if anyone can help me.
Jacky Montevirgen
  • 307
  • 2
  • 14
0
votes
3 answers

Changing font size of a label

I have a label expression:`="Call Performance" & vbcrlf & Join(Parameters!client.Value,", "). I added a carriage return after the constant text "Call Performance" so that I will automatically go at the bottom. How do I change the font size of the…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
1 answer

SSRS Month over Month Date Expression beginning with Previous business day

The business requirement is to have a report with a month over month date starting with the previous business day. How do I achieve? For month over month - my expression is: =dateadd("m",-3,Today) For previous business day - my expression…
BIReportGuy
  • 799
  • 3
  • 13
  • 36
0
votes
1 answer

SSRS: Hour() for 24:00

I was using Hour(Fields!tempo.Value) for get the hour from a field (tempo). The problem came when I got for first time "24:00" and the report shows the '#error'. The description in 'Hour' function said: Returns an Integer value from 0 through 23…
HEDMON
  • 727
  • 10
  • 24
0
votes
2 answers

SSRS - How to have two fields with same name in a dataset?

In my xml dataset, I've two fields with the same name coming from two different tables. How can I use both fields in the field list?
SJaka
  • 712
  • 13
  • 40
1 2 3
…
99 100