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

SQL Server Reporting Services Issue

We are using SQL Server 2014 Reporting Services to produce reports. Recently, we have had to switch our links to https. Since that time, we are unable to access the reports from outside the local server. When accessed, we only get in return the…
Josh
  • 31
  • 5
2
votes
1 answer

Chart group lines in multiple groups in SSRS

In SSDT 2014 there is some lines in ultiple groups that show group bound: but in SSDT 2016 there is not such this lines. How I can add them? Thanks
Arian
  • 12,793
  • 66
  • 176
  • 300
2
votes
1 answer

access denied adding a data source from ssrs

I have a problem with SSRS 2014. I am trying to browse to a data source on my server see pic0. I then get the error in pic1. I cannot browse to it in IE either pic2. Pic3 is from the site settings page of the SSRS and the 3rd user is me with the…
Easty
  • 387
  • 1
  • 6
  • 17
2
votes
1 answer

Is there a maximum limit for SSRS subscription parameters?

We have a SSRS report which has about 12 parameters. It works fine in native webpage mode. We can input/select values for the parameters, and run report successfully. However, when user setup report subscription, there are only four parameters were…
user2420632
  • 21
  • 3
2
votes
1 answer

SSRS DatePicker Is invisible in Google Chrome - Works fine in Firefox and IE

I'm working on SSRS Report, It shows datepicker in Firefox browser as well as in IE Browser but not showing in Google Chrome. Can anyone please help me. ReportView.aspx
…
Pedram
  • 6,256
  • 10
  • 65
  • 87
2
votes
1 answer

The value provided for the report parameter '' is not valid for its type. (rsReportParameterTypeMismatch)

I am working on SSRS Report. Continuously getting bellow error does anyone have idea to sovle? The value provided for the report parameter '' is not valid for its type. (rsReportParameterTypeMismatch) Using query something like below - My query…
Pedram
  • 6,256
  • 10
  • 65
  • 87
2
votes
3 answers

Set SSRS Report Parameter value with passed Querystring value in SSRS

I have one report, in which I have 13 parameters that fetch the data from Database. I want to set only one Parameter value from Query-string URL. For example in my case I want to set UserID value to passed Query-string value in SSRS report. Is it…
Pedram
  • 6,256
  • 10
  • 65
  • 87
2
votes
1 answer

Cannot access SQL server instance from SSRS Report Designer - Named Pipe error

I have the following setup configuration for SSRS: Sql Server 2014 running on VPS1. Protocol enabled: TCPIP SSRS 2014 installed on VPS2, and configured to access SQL Server ReportServer database from VPS1 Reports from SSRS use a shared data source…
bzamfir
  • 4,698
  • 10
  • 54
  • 89
1
vote
1 answer

SSRS Report Builder Shortcuts

Its just a short Question I couldn't find any answers here or in the web thou. Is there a shortcut to jump into an expression in a Report? I handle complicated Reports with basicly only expressions and it would be much faster if there where a…
nicolas
  • 75
  • 1
  • 1
  • 9
1
vote
1 answer

SSRS: How can I "continue" rows to a second "column" and avoid wasting empty space?

My tablix groups on one of its columns and only needs to output a list of time stamps for each row. As the time stamps are only two columns, that leaves an awful lot of wasted space. Here is a basic mock-up of the current layout... ... and this is…
Pablito
  • 79
  • 9
1
vote
0 answers

SSRS Report Interface Takes a Long Time to Load, Only in One Environment

We have a collection of reports that are deployed to several environments. The reports work as expected in all environments except for one. In this particular environment, the reports - which normally take a couple seconds to load - take 2-3 minutes…
GreenShepherd
  • 77
  • 2
  • 13
1
vote
1 answer

SSRS 2019 - slow rendering of ALL reports

I recently upgraded my SSRS site from 2014 to 2019. No issues upgrading, but one annoying thing is happening; every report is taking an extra 10-20 seconds to start the display process, and it happens every time. When I click on a report, the…
Steve Henry
  • 21
  • 3
1
vote
0 answers

SSRSReport printing service - Invalid report definition error occurs randomly and will only work again after restarting the service

I have a background service written in C# that picks up print jobs, executes an SSRS report (Using Microsoft.Reporting.Winforms.dll) with a given parameter, and prints the result. 95% of the time this service works fine. However, every so often, at…
Luke4792
  • 455
  • 5
  • 19
1
vote
1 answer

SSRS report with many-to-many tables in sub-tablix

I have a main table (Table A). It has separate many-to-many relationships to two other tables (Table B and Table C). I would like to create an SSRS report that has one row per record in Table A, but then displays a sub-table for each Table B and…
kralco626
  • 8,456
  • 38
  • 112
  • 169
1
vote
1 answer

SSRS Automate Export of Report for Each Parameter Value

I have a report in SSRS that has one parameter named Employee Name that allows the viewer to filter the report by employee. The parameter is a drop down that has approx 500 employees in the list. I need to export the report for each employee in the…
ptownbro
  • 1,240
  • 3
  • 26
  • 44
1
2
3
…
12 13