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

how to convert a query from cognos sql to t-sql

I have a report which is running on Cognos and that we are migrating to SSRS. The Cognos SQL uses the rank function. Can someone please help me to figure out how I can write the same query in T-SQL: rank() over (at "left"(upper(cast_char(TIMESTAMP…
deep
  • 41
  • 1
  • 12
0
votes
1 answer

Getting #Error in SSRS when trying to run calculation on null value, despite IfNothing clause

I have a column of data brought in from SQL that is sometimes populated, other times null. In an SSRS report, I have two columns: one for the actual value, one for a calculation on that value. The column for the value is blank when it is null, which…
Dom Vito
  • 507
  • 8
  • 38
0
votes
1 answer

SSRS - SUM values in a column for part of the dataset (filter condition on date value) H E L P

I have a dataset with 2 different dates in it (current & previous), let's say it looks like this: DATE NAME QUANTITY MONTH 5/15 John 10 JAN 5/15 John 25 FEB 5/15 Tim 5 JAN 5/15 …
Jay
  • 455
  • 3
  • 17
  • 34
0
votes
1 answer

Loop to create multiple reports dependent on a date

I need to create multiple reports at once taking into consideration the date column. For example: INVOICE COMMENT DATE ------------------------------------ 1111 example1 14/04/2018 2222 example2 14/04/2018 3333 …
Piston
  • 95
  • 1
  • 12
0
votes
1 answer

SSRS SQL Server Authentications

I'm having an issue with an SSRS report using SQL Server Authentication. I'm creating the report in VS2017 (SSDT), latest update 05/11/2018. Creating a pretty basic report with 2 data sources. The data sources appear to be valid and passes…
Jeff Bryant
  • 71
  • 9
0
votes
1 answer

Run The SSRS Dataset based on the rendering options like CSV

I have two different datasets in SSRS report which gives different outputs. I have used one dataset for summarized information (i.e Chart) and other is used for actual data (Table). 1) Chart will display output at the time of report execution. 2)…
Siva Krishna C
  • 1
0
votes
1 answer

LENGTH Equivalent in Report Builder 3.0

I am building a report in Report Builder 3.0 and require spacing that is conditional on the length of a parameter. Because Report Builder 3.0 does not have the LENGTH function that it did in 1.0, is there a workaround? I want to avoid solutions that…
user219454
  • 81
  • 1
  • 8
0
votes
0 answers

SSRS Export to MHTML is not displaying Element based on Visibility Settings

In SSRS, the logo has been displayed with the help of external image resource. The visibility settings are handled by expression as like below Globals!RenderFormat.IsInteractive Since we don't want to see the logo on Report Viewer Control and just…
VIJAY
  • 849
  • 11
  • 22
0
votes
0 answers

Table header repeated ssrs for every group instance

I have a tablix with a header and a data row. The grouping is for data row only. No page breaks applied for group instances. The problem I'm facing is that the header row is getting repeated for every group instance. every group instance is getting…
sourav roy
  • 1
  • 2
0
votes
1 answer

Export to Excel with multiple worksheets for multiple datasets

I'm building a report in SSRS with TWO separate Datasets. One Dataset EXCLUDES some data for a certain date range. The Second dataset is only for EXCLUDED data for that date range. I would like to show the EXCLUDED data on a separate worksheet…
user1777929
  • 777
  • 1
  • 10
  • 28
0
votes
3 answers

how to download all the report from SSRS report

I am new in this field and I am looking to download a single report, but it has more than 200 values in a drop down. Can you guide me how to download all the report with 200 values in one go. Let me give you an overview of what the data looks…
Avinash Kumar
  • 41
  • 1
  • 11
0
votes
1 answer

How to generate numbers for showing sequence in SSRS also it should get rearrenge when any field inbetween is missing

I am facing problem in SSRS report for showing sequense numbers as given in image. when I searched for this issue I got solution as -- RowNumber("DataSetName") but problem with this is, it generate numbers like 1,2,3..., but I want these numbers in…
Muktabai Chavan
  • 117
  • 9
0
votes
1 answer

How to combine summary and detail informatoin on SSRS report

Have a monthly report that lists associate name, date, the type of work they completed and how many. This report is being rendered in Excel and produces a separate tab for each associate with their information. I'm trying to modify the report so it…
tgall0163
  • 53
  • 1
  • 10
0
votes
1 answer

Print Format SSRS Report For Excel Export

I created a SSRS Report and I am Exporting it to an Excel Sheet. I am manually print formatting the excel sheet every time I want to print it. The width of the report that I've created is slightly bigger so every time I print the excel sheet I go to…
yoyo yagami
  • 257
  • 1
  • 5
  • 18
0
votes
1 answer

How do I allow a user to enter a value into a report and then use this value as a parameter for a linked report?

I want to make a report where, after loading and rendering, the user gets a textbox where they can enter in a value. Then, I want to add a link to another report where it takes the value from the textbox and uses it as a parameter. Is this possible?
DarthVoid
  • 604
  • 3
  • 9
  • 21
1 2 3
…
99 100