Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008]

Microsoft SQL Server 2008 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed. Use with the [reporting-services] and/or [ssrs] tags

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

This tag is for questions specific to SSRS 2008.

6153 questions
1
vote
1 answer

Show/Hide Parameter Values based on Selected Value of another Parameter. Possible?

I'm trying to find out whether it is possible to engineer a SSRS report where the array of selectable values for a Parameter changes depending on the selected value(s) of another parameter. Let's say I have the following two parameters : House :…
CodeMinion
  • 653
  • 2
  • 10
  • 24
1
vote
0 answers

Copy a folder in same ssrs report server automatically updating new subreport path and shared datasets

I have a requirement.It has a folder let say ABC,ABC has data sources, datasets, reports and subreports. Now after I copy the folder in the same server and name it TESTABC, the data sources are easy to change. But the sub reports and datasets are…
Vlogs Bengali
  • 85
  • 1
  • 13
1
vote
0 answers

SSL enabled in sharepoint, reporting services broke

Everything was working fine and then SSL was enabled on a sharepoint 2010 site, and then reporting services broke. The error now is when clicking on a report I get The Web application at https://somesitecom/lte/Report Library/TestReport.rdl could…
Adam Tuliper
  • 29,982
  • 4
  • 53
  • 71
1
vote
3 answers

BoldReport unable to load RDL reports from SSRS Report Server

I'm using syncfusion bold reports in my angular project and creating RDL reports using SQL Server 2017. What I'm trying to do is to view SSRS report on BoldReport viewer by following this link. But unfortunately facing some kind of error and the…
Ahmer Ali Ahsan
  • 5,636
  • 16
  • 44
  • 81
1
vote
0 answers

Can not see dataset value in report builder preview

I have created one dataset in my local machine select ID, Mark, dense_rank() over(order by Mark desc) as TopRank, dense_rank() over(order by Mark) as BottomRank from cricket order by ID When I setup dataset and datasouce in report…
Ankush
  • 347
  • 2
  • 10
1
vote
1 answer

SSRS report shows me a Lot of empty space to the right hand side. (when you move the scroll bar to the right)

I have created a report using the Report Builder tool. But, when I exported with the MHTML option it shows me Lot of empty space to the right hand side. (when you move the scroll bar to the right) Any ideas please, can you help? I really appreciate…
Newbie SQL
  • 122
  • 13
1
vote
1 answer

DrillThrough in SSRS

I am creating DrillThrough Report in SSRS. This is my database. DatabaseImage In my SSRS first Report i just want to display the period and status. I just to show how many Files run successfully and how many failed. This is the design.First Report…
jhon_123
  • 31
  • 1
  • 7
1
vote
1 answer

SSRS report collapsing and expanding part of the table

I have a table of many columns: Column names/table Is there a way to make collapse/expand feature to the table part "Product Shelf Life History"? Because the tablix is too big, the user has to scroll all the way to the right side. That part is not…
ERud
  • 17
  • 5
1
vote
0 answers

How can I hide columns in an Excel output from SSRS that are not generated by the report?

I need to generate a cover page for an SSRS report, along the lines of this example in Excel: Note on this image the hidden columns after N and rows after 30. Is it possible to force SSRS to hide these columns & rows? I can't find anything about…
BishNaboB
  • 1,047
  • 1
  • 12
  • 25
1
vote
1 answer

How to use LIKE in tablix filtering with OR keyword in SSRS

I have a Table in my SSRS report and I want to filter the incoming data using a LIKE statement. The data looks like CtrlNo OtherColumns J-123 ... K-2340 ... R-3352 ... What I want to show in the table is the data where CTRLNO starts…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
1
vote
2 answers

SSRS: A severe error has occurred on the current command. The results, if any, should be discarded

I'm developing an SSRS 2008 report using stored procs. Previously this report was running successfully. Now, however, these stored procs still run but when I run this report I get the following error: A severe error occurred on the current…
salvationishere
  • 3,461
  • 29
  • 104
  • 143
1
vote
2 answers

SQL Select within a select

I'm creating a dataset that will be displayed in an SSRS report. I have a query in a job that puts a count into a table [dbo].[CountMetersDue] on a rolling basis on the 1st of every month; the value changes throughout the month so need to take a…
jhowe
  • 10,198
  • 19
  • 48
  • 66
1
vote
1 answer

Change default filename on export SSRS

Is there a way to change the default name of an SSRS export file to use current date? by default when exporting to csv, excel, pdf, etc. the default name of report is the name of the report file (filename.rdl) so when exporting to excel the default…
Baldie47
  • 1,148
  • 5
  • 16
  • 45
1
vote
0 answers

NodeJs Render SSRS Report to PDF in a browser window

I have an NodeJS/Express app in which I would like to render SSRS report in the browser window instead of downloading it. Here is relevant code: …
goryef
  • 1,337
  • 3
  • 22
  • 37
1
vote
1 answer

SSRS column and line chart?

Hello I have a simple dataset in SQL that counts meter readings... There are meter readings every day and I would like to SUM the count, display that in a column chart at a daily interval. What I would also like to do is display a cumulative count…
jhowe
  • 10,198
  • 19
  • 48
  • 66
1 2 3
…
99 100