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

SSRS Report Execution

I have a need to get the number of executions of a report(s) currently taking place. I thought, maybe, that the execution log view on the report server database inserted a new record each time a report execution started, with the report (item), item…
ddog0823
  • 17
  • 1
  • 6
0
votes
1 answer

Dynamically set shared dataset path in SSRS

I'm having one SSRS report, which is currently using shared dataset which inside the same report folder. Shared Data-set is in the same folder. Path of Shared Dataset is win2008/Reports/ABC/sharedDataset.rsd Now on Production site, report folder…
Pedram
  • 6,256
  • 10
  • 65
  • 87
0
votes
2 answers

Create Special Reports

I've a situation, I google it and found a lot of data but isn't clear for me how I should accomplish what I want. I've a DB (SQL server 2014 enterprise) with 1TB size. There are customers that needs special reports that the application doesn't…
Mariano G
  • 255
  • 4
  • 14
0
votes
1 answer

Does SSRS support formulas in dynamic formatting passed from t-SQL?

I am passing dynamic formatting strings from t-SQL to SSRS, e.g., =Lookup(8,Fields!RowID.Value,Fields!DecLongHdr05.Value,"DataSet1") for the value of the background color in a particular cell of a report and the value of that field…
DaveX
  • 745
  • 6
  • 16
0
votes
0 answers

How to Roll up recursive value in ssrs

I have a table with value for example ID Name ParentID Value Date 1 ClassA 0 NULL NULL 2 ClassB 0 NULL NULL 7 Jason 1 50 2016-06-01 8 Jason 1 20 2016-06-02 9 …
Jason Kee
  • 1
  • 1
0
votes
1 answer

SSRS page numbers incorrect in pdf format

I am generating a SSRS report from SQL2014. The report renders correctly when looked at in the Report Builder preview, but when exported to pdf the report numbers are incorrect. In my test report there are three "reports" each 1 page long. So each…
Des Horsley
  • 1,858
  • 20
  • 43
0
votes
1 answer

OVER SQL Construct not supported in SSRS

I have a query with which I am trying to create a dataset in SSRS, but I am getting an error saying, The OVER SQL construct or statement is not supported. The query I am using is as below: SELECT AM, REP, PRIM_SPEC, SUM(TOT_CALL) FROM ( …
Yousuf Sultan
  • 3,055
  • 8
  • 35
  • 63
0
votes
3 answers

Sort Column Group in SSRS Matrix

I created a report using matrix and I want to add interactive sort for it's column group. When I add interactive sort for Sales Amount it does not work. This is my first look of my report: and when I click on sort arrows it turn to this…
Arian
  • 12,793
  • 66
  • 176
  • 300
0
votes
1 answer

Deploy SSRS to google sites

I wonder if any one can explain how to deploy a report server project to google sites? If a understand it right I need a report server for publishing the reports.
Nörden
  • 155
  • 1
  • 2
  • 12
0
votes
0 answers

BI-Report Project "The specified report server url xxxxx could not be found

I am using VS 2015 community and MS Sql server 2014 Trying to learn on how to use Reporting Services with C# by this article: Creating a heat map in Reporting Services I have gone through these "The specified report server url could not be found"…
Aaron M
  • 326
  • 2
  • 13
0
votes
0 answers

Rectangle Creates Extra td tr Tags in SSRS Report

I'm using SSRS Report. While using Rectangle in SSRS Report, on web page it creates extra td/tr tags like below image. Report How can I remove such td/tr tags or is there any way to eliminate? Actual Image of Design Issue:
Pedram
  • 6,256
  • 10
  • 65
  • 87
0
votes
2 answers

SSRS-Best way to represent specific metrics

I'm self-training in SSRS 2014. I have a specific set of data I'd like to represent, to wit: we have a fund-raising goal, and have money coming in toward that goal. The money coming in falls into one of four different buckets - so I'm looking for…
CoderDonna
  • 13
  • 4
0
votes
0 answers

SSRS 2014: The report parameter has a DefaultValue or a ValidValue that depends on the report parameter. Forward dependencies are not valid

After trying a lot on Google, I ran out of luck and here I am seeking your help. I am trying to create a dataset in SSRS using a Stored Procedure and I am having hard time. Could someone please shed me light of what I am missing? Here is the how my…
Julaayi
  • 403
  • 2
  • 8
  • 23
0
votes
2 answers

Convert DDMMYYYY varchar value to MM-dd-yyyy in SSRS

I wanted to convert DDMMYYYY formated data (data type is varchar) to MM-dd-yyyy format using SSRS expression only. I tried the following but it is showing #Error…
Pedram
  • 6,256
  • 10
  • 65
  • 87
0
votes
1 answer

How to Create Embedded Data Source in SSRS 2014

I want to create embedded data source in SSRS 2014 using Visual studio 2013. But there is no item for embedded data source. How I can add it? Thanks
Arian
  • 12,793
  • 66
  • 176
  • 300
1 2 3
…
12 13