Stack Overflow
Stack Overflow

Questions tagged [ssrs-2014]

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

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

192 questions
1
vote
1 answer

Search all Expression text in SSRS

I am working on a report which has many Expressions defined and would like to check all of these Expressions for the occurrence of some particular string - is this possible? For example, I'd like to be able to identify all Expressions which contain…
3N1GM4
  • 3,372
  • 3
  • 19
  • 40
1
vote
1 answer

I am getting the following error - "column "A" cannot convert between unicode and non-unicode string data types"

I am following the SSIS overview video- https://www.youtube.com/watch?v=3cPq9FXk-RA I have a excel file that i want to import the contents from a SQL database. I created a oledb source file and excel destination. I am getting the following error…
VVN
  • 501
  • 1
  • 9
  • 21
1
vote
0 answers

Date Formatting like Date Picker in SSRS

I'm using reporting service. How can I set date to be formatted like, we manually select date using date picker. I want a textbox should be formatted like below image on tab click. Please help me. Thanks in advance!
Pedram
  • 6,256
  • 10
  • 65
  • 87
1
vote
1 answer

SSRS border lines with different colors not overlapping properly

I have a user-designed report that I am trying to replicate in SSRS, the report has a table with a default border color (Gray). I need to draw a black line through one column, this adds the effect of separating the columns that lead up to the final…
dimitarie
  • 307
  • 2
  • 6
  • 19
1
vote
3 answers

How do I set a SSRS report's Hidden property to "True" in PowerShell using ReportService2010?

I am setting the Hidden property to "True" at the end of this code, however, it continues to be displayed in the Report Manager interface. Does anyone know how to set this property using PowerShell with ReportService2010? $reportServerUri =…
Gimli
  • 41
  • 7
1
vote
1 answer

Change SSRS Report page orientation Dynamically

I'm working on SSRS Reports. Currently I am facing one issue. I have two tablix in a single Report. Now, Tablix1 or Tablix2 will be visible in either condition. For example: I am passing One Flag as True then Tablix1 should be visible and for this…
Pedram
  • 6,256
  • 10
  • 65
  • 87
1
vote
1 answer

Configure Reporting Service to open Report Manager

I recenlty install an instance of SSRS 2014. I want to alloiw my partners open Report Manager from their browser. When I go to this such address: http:///Reports I can see Report Manager but they can't see Report Manager. IIS has been…
Arian
  • 12,793
  • 66
  • 176
  • 300
1
vote
2 answers

Deleting Report Server (2014 Native Mode) Encrypted Keys & Data [PowerShell]

After I clone an instance from an image, a few manual steps need to be carried out to get the report server working correctly. Among them is the deletion of all encrypted data, including symmetric key instances on the report server database. This…
ShaneC
  • 2,237
  • 2
  • 32
  • 53
1
vote
3 answers

How do I use an IN statement in SSRS Formula

Is there an easy way to do an IN statement or something similar in a SSRS formula for an iff statement comparison without having to repeat a switch 16 times? This is what I am looking to accomplish without having to write a statement or a separate…
Mattg07
  • 13
  • 3
1
vote
2 answers

How to retrieve a parameter value based on a result set from stored procedure in SSRS 2014?

I would like to know how do I select a parameter based on the result set from a stored procedure. My code looks something like this: CREATE PROCEDURE usp_UserInformation (@ReportRunDate DATE = NULL) AS WITH CTE AS ( SELECT -- some fields FROM…
Julaayi
  • 403
  • 2
  • 8
  • 23
1
vote
1 answer

SSRS in Scale-Out deployment

Has anyone on this forum, deployed SSRS in Scale-Out deployment? Having 2 SSRS instances on different machines connect to one database? I am trying to deploy 2 SSRS server loadbalanced to connect to one database which is hosted on SQL-Always On…
Ssutar
  • 11
  • 2
1
vote
1 answer

SSRS Scheduled Subscription hyperlinks not working

I am Currently using Reporting Services 2014. I am using the following code to be able to use a javascript pop-up window on the sharepoint site itself. The code also addresses the export to Excel link through an iif statement that evaluates…
Istaley
  • 359
  • 1
  • 6
  • 24
1
vote
1 answer

Spacing Issue while using SubReport on Main Report

Below image shows spacing issue while using sub report on main report. Red rectangle - Tablix of Main Report. Green rectangle - First Cell of Tablix on Main Report. Blue rectangle - Second Cell of Tablix on Main Report. Black rectangle - Sub Report…
Pedram
  • 6,256
  • 10
  • 65
  • 87
1
vote
1 answer

Conditional Formatting not working on specified cells in SSRS

I have got a report that consists of several matrices aligned right next to each other. Not all the cells of the report contain data and appear as blanck cells so i created the following statement in order to have "N/A" on all cells that have no…
Raul Gonzales
  • 866
  • 1
  • 15
  • 28
1
vote
1 answer

SSRS Excel export does not open a drill-through link in pop-up window

I have several SSRS reports that contain drill-through links that open up a pop-up browser window on the site, which works fine. I am using java script in the URL for the textbox action. The problem is that when I export the report to excel it…
Istaley
  • 359
  • 1
  • 6
  • 24
1 2 3
…
12 13