Stack Overflow
Stack Overflow

Questions tagged [ssrs-2017]

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

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

169 questions
0
votes
0 answers

SSRS - Report Builder 2016 not downloading on client's browser

I am unable to download report builder on client's browser. Its showing following error screen (right bottom) and error log. SQL Server 2017 Standard Edition installed on Azure VM. SQL Server 2016 Report Builder also installed on Azure VM. Report…
Snehal
  • 1,070
  • 12
  • 20
0
votes
1 answer

Setting custom colors for the Column chart Report type in SSRS

I have Column type SSRS 2017 report and would like to set a different custom, non standard colors for 2 of my values - "Current period", "Prior period" (it's green and grey now): To achieve this I select Chart Properties / Color Palette /…
Hell-1931
  • 489
  • 1
  • 6
  • 24
0
votes
1 answer

SSRS Parameter Not Dynamically Updating - Last Day of Month

Report has two parameters DateFrom DateTo DateTo set to "Always Refresh" I have the following expression for DateTo - Default Values - so that it will dynamically default to the last of the month set by…
Geezer
  • 513
  • 5
  • 17
0
votes
1 answer

SSRS 22017 passing a parameter value to a url

Hi I have been trying to pass a value in to another report via a URL link, but cannot get the syntax correct, I have trawled the net and the 8 questions already in Stack and tweaked my code for each answer but cannot get it right. I have a fully…
Tony K
  • 1
  • 1
  • 4
0
votes
0 answers

SSRS 2017 Failed to convert parameter value from a int64 to a int32

I have a report in SSRS2017 in the SQL Side i have a parameter filter as it can contain multiple values its set as a "in(@SALES_ORDER)" value. I have 2 derrived tables joined to my main table, 1 on the sales order number and the other on a…
Tony K
  • 1
  • 1
  • 4
0
votes
3 answers

SSRS Row Number Function Not Working in PDF

I am using the below code to add a Row # column in my report: Dim row AS integer Public Function GetRow() As Integer row = row + 1 return row End Function When running the report, the report returns 29 rows and the row column seems to be working…
K. Ventura
  • 91
  • 2
  • 14
0
votes
1 answer

How to filter data in SSRS based on the users SSRS role assignment

Suppose i have 1000 rows in a dataset. The rows have an office/department column. What i would want is to create one report accessible by all users in the organisation but with a STRICT requirement that users should only view data for their…
StackTrace
  • 9,190
  • 36
  • 114
  • 202
0
votes
1 answer

SSRS shows dropdown instead of date picker

I have a report with a single parameter Date/Time. The available values are from query select cast(getdate() as date) c1 union all select cast((getdate() - 1) as date) But both VS preview and SSRS 2017 show that parameter values in…
user7232539
0
votes
1 answer

SSRS data driven subscription and parameters

I'm trying to test setting up a data driven subscription that takes a parameter from the report but it wont validate the query, should I be able to do this. SP: Select * from Table where Column = @Variable The @Variable is called the same of the…
user3691566
  • 303
  • 2
  • 8
  • 17
0
votes
1 answer

Trying to create calculated column for YTD values

I need to calculate a YTD value each day based on a budget table. My table looks like this: Month Rev-50100 Rev-50101 1/31/19 75000.00 364.27 2/28/19 76000.00 360.57 3/31/19 82000.00 391.58 I'm able to handle the MTD pretty…
Marc
  • 87
  • 2
  • 9
0
votes
1 answer

Adding $ to a number removes formatting

I'm a database guy more than a Programmer, so bear with me. I'm creating a receipt form for a point of sales software, and ran into an issue with formatting my numbers. In the number section of the textbox properties it's formatted to add a comma to…
ThexTallxDude
  • 137
  • 1
  • 1
  • 11
0
votes
3 answers

SQL - String Manipulation

Context: I have a view in SQL Server that tracks parameters a user inputs when they run an SSRS report (ReportServer.dbo.ExecutionLog). About 50 report parameters are saved as a string in a single column with ntext datatype. I would like to break…
emalcolmb
  • 1,585
  • 4
  • 18
  • 43
0
votes
1 answer

SSRS Report renders differently in Browser to Report Builder

SSRS 2017 Report Builder correctly renders report with drilldown buttons and field data. When rendered in the browser both the drilldown and field data are not visible. Edge, Chrome and IE all hide the field with the drilldown button on it. The…
Peter B
  • 21
  • 5
0
votes
1 answer

Repeating Static Tablix On Each Page

I am trying to setup a "bookmark" menu table as a side bar on my SSRS report with text that links to bookmarks as different sections on the report. The bookmark menu will be looking as such: I want to repeat this tablix one each page of my report.…
ironfist1988
  • 11
  • 2
0
votes
1 answer

SSRS Report Manager not displaying entire description in List View

We recently upgraded to SQL Server 2017 from 2012 for reporting services. On the report manager, we try to include a description for each report because it is searchable and useful to the end user. The description is getting cutoff in 2017. In…
VeritableHero
  • 5
  • 7
1 2 3
…
11 12