Stack Overflow
Stack Overflow

Questions tagged [ssrs-2012]

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2012 in March 2012.

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

3624 questions
7
votes
1 answer

How to repeat text box in every page in ssrs

Is it possible to repeat textbox in every page without giving it on the page header in SSRS. Because before this textbox I have few data to be displayed in the 1st page. So if I put both in page header and making visibility hide for the data that…
Alex Mathew
  • 340
  • 1
  • 3
  • 12
6
votes
1 answer

Problem in exporting SSRS report to CSV format

I have many SSRS reports, and all are having same issue while exporting data into CSV files. (Upgraded from VS-2005 to VS-2013) I have some GROUP data on header while displaying the data based on condition like shown in below image: While exporting…
Irfan
  • 665
  • 6
  • 29
6
votes
2 answers

how to sort table by parameter on SSRS

I have a report on SSRS. I have order and Planned Start column on table. I want to add now the option to order by line or by Planned start time. I mean if I choose line, our report must be sort for line if I choose planned start time, report must be…
Aylin
  • 177
  • 5
  • 17
6
votes
4 answers

Download SSRS Report and save in specific location (C#) (Unauthorized)

Question I am attempting to download an SSRS report via its URL into a data buffer (byte array), so therefore I can then save it in a particular folder, with a name of my choosing. I am open to suggestions of different ways of doing this if…
Crezzer7
  • 2,265
  • 6
  • 32
  • 63
6
votes
1 answer

Expression to remove carriage return in SSRS

I am struggling to get an expression to work in SSRS. I have an address block stored in an Oracle database with carriage return characters. An example is the data stored in the database is: 123 Anywhere…
Jay P
  • 71
  • 1
  • 4
6
votes
1 answer

What is the difference between Today() and Now() in SSRS?

Is there a difference between Today() and Now()? When I searched online for date expressions I noticed that both are used quite frequently to retreive the same information. Which expression should I be using? Today() and Now() in a report:
krynil
  • 233
  • 2
  • 5
  • 18
6
votes
4 answers

How to add row group headers to a "headerless" style report?

For the following Query SELECT * FROM (VALUES ('England','London',9787426), ('England','Manchester',2553379), ('Scotland','Edinburgh',452194), ('Scotland','Glasgow',1168270), …
Martin Smith
  • 438,706
  • 87
  • 741
  • 845
5
votes
2 answers

How to Remove 「Total」 row in SSRS report?

I am new to SSRS. In report, I have One table layout result where its first row (there is a bug in total) and last row is having total of all the fields. (Like shown in below image) Given 「Total」 in first row, which I want to remove from the Report…
Irfan
  • 665
  • 6
  • 29
5
votes
1 answer

Get reports from SSRS with Laravel 5.4

I need help setting up SSRS and Laravel to work with our windows server. I want to get reports from SSRS with Laravel web application by using URL. Example URL:…
Filip Vucemilovic
  • 53
  • 4
5
votes
1 answer

How to change the height of a SSRS report in C#?

Hi I am working on a MVC Project in which I have a reports page where user can view reports with the use of a report viewer. I need to set the page size dynamically for a report, I tried many ways to solve this but I couldn’t. I can change the…
Gokul Maha
  • 298
  • 8
  • 24
5
votes
2 answers

SSRS alternate row colors with column groups

I have reports in SSRS where I'm able to alternate the row colors using this expression: =IIF(ROWNUMBER(NOTHING) MOD 2, "LightSteelBlue","WhiteSmoke") This works great. However, I have a report that has a column grouping, and this seems to mess up…
jackstraw22
  • 517
  • 10
  • 30
5
votes
1 answer

SSRS: Any UpperCase function in SSRS report

I am trying to display selected month, current month and last month names on my report. I am using =Parameters!Month.Label ---> Jun 2016(selected) =Format(Now(), "MMM") & " " & Format(Now(), "yyyy") ---> Dec 2016 (current) =Format(DateAdd("M",…
Ayesha Khan
  • 105
  • 1
  • 2
  • 10
5
votes
1 answer

Visual Studio Report Designer 2015 Not Building to Target Server Version Correctly

I have an SSRS report project I'm working on in Visual Studio 2015, and I am unable to deploy my reports to the correct target server version. The reports need to be able to deploy and run on SQL Server 2012, 2014 and 2016. Visual Studio 2015 allows…
mcol2007
  • 61
  • 8
5
votes
1 answer

SSRS Excel export, Row height not increased in excel

In one of my SSRS Report, The cell is expanding properly in report but when the report is exported to Excel the single cell contain the whole text but I have to manually increase the row height in excel to make the whole text visible. Is there any…
Swapnil
  • 103
  • 8
5
votes
0 answers

MS CRM 2016 Online custom SSRS Report with Sub report

I have a custom SSRS FetchXml based report 'A' for a MS CRM 2016 online instance.The report has RowGroups as well as ColumnGroups as shown below - I am using a tablix here and for the expression in the header I'm formatting the date field (Target…
Aritra B
  • 1,726
  • 6
  • 29
  • 45
1 2
3
…
99 100