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

RDLC - How to search & count specific value in row and show result in Last Column?

I'm working report that display individual Leave of each day of the month in which last column shows total number of AL (Absent-leave) in a month. The only problem in report is the Wrong count of Total Number of AL . Currently I'm getting output…
محمد قاسم
  • 169
  • 14
0
votes
0 answers

Bulk Printing in SSRS

I have a report using cascading parameters and sub-reports in SSRS. I am able to print the report correctly for single student but when I select multiple ids I see that the data gets mixed up in the sub-reports. I made sure I am using row grouping…
Aruna Raghunam
  • 903
  • 7
  • 22
  • 43
0
votes
1 answer

SSRS Next 6 Months based on Year and Month Field Chart Filter

I have number of charts that I am creating using a data set. I have one chart which is only supposed to be subset of the data. Essentially It should show data for the next 6 months based on the current month. If i ran it today, it should show the…
a415
  • 359
  • 1
  • 6
  • 23
0
votes
0 answers

SSRS Data source Credentials and creating a new dataset with existing datascource

I am trying to customize account overview SSRS report, I need some extra fields which don't exists in default data set provided, when I tried creating a new dataset writing a simple query it alerted me to test the datasource connection first. When…
Shruthi Rajoli
  • 65
  • 1
  • 8
0
votes
1 answer

Collapsing SSRS matrix rows and columns

How would I combine the matrix below so that the race lines appear once with column totals to the right? New image showing grouping:
user1795131
  • 47
  • 4
0
votes
1 answer

Adjusting subreport headers in SSRS

I'm trying to create a sort of master subreport that I can use as a header for other reports. The subreport has 2 image logos in the left and right corner. I insterted the images in the body of the subreport. My struggle here is to make it as…
jeremyfisher
  • 3
  • 3
0
votes
1 answer

How to SET ReportParameter Value of SSRS Report in WPF

I am trying to Call SSRS Report in WPF with Parameter Passing From WPF UI without using Microsoft Report Viewer Component. I Used the following Code for Passing Parameter to SSRS Report... Microsoft.Reporting.WebForms.ReportParameter[]…
Osman
  • 1,270
  • 2
  • 16
  • 40
0
votes
1 answer

SSRS - Why is my report only returning dates from current year?

I have the following query that works correctly in SSMS and it works in SSRS report builder 3.0's Query Designer. It takes three parameters one of which (@year) is how many years back from today do you want results from. I have specified for @year…
Kram_Koorbse
  • 442
  • 5
  • 19
0
votes
0 answers

Format text box in SSRS for multiple text

i am working in SSRS, I am facing one difficulties since two days. How can i format multiple text in one text-box? i.e Some text i have to show in Bold format and some in normal. I am getting the Exact output as i have formated in the Textbox when i…
Dheeraj Kumar
  • 13
  • 3
0
votes
2 answers

ROW Headers not appearing SSRS

I have a report which is a tablix without any details group or any group for that matter. I have a row headers which are based on an expression that I would like to repeat on each of the page. But within the report, I do not see these headers being…
a415
  • 359
  • 1
  • 6
  • 23
0
votes
0 answers

SSRS (Reporting Services) - Variable values cannotg be used in group expressions

I have a tablix with a parent group. In the group properties I am trying to use a report variable within an expression in general tab but I get below error: Variable values cannotg be used in group expressions How can I get rid of this?
Willy
  • 9,848
  • 22
  • 141
  • 284
0
votes
0 answers

How to rotate Pyramid chart in SSRS?

I was trying to rotate or flip Pyramid chart to show upside down(reverse pyramid) in SSRS 2012. Any idea how to do it. I Just want to flip below graph to show as reverse pyramid in SSRS.
vishaldk
  • 119
  • 2
  • 7
0
votes
1 answer

SSRS - How to filtered dimension subcategories into a single group

I'm not sure if this is possible but I'd like to be able to return a set of figures bases on a set of subcategory dimensions. To explain visually I'm using this MDX for my data: SELECT NON EMPTY {[Measures].[Freight]} ON COLUMNS ,NON EMPTY…
John
  • 275
  • 1
  • 4
  • 14
0
votes
1 answer

SSRS Not repeat on new page

I have a report like this: This is first page of a Resident. So I just want to show #2 Rectangle in first page of each Resident and hide #2 in rest of pages like this: I tried to use code: Public Function IsFirstPage(resident as string,…
Nguyễn Xuân Hoàng
  • 582
  • 7
  • 23
0
votes
0 answers

Drill down in ssrs based on column values

I need to make a drill down report based on column values. I have already created report but I need to implement drill down in my report. My column values are like below based on which I need to drill down my report. Top Line Income, Products (GL),…
ramu
  • 121
  • 1
  • 13
1 2 3
…
99 100