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

Running SSRS Report by passing parameters in the URL doesn't show any result of the report

I'm trying to run an SSRS report on the server which takes a parameter as input. When I enter input in the textbox it displays the result. Also works fine in the visual studio BIDS. But, I want to pass parameter in the URL and see the report result…
LearnCodeFun
  • 61
  • 1
  • 2
  • 9
0
votes
1 answer

Checking a multi-value parameter against multiple columns in SSRS

I've been trying to get this function to work in SQL Server Reporting Studio 2014 for a while now, and I haven't been able to find a workaround here through lots of searching. I'm fairly new to SSRS, but I've seen that you cannot create filters with…
Dave Kraemer
  • 3
  • 4
0
votes
1 answer

Subscribing to a report with different default parameters

I have created a report in VS2013. I have also created a Stored procedure that returns a dataset that works out Last_week_start, Last_week_finish, Last_month_start, Last_month_finish etc. I have done this so users can subscribe to these reports and…
Easty
  • 387
  • 1
  • 6
  • 17
0
votes
1 answer

SSRS CLR Function giving #error when NodaTime Dll objects is Used in CLR Function

I am facing issue when trying to access the CLR Function from the SSRS Report when i am using NodaTime Objects in the function. When i am calling the CLR Function from the web page its working fine but when i try to access the function from SSRS…
Liquid
  • 648
  • 1
  • 7
  • 20
0
votes
0 answers

How to Disable a single reports export feature in ssrs without impacting the export features of other reports?

I have a report in SSRS 2014 where i need to disable the export feature. The export feature should get disabled only on a single report without impacting the export feature of other reports. This needs to be done in the Reports only as i am using…
sujit kumar sahu
  • 61
  • 3
0
votes
2 answers

Alter appearance of data after report is generated

I have a detail report with interactive sorting on the headers. After the report is refreshed, the user would like to highlight some rows of data that appear throughout the report in order to see if patterns are detectable. Say, a vendor name that…
user2812742
  • 43
  • 1
  • 3
0
votes
1 answer

Could not execute procedure on remote server via Linked server

I triggered a subscription using following query on Server-A using following query and it executes correctly - On Server-A: EXEC ReportServer.dbo.AddEvent @EventType='TimedSubscription', @EventData='452e4a40-7442-4377-abe3-1b96fc953956' However,…
Rameshwar Pawale
  • 632
  • 3
  • 17
  • 35
0
votes
2 answers

SSRS Get previous value in row group

I have A tablex which has row grouping , trying to do some calculation base on the previous row in the group. so I tested Last(Fields!InQty.Value) and put it in the total cell. and it get the value of the same row : When I tried…
Amr Ibrahim
  • 167
  • 3
  • 14
0
votes
1 answer

SQL Parameter that checks filters records returned within the entire last 3, 6, 9 months or year

I am trying to write a stored procedure that only returns data for the past 3, 6, 9 months or year. It needs to be full months only (if pulling 8/15; most recent would be July) So far I have been able to find out how to find out the 1st and last…
Istaley
  • 359
  • 1
  • 6
  • 24
0
votes
2 answers

SSRS Create Tabs Dynamically

I've created many SSRS reports with multiple tabs, and am able to name the tabs at will using the page break/page name section of the properties window for a given tablix. What I'm trying to solve for now, and can't find any good answers on the web…
TheGuyThatDoesn'tKnowMuch
  • 1,240
  • 1
  • 17
  • 28
0
votes
1 answer

Passing commands with URL leaves parameters vulnerable

We are currently using a generic report which will be used differently by multiple usergroups. We have made this possible by creating linked reports with different settings of hidden parameters (such as 'show column x', 'enable feature y'). These…
Menno
  • 12,175
  • 14
  • 56
  • 88
0
votes
1 answer

Can we restrict some functionality in SQL Report Builder?

We are providing user can change the existing reports columns or look and feel by SQL Report Builder in Web application. I want to restrict some functionality of Report Builder like below: User cannot able to use "Save As" functionality. (because…
Snehal
  • 1,070
  • 12
  • 20
0
votes
0 answers

SSRS Report Manager language suddenly switching

We've been experiencing lately some issues with SSRS report manager language, which switches suddenly from French to English (happened 2 times), and vice versa. Note that the clients browsers are in French and report manager is still showing in…
Zakaria Belghiti
  • 521
  • 3
  • 8
  • 19
0
votes
1 answer

SSRS Returning wrong values for calculated field

I am simply trying to divide a cost by a count from a pregrouped view. It worked fine for me with a different view, but this one is displaying numbers that are all over the place. Any insight would be much appreciated. SSRS Preview Thank you SSRS…
Chris DellaDonna
  • 1
  • 3
0
votes
1 answer

Hide empty SubReport space in SSRS

How can I suppress empty space of subreport in SSRS. I am passing Main tablix data to subreport as a parameter. Current Result: Expected Result: So it there is empty subreport, then it should not show and the subreport 3 should merge with…
Pedram
  • 6,256
  • 10
  • 65
  • 87
1 2 3
…
12 13