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
1 answer

Is it safe to restore ReportServer database from SQL Server 2012 to SQL Server 2017?

I need to upgrade and migrate from SSRS 2012 to 2017. Database backup/restore seems work. But database objects on 2012 ReportServer database different in structure from ReportServer from 2012. When I went through in place upgrade on SQL Server 2012…
Margarita
  • 1
  • 2
0
votes
1 answer

How to customize sorting based on Column in SSRS reporting

I have created report by adding parent group on column with data as "ALL","Non-GD","GD",MileStone",Total" and report is rendered as expected. But one issue I am facing is with sorting,by default grouping is happening in Alphabetical order.How can I…
AMDI
  • 895
  • 2
  • 17
  • 40
0
votes
1 answer

How to remove gaps between rows displaying in the SSRS Report

I have design report in such a way that rows should display only filtered data based on where "RECORDTYPE=ALL" and another row where "RECORDTYPE=GD" and corresponding columns also filter and fill data by RECORDTYPE. For design purpose,I created…
AMDI
  • 895
  • 2
  • 17
  • 40
0
votes
1 answer

How to access dataset parameter in query parameter while executing oracle stored procedure

I created data-set and trying to execute oracle stored procedure which has one input date/time parameter and three output parameters(One ref_cursor,two varchar). Stored procedure accepts input parameter as Date/Time datatype and default is today's…
AMDI
  • 895
  • 2
  • 17
  • 40
0
votes
0 answers

SSRS Report: Multiple Charts to Export to 1 PowerPoint slide

I currently am using Visual Studio SSDT 2017 for my SSRS Reporting. I currently have a SSRS report with 4 separate line graphs. Is there a way to get all 4 line graphs to export onto 1 PowerPoint slide? Say 1st line graph is in upper left corner,…
smul86
  • 401
  • 1
  • 8
  • 22
0
votes
1 answer

How to display Last week Sunday and last week Saturday in SSRS?

How to display Last week Sunday and last week Saturday from current date in SSRS ? In sql server we can find the last week Sunday and last week Saturday from todays date(CurrentDate='19-02-2020') as select DATEADD(wk, -1, DATEADD(wk, DATEDIFF(wk,…
user2728106
  • 185
  • 2
  • 5
  • 15
0
votes
1 answer

SSRS DateTime Parameter Format

I need to create an SSRS (2017) report with date range parameters, BeginDate and EndDate. Context: this is a report to pull names, birthdates, and deceased dates, based on the deceased date occurring between BeginDate and EndDate. The table I am…
saz
  • 11
  • 1
  • 4
0
votes
1 answer

MS SSRS 2017 Rolling timeframe option

new user here. Summary: I have a set of already created custom reports in SSRS and it can be viewed and printed through a GUI. Now, I want to set up an email subscription for one of the reports on SSRS. It will be a daily report summarizing data of…
jawai93
  • 3
  • 1
0
votes
0 answers

SSRS Multiple datasets - one from SQL Server database, one from Cube data

I have two different datasets and the dataset querying from the SQL Server database has parameters FY and Quarter. The second dataset which is pulling from the cube data has to use the same parameters as dataset 1 .How to add these parameters to the…
Swara
  • 15
  • 7
0
votes
1 answer

How to change the boolean value on the report to display as yes / no instead of true /false

In SSRS , the boolean field from a sharepoint list is being displayed as true or False , I would liek that to be displayed as Yes or NO in the field. How do I do this ?
Swara
  • 15
  • 7
0
votes
2 answers

Can you set a parameter that references an expression field that is calculated based on another parameter selection?

I am attempting to create a parameter which looks at the values of a field in the report which is calculated based on the entry of another parameter. Specifically, the first parameter is a number option (30,60 or 90) and the field expression is a…
MeganBBK
  • 11
  • 1
  • 2
0
votes
1 answer

SSRS Setting Target report path using Configuration Manager

Using 2017 I have several reports in a single project that need to be deployed in different folders (e.g Central/Sales, Central/Marketing) I setup multiple configurations, I select a config for the project (e.g. Central-Sales) and change the…
mark1234
  • 1,110
  • 2
  • 24
  • 41
0
votes
1 answer

How to display row group and grand total percentages on a matrix

I have an SSRS matrix report that i have so far managed to format as above. As you can see i have managed to add the totals by "Area" broken down by "Section" I have also added the grand total row at the very bottom and all is fine up-to this…
StackTrace
  • 9,190
  • 36
  • 114
  • 202
0
votes
1 answer

Deployment to a different enviroment

New SSRS user and have just worked through my first training book (Kathi Kellenberger) and have a question before I move out of Adventure works and to our environment. I will be creating reports in a test environment. This means that my datasets…
Janderson
  • 3
  • 1
0
votes
1 answer

SSRS adding extra characters when exporting to CSV

I am creating an expression combining multiple fields into a single field in SSRS. However when I am exporting to CSV, some of the records are being appended with additional double quotes. How do I fix this? Original…
Julaayi
  • 403
  • 2
  • 8
  • 23
1 2 3
…
11 12