Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008]

Microsoft SQL Server 2008 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed. Use with the [reporting-services] and/or [ssrs] tags

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2008. More info in the tag.

This tag is for questions specific to SSRS 2008.

6153 questions
1
vote
1 answer

SSRS Shared Datasets

In SSRS(2008 specifically), do shared datasets hold the same data across all reports in the same project(effectively working as global variables), or just hold a dataset schema that can be referenced by all the reports?
CodeMinion
  • 653
  • 2
  • 10
  • 24
1
vote
2 answers

SSRS Cache Reports

Attempting to cache my SSRS reports as referenced in http://blogs.technet.com/b/rob/archive/2010/02/11/caching-ssrs-reports-for-performance.aspx ...I am to understand I need to set the processing…
Charles
  • 211
  • 1
  • 4
  • 11
1
vote
0 answers

SSRS - Details with Quarterly Avgs, as well as YTD Avgs across multiple years

So I created a little tablix with a row group for the YEAR_QTR (for example 2021_Q1 we are in today). It shows daily details, then some quarterly averages below. A simple image below of what I'm talking about. I have this all working but what I…
Jay
  • 455
  • 3
  • 17
  • 34
1
vote
2 answers

sql query problem when reporting

I have this sql query that it's all working fine but i want to parse the 'where part' using a parameter (@ged) when i try this in sql it work fine..but i can't get it working in crystal report or sql reporting service in this query ..@J_Sec is a…
Ramah
  • 455
  • 1
  • 8
  • 18
1
vote
1 answer

MDX Query: How to use where condition in query using filter()

Need Suggestions for below mdx query. It's giving syntax error. trying to calculate total sales where pop2019 larger than 5000 & GDPgrowth more than 1 Schema link SELECT {[Measures].[Sales]} ON 0, {[Dim Company Info].[LOC].ALLMEMBERS} ON 1 FROM…
pythonlearner
  • 85
  • 2
  • 10
1
vote
2 answers

using p4.net in Reporting Services 2008 R2

I am using MS SQL Server Reporting Services 2008 R2 to produce reports. I have Perforce database where I query Changesets data and put into report. I needed to get code statistics from Perforce database but Perforce database does not have this…
AnarchistGeek
  • 3,049
  • 6
  • 32
  • 47
1
vote
1 answer

SSRS display n/a when n/a

I have dataset in Power BI which is displaying n/a in some fields. I have connected Power BI dataset with Power BI report builder and I need to handle n/a in report builder. So if the value is n/a I need to display n/a else I need to round off the…
xorpower
  • 17,975
  • 51
  • 129
  • 180
1
vote
1 answer

Send report only when the attachment has data in SSRS

Is there a way to configure SSRS (data-driven subscription?) to send reports in email only when the report contains data?
Lrn
  • 327
  • 2
  • 9
  • 18
1
vote
1 answer

SSRS2008 - SELECT in a CASE...WHEN...THEN

I am using a hidden internal Parameter (@DoorHelper) to check if another parameter I am using(@Door) contains a special value I use to represent 'global'('9999') and return all Doors in that case. SELECT CASE WHEN ('9999'+'-'+ RIGHT(Unknown1,1) in…
CodeMinion
  • 653
  • 2
  • 10
  • 24
1
vote
2 answers

SQL 2008 R2 - Reporting Services, using Data Model with Report Builder 3 over internet causes crash, any ideas?

Background: I have a Windows 2008 R2 box set up with SQL 2008 R2 both the Data Engine and Reporting Services. I have configured Reporting Services to use custom authentication (FormsAuthentication) that I wrote. The custom authentication gets…
Peter
  • 797
  • 11
  • 35
1
vote
1 answer

Calibri font printed as Arial

I have a Report that uses the Calibri font. It is rendered fine in IE, however when I print the report (clicking on the Printer icon) the text comes out in Arial. What can I do to get the report to print using Calibri?
openshac
  • 4,966
  • 5
  • 46
  • 77
1
vote
1 answer

Remove Weekday From ToLongDate()

I would like to display a date like... =Now.ToLongDateString() BUT without the weekday. So the expression would produce June 21 2011. Not Tuesday, June 21 2011. Is this possible? I don't want the format MM/DD/YY. I would rather have June 21 2011.
2boolORNOT2bool
  • 557
  • 3
  • 9
  • 23
1
vote
4 answers

Allow multiple values from SSRS in oracle

I have a query that gets contract_types 1 to 10. This query is being used in an SSRS report to filter out a larger dataset. I am using -1 for nulls and -2 for all. I would like to know how we would allow multiple values - does oracle concatenate the…
Greg
  • 476
  • 9
  • 23
1
vote
1 answer

Role of rdl file in SSRS Mobile reports

Can we use RDL files in SSRS to design mobile reports? My understanding is that RDL files are used for creating printable reports and not for mobile reports. Mobile reports can be only designed using Mobile Report Publisher tool. Could you please…
Venkatesh Muniyandi
  • 5,132
  • 2
  • 37
  • 40
1
vote
1 answer

Multivalue parameter in ssrs and mysql

I am using SSRS2008R2 to report data stored in MySQL database. Due to MYSQL extension does not support multivalued parameters to be passed, it is suggested on the forums to use the syntax below. ="Select * from projects where projectID in (" +…
AnarchistGeek
  • 3,049
  • 6
  • 32
  • 47
1 2 3
…
99 100