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

SSRS error when running the report in reporting server

Can anyone please tell me what this error is After running the report for long time, I got the above error in reporting server. We have also increased the space in the Reporting server. When I run the stored procedure of the report in SSMS it took…
Akhira
  • 203
  • 2
  • 5
  • 16
1
vote
1 answer

Running Value CountDistinct and Logic Expression?

I have original data like this. Original Data I need to create two report with it, this is the first report : First Report The running value can be achieved with this…
YAN KADOET
  • 15
  • 6
1
vote
1 answer

How to display parts of value from database with different font size in SSRS report?

One of my columns has a value that looks like this -> "$5.95 (Park costs)" and I need to display the value in column in SSRS report like this: $5.95 (Park costs) but font size of "(Park costs)" must be smaller than the price. Is something like that…
Bernard Polman
  • 795
  • 2
  • 14
  • 31
1
vote
0 answers

SSRS 2008 R2 Custom Groupings

I have an SSRS 2008 R2 report that I am building in Report Builder 3.0. The requirement is for the report to export to PDF and the PDF will be navigated via bookmarks created with the DocumentMapLabel attribute. This PDF will need to have multiple…
thomas
  • 2,592
  • 1
  • 30
  • 44
1
vote
1 answer

SSRS Report Fails, How do you determine root cause?

I have a report that essentially is a purchase order. It contains multiple tablixs and about 4-5 shared datasets. For some reason when I attempt to load a PO for specific purchase orders the report goes into a loop and just sits there while the…
Brent Pabst
  • 1,156
  • 1
  • 15
  • 37
1
vote
0 answers

SSRS 2008 R2 Visibility Based on Report Parameter

I am having some issues with dynamically changing report item visibility based on a report parameter. Visibility is set correctly during the initial report run but WILL NOT change visibility of report items after the initial report run, regardless…
thomas
  • 2,592
  • 1
  • 30
  • 44
1
vote
0 answers

how to render report data into Email body with footer content using SSRS

Using SSRS 2008 version,I am generating report to excel which includes two sections in the report.Now i need to schedule Email every two weeks with excel report as attachment and in the same mail include one section in the body along side with…
AMDI
  • 895
  • 2
  • 17
  • 40
1
vote
1 answer

How to correctly turn an imported SQL query into an expression string in SSRS

Sorry to bother everyone with what should be a trivial question, but I need to import an SQL query into SSRS's Report builder, and then turn it into an expression (so that I can use its concatenation operator to join values of a parameter into…
Campbell Reid
  • 139
  • 1
  • 6
1
vote
1 answer

Angular ngx-ssrs-reportviewer Credential Problems

I am having SSRS report server credentials. I want the users to auto login (impersonate) whenever they go to the reports page using the credentials that I have hard coded. I am using Angular ngx-ssrs-reportviewer plugin but every time i open the…
Mohamed Hashem
  • 97
  • 2
  • 7
1
vote
1 answer

SSRS2016 Convert seconds to hh:mm:ss format

I have a table with a column, Duration that has value in seconds. In Visual Studio / SSRS 2016 I want to display it in HH:MM:SS format. I have tried to use the following expressions =Format(DateAdd("s", Fields!Duration.Value, "00:00:00"),…
Olivia
  • 45
  • 6
1
vote
1 answer

SSRS Report appears with empty tablix on the last page

Dears, I developed the report with some of the groups and everything working well but when executing it always get empty tablix on the last page like the below image Empty Tablix I have tried many solutions but without a real solution yet
Marc
  • 33
  • 1
  • 4
1
vote
1 answer

SSRS: is there a way of passing the values of a parameter to a "Values" keyword in the SQL query?

I would like to know the correct method for passing the values of a parameter to a "VALUES" keyword in the SQL in the underlying dataset. I'm using Microsoft Report Builder v3.0, querying an MS-SQL database. At the moment, after a lot of googling…
Campbell Reid
  • 139
  • 1
  • 6
1
vote
1 answer

SSRS join(Parameters!ACCNUMBER.Value, ",") generate rendering error

i am building a SSRS report using report builder 3.0. i have parameter ACCNUMBER which contain a large number or records, and i am using inside my report the below function : join(Parameters!ACCNUMBER.Value, ",") when i generate the report for and…
Georges Sabbagh
  • 259
  • 3
  • 12
  • 27
1
vote
2 answers

How to increment grouping number in query if consecutive values don't satisfy conditions defined?

I will describe problem briefly. ---------------------------------------------------------------------------------------------------- | Total UnitName UnitValue PartlyStatus PartlyValue CountMetric CountValue | RowNo | …
nedensel
  • 43
  • 8
1
vote
1 answer

SSRS Format Number Separator

I have a field in SSRS that returns the value of numbers varying from ## to #######. I want these numbers to be separated by thousands. I have seen a few posts saying you could use this: =Format(Fields!Number.Value,"#,#.##") However, I have this…
Sreenath Umagandhi
  • 13
  • 2
1 2 3
…
99
100