Stack Overflow
Stack Overflow

Questions tagged [ssrs-2016]

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

463 questions
1
vote
1 answer

make SQL Report hidden parameter visible when creating subscription

is there a way to make a hidden parameter visible in SSRS Subscription creation ? Something like this The Parameter IsSchedule will be hidden/internal(not visible to normal users) but should be visible when i create a schedule for the report. Note:…
Bernard Walters
  • 391
  • 1
  • 4
  • 16
1
vote
4 answers

SSRS 2016 - Change a portion of SQL based upon parameter choice

I have 7 reports that all use the same query except one line in the where clause. How can I combine these into 1 report and change the line based on the report type selected. Code example Select a.remark from remarks a where a.code in…
SnowXTC
  • 19
  • 5
1
vote
1 answer

How do I configure SSRS server to only send a report server URL?

I need to disable the option to attach a report in an SSRS subscription in SQL 2016. The only option that should be available is to send the report URL. SSRS Subscription Setup I am curious how to perform the recommended method from MSDN to…
godfathr
  • 416
  • 5
  • 12
1
vote
2 answers

Avoid Windows Login Prompt While Accessing SQL Report Server 2016

Could u please help me on how to stop prompting the credential while opening report manager/ report server in SSRS 2016. I searched lot in google but no success. Kindly help me. Thilan
Sudu
  • 51
  • 1
  • 2
  • 9
1
vote
1 answer

SSRS-2016 get HTTP Error 503 after server restart

I install and config SSRS-2016 on windows server-2012 and IIS-7 everything is good until i restart server or power failure then i get HTTP Error 503. The service is unavailable.i find a alternative solution to solve this.when i change web portal URL…
F.Kahalaj
  • 86
  • 8
1
vote
1 answer

Report body not showing in 2016 version of reports

I am running an ASP.NET application which displays SSRS reports. This works fine in prod., using SQL Server 2012, but on my dev machine I'm running SQL Server 2016 with SSRS 2016. On here, the report header shows (parameter selection), but no report…
radders
  • 923
  • 8
  • 29
1
vote
1 answer

SSRS 2016 Data source won't display Oracle connection type

I have a couple of new SSRS 2016 installations. Both of them fail to show the Oracle connection type. They will show Oracle Essbase, but that isn't what I'm looking for. The full Oracle client is installed in both cases and I can successfully make…
Dave Bennett
  • 788
  • 1
  • 7
  • 13
1
vote
1 answer

How do I customize the name of a report in SSRS 2016 to be output?

I want to export a paginated report from SSRS 2016 with a custom name from code. I can do it if I use the old 2005 control, but when I use the new URL access it either prompts me (if I'm in Edge) but defaults to the name of the report or in Chrome…
Elsimer
  • 1,878
  • 3
  • 18
  • 33
1
vote
2 answers

SSRS parameter in WHERE

I thought this would be really simple but I can't get a way that works. Basically I would like to make the report search by the entered parameters, IE in the WHERE clause. For example, parameters in the below would be @ColumnName and…
coblenski
  • 1,119
  • 2
  • 11
  • 19
1
vote
2 answers

Content section not showing in view menu SSRS

I just installed SSRS 2016 (SQLServer2016-x64-ENU.iso ) and noticed that there was no section "Content" in view menu. I have full rights. SSRS 2016 menu The proper menu consists "Content" section How can I fix it?
ustkaman
  • 11
  • 3
1
vote
1 answer

Create Report With One Group In SSRS 2016

Please Consider this report that built using Table: I want to create such this report but my report is like this: Where is the problem?
Arian
  • 12,793
  • 66
  • 176
  • 300
1
vote
1 answer

SSRS 2016 web portal authentication

I seem to be getting a problem with the SSRS web portal. If I go to the link, it gives me an error stopping me from seeing the reports, saying Could not load folder contents You are not allowed to view this folder. Contact your administrator to …
ostrich160
  • 21
  • 1
  • 5
1
vote
0 answers

How to set up Sql Server reporting services 2016 with Auth0

I am trying to set up my SQL Server Reporting Server 2016 to accept Auth0 authentication. I can not find any links with this information. Could anyone point me in the right direction for finding information on how this is done.
Darren
  • 1,352
  • 5
  • 19
  • 49
1
vote
1 answer

Is it possible to generate/import an SSRS instance into a Visual Studio Project?

I have objects created in the web portal or using Report Builder. I would like everything to be source controlled in a project so I created a new project and I don't see an import wizard. I was hoping it would function the same way Analysis Services…
IronicMuffin
  • 4,182
  • 12
  • 47
  • 90
0
votes
2 answers

SSRS Using some Field Values from Dataset1 as Parameters in DataSet2

I have a dataset referring to a stored procedure which delivers me some data. One column contains a specific Code (see picture), which I want to use in the second table/dataset. For each of the Codes (amount is variable) I want to add a new table…
ScarfaceNo1
  • 11
  • 1
1 2 3
…
30 31