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

SSRS report showing different data when it should match

I have a report that is called from a text box action. When I run the report in my Visual Studio looking at production data I get 9 records returned. When I deploy the report and run it I only get 5 records. I have deleted the report on the…
Leslie
  • 3,604
  • 7
  • 38
  • 53
1
vote
1 answer

Why Am I Seeing These Errors in My SSRS Powershell Script in One Environment but Not Another?

I have a Powershell Script I'm working on for post-migration SSRS report administration tasks. In this particular scenario we have a DEV environment (where I've been primarily testing) which hosts a single instance of SSRS, and a Prod environment…
Fernando Vega
  • 525
  • 4
  • 13
1
vote
0 answers

SSRS 2016 issue with custom security extension(authentication )

I have a website (an httphandler) hosted in IIS and I am reading the response (using HttpWebRequest and HttpWebResponse) from SSRS 2106 and writing the output stream on to the Web browser and the custom authentication is working as…
Glads
  • 11
  • 3
1
vote
1 answer

Indenting parameters in SSRS

Does anyone know how to indent a parameter name in SSRS 2016? It looks like it works when I run the report locally, but it doesn't on the server. I indented it with the space bar. Local: Server:
jackstraw22
  • 517
  • 10
  • 30
1
vote
0 answers

SSRS 2016 grouped Report loading very slow in Chrome

I have a SSRS-2016 report that is loading approx. 12000 rows that are grouped in 3 levels (the data is shown on the 3rd level). For some reason the loading of the data needs very long (approx. 3 minutes vs. some seconds in other browsers) when…
Thomas
  • 11
  • 2
1
vote
0 answers

SQL Server Report Builder (2016) - disabling page breaking within row group instance

I am working with SQL Server Report Builder 2016 to create a report and then export its contents to PDF. I have the following problem: Tablix that forms a row group is filled with data from the dataset. There is a group property enabling setting…
ConquerOR2
  • 11
  • 1
1
vote
1 answer

index was outside bounds of array in SSRS when parameter come as blank

I am working on SSRS report where user!userid variable coming with 3 pipe delimited values E.g : ReportUser |500|100 I split the values using below expression =(Split(Parameters!QueryString.Value,…
bmsqldev
  • 2,627
  • 10
  • 31
  • 65
1
vote
2 answers

SSRS Mobile Reports Distinct Count

Anyone know how to get a distinct count in ssrs 2016 mobile reports? The built in aggregation only offers a count, not distinct.
John Millward
  • 75
  • 7
1
vote
1 answer

SSRS 2016 Mobile Reports Error with missing dataset

Does anyone know if it's possible to switch the data set which is used by a Mobile Report? As far as I can see, the only way of doing this would be to add the new dataset and then re-map everything, including filtering to the new one. It seems a…
John Millward
  • 75
  • 7
1
vote
1 answer

SSRS 2016 Reports Virtual folder is not accessible from outside the server (with the bunch of 400 "bad request" errors for some internal requests)

I have the problem with access to the SSRS 2016 "Reports" Virtual folder from outside the server. The server located in the AWS Cloud server, for access to it using RDP we (in the BI department) use server name…
Anton Arkhipkin
  • 341
  • 4
  • 15
1
vote
1 answer

Report Server as Azure Managed SQL Database

I am a beginner in Azure.I have a query, appreciate if someone can help me. My Team is planning to Install SSRS on VM, But report server as Azure Managed SQL database. We already have sql database on premise. So there will be three layers: Database…
Techie
  • 19
  • 3
1
vote
1 answer

SSRS - the restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated

I am new to SSRS, i make a report used three parameter FromDimDateDateKey,ToDimDateDateKey and InstrumentSName, and i got error that query execution failed for my DataSet and query (1,343) the restrictions imposed by the CONSTRAINED flag in the…
Fitre
  • 31
  • 1
  • 2
  • 7
1
vote
0 answers

Configuring OWIN on SSRS Portal

I'm attempting to implement custom security for an SSRS2016 box. I have done this successfully in the past with asp.net forms authentication. In this scenario, I need to read and authenticate from an OWIN cookie. I can do this successfully in a test…
Duncanmhor
  • 33
  • 8
1
vote
0 answers

Target line for each category in Bar Chart -SSRS

I Need to create a bar chart as below in ssrs I struck in creating target lines for each category in the bar chart. I used strip line option for creating the lines. but its creating only one line. Could any one help me how to create target lines…
bmsqldev
  • 2,627
  • 10
  • 31
  • 65
1
vote
0 answers

SSRS 2016 showing some blank data on report viewer

I have a weird problem. I am upgrading my SQL Server Reporting Services from 2008 to 2016. New reports uploaded to 2016 work fine. I'm using SQL Server Data Tool 2015 to migrate my old 2008 reports to 2016. The early 2008 reports are running fine…
Harry
  • 2,636
  • 1
  • 17
  • 29
1 2 3
…
30 31