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

How to improve a company's reporting structure?

I know a company that has spent it's history on depending on excel spreadsheets How do I: -Create a structure to have the front end users complete forms that turn into excel results for me on the back end?
JeanQ
  • 1
  • 1
0
votes
1 answer

SSRS: How to format string to money or percent when the string is itself part of string concatenation

I've 2 fields, IncreasePct and IncreaseDollars with values, such as 5.32 and 9752. I'd like to format the cell so that I get something like this: 5.32%($9,165.00) I've tried something like this: = IIF(Fields!IncreasePct.Value = "", "", …
Richard77
  • 20,343
  • 46
  • 150
  • 252
0
votes
0 answers

SSRS Query Designer error, "The query must have at least one axis"

I have an MDX query written. It is working without any error on SSMS, but when I create a dataset using the same query in SSRS, I get the below error: The query cannot be prepared: The query must have at least one axis. The first axis of the query…
Yousuf Sultan
  • 3,055
  • 8
  • 35
  • 63
0
votes
1 answer

Error while preveiwing the SSRS Report

I have just started to learn SSRS. I'm using Visual Studio 2008 and SQL Server 2008. I have done all the basic things to create a table. But I'm getting this error while previewing. This is my query: SELECT RegisterNumber, StudentName,…
StackUseR
  • 884
  • 1
  • 11
  • 40
0
votes
1 answer

Combining Scatter Chart with Box Plot in SSRS

I am creating a Box Plot(also known as box and whisker plot)through SSRS and I came across a question by Pavan Keerthi. Somehow his example gave me a vision of how I wanted my report to be. What I wanted to do is to create a line similar to the ones…
Michelle Santos
  • 257
  • 4
  • 20
0
votes
1 answer

Need to extract everything before/after substring in Oracle SQL

I have a field, FARMBOL, that has information that I need to split. At some point in the field, it will say "IMPORTER:" followed by some more information. I.E., "20394823409 IMPORTER: John Doe" I need to extract the "20394823409 " as one field, and…
Dom Vito
  • 507
  • 8
  • 38
0
votes
2 answers

Way can I not see The Property Setting

I have a SSRS report with a list I have added a row group to group the list by names and now need place some page breaks in so each name will start on a new page. I have enables the advance mode in the column group and then select the Name in the…
Perry
  • 1,277
  • 2
  • 17
  • 39
0
votes
3 answers

Dynamically add columns in SSRS

I am tasked with creating a report in SSRS that can display data covering anywhere from 1 week up to 52 weeks. What I am trying to avoid is writing a huge query that will pull all 52 weeks worth of data and have it show on the report, unless the…
user3394606
  • 13
  • 1
  • 7
0
votes
1 answer

Formatting Date Time for SSRS (SQL Server 2008 R2)

I want to draw charts from previously saved sensor data from database based on start date and end date parameters provided by user. I show user calendar icon and default start date (=DateAdd("d",-2,Today())) and end date today (=DateAdd("d",…
RotatingWheel
  • 1,023
  • 14
  • 27
0
votes
1 answer

SSRS alignment issue when exporting to PDF and Excel

this is the ssrs report image see the red boxes it is properly aligned SSRS but when i am exporting to PDF or excel alignment issue are coming pdf image SSRS exported to PDF
user4720207
0
votes
1 answer

SSRS. Disable page access / printing if It's blank

In report could be 2 pages: 1st page: HEADER ______ Tablix1 ______ FOOTER 2nd page: HEADER ______ Tablix2 ______ FOOTER In Footer and Header I have added rectangles, all content from header and footer are passed to rectangles. If in Tablix2 there…
Infinity
  • 828
  • 4
  • 15
  • 41
0
votes
1 answer

Column wider on first page of SSRS report than on other pages

I have a column in a tablix on an SSRS report that is printing wider on the first page, but then the size I want it to be on the following pages. Any suggestions? Pictures below showing first page, second page, and design.
Dom Vito
  • 507
  • 8
  • 38
0
votes
1 answer

How does one create a bar heat map in SSRS?

How does one create a bar heat map in SSRS? The only options I see is a map of USA. I'm interested in creating a bar heat map. I'm using SSRS 2008.
user6038584
0
votes
1 answer

Using a single value parameter to search a multi value comma separated string in SQL

In my SQL query I have a single value parameter @MandatoryGroup which is returning an integer value for one of the ID numbers for a list like this 202 Group A 203 Group B 204 Group C 205 Group D So the value of @MandatoryGroup could be 202 In…
EileenS
  • 43
  • 8
0
votes
0 answers

Formatting label in SSRS for MB, GB

I am attempting to create an SSRS report from a table that collects daily database stats (FileSize, Free Space). I am creating a graph within SSRS, which allows for multiple selections of databases across multiple server. I would like to format the…
devista
  • 55
  • 3
  • 10
1 2 3
…
99 100