Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008-r2]

Microsoft SQL Server 2008 R2 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed.

Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.

This is a version of Reporting Services provided by SSRS

2305 questions
0
votes
2 answers

Getting "#ERROR" in certain fields when using Split function in SSRS

I am using a split function to separate a column with two street addresses. The information is separated by ,. Some of the rows only have one address associated with them. In those rows for my Street Address 2, I'm getting #ERROR when I want it to…
David
  • 113
  • 1
  • 13
0
votes
0 answers

SSRS - Log user's actions on reports

We want to log every user action(display/print/export) on certain reports of our application. I found that SSRS already have its log(select * from ExecutionLog) and most of the data we need is there BUT that log can be turned off if someone has…
jMEm
  • 1
0
votes
1 answer

Is there a way I can use a calculated expression as a parameter in SSRS?

I'm not able to write the parameter in the data set like I have with two non-calculated parameters. If I'm going about this the wrong way any help is greatly appreciated to get me on the right track. Data Set Query SELECT Inmast.fpartno ,…
David
  • 113
  • 1
  • 13
0
votes
1 answer

SSRS Filter on Table Matrix

Using SQL Server 2014 I have a report, that runs a stored procedure, the resulting set brings back all records. For example all cars sold and not sold for the last 6 months. Based on the initial data set I have created a Matrix, that shows by month…
PJD
  • 743
  • 2
  • 12
  • 38
0
votes
1 answer

SSRS - Report Action

I have a report that contains a LookUpSet expression to pull the total # of Self-Service, total # of subscription and total # of executions from 2 different dataset. =Join(LookupSet(Fields!ReportUNC.Value, Fields!ReportUNC.Value,…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
1 answer

MySQL cannot use ":=" in SSRS

I want to assign an index to each row of the query result, I am following this method to achieve that. This index number is not for displaying purpose, if it is only for displaying, using RowNumber() in SSRS is enough. Instead, I will be using that…
Newbie
  • 1,584
  • 9
  • 33
  • 72
0
votes
1 answer

ReportExecution2010 asmx Features

As currently we are using ReportExecution2005 asmx to generate the PDF/Excel format reports from C# code base. Now planning to update the service reference as ReportExecution2010.asmx. Can some one help me to list of additional features are…
VIJAY
  • 849
  • 11
  • 22
0
votes
2 answers

How to get second largest value in SSRS

I want second largest value. I can get first largest by using max(field name) but how i can get 2nd largest.Is there any custom code. I am new so any help greatly appreciated. Thanks! I want it in SSRS
maddy
  • 50
  • 1
  • 1
  • 10
0
votes
1 answer

SSRS Choose Parameter to Show in Header

I have a report for my customers where they can input a Premise Number, Tax ID, Service Number, or Address to search by. I've set these four options as my parameters. I'd like to show whichever they have selected in my header. Right now, my header…
R March
  • 23
  • 4
0
votes
1 answer

How assign max value of subtotal to the interval of the horizontal axis in line graph of ssrs report

I want assign max value of subtotal of a field to the interval of the horizontal axis. for eg There is a column name newsub which has subtotal sum(newsub). I want to assign max value of sum(newsub) to the interval of vertical axis in the line graph.…
Ashish Chhetri
  • 23
  • 5
0
votes
1 answer

Unable to deploy reports to SSRS web browser

Currently trying to deploy my report to SSRS web browser and I keep getting the error: The permissions granted to user '' are insufficient for performing this operation. > I'm attempting to deploy this from BIDS. I've checked and gave myself…
David
  • 113
  • 1
  • 13
0
votes
1 answer

Prevent header being split into multiple page

In SSRS, there is a KeepTogether attribute for groups to prevent them split across 2 pages. But is it possible to apply the KeepTogether attribute to headers? I have a group that has 3 rows of headers, in some cases, when rendering the data, if it…
Newbie
  • 1,584
  • 9
  • 33
  • 72
0
votes
2 answers

SSRS sum of distinct values

I want sum of only unique values in SSRS report.Is there any logic to achieve this. this is what something like this sum(distinct value) Thanks
maddy
  • 50
  • 1
  • 1
  • 10
0
votes
2 answers

SSRS - Adding total row + percentage of the total

I have two types of fruits - bananas and apples. My report shows (using matrix) how many of each type certain people have, using this test query: SELECT 1 AS fruits, 1 AS bananas, 0 AS apples, 'person_1' AS people UNION ALL SELECT 1 AS fruits, 0 AS…
Alex_404
  • 399
  • 2
  • 12
0
votes
1 answer

How to add sub report in SSRS

How can I add sub report with parameter in SSRS report using visual studio 2015. I have tried a lot but getting this error "A Value expression used for the report parameter ‘ID’ refers to a field. Fields cannot be used in report parameter…
Jyoti Shisodiya
  • 1
  • 1
1 2 3
…
99 100