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
3 answers

How can I order months given as strings in SSRS

How can I get months (in string) ordered in a SSRS query. I use month as parameter in a drop-down list. This code seems to not be working. SELECT DATENAME(month, DATEADD(month, 6, getdate())) AS MonthName UNION SELECT DATENAME(month,…
user10513216
0
votes
1 answer

SSRS report: {2008-r2} (.rdl file) Tablix -- Add Horizontal scrollbar to data

SSRS report: {2008-r2} (.rdl file) Tablix -- Add Horizontal scrollbar to data I am trying to add a horizontal scrollbar to an SSRS report with many columns. The rdl file is written in xml or an xml-like language. When I try to add a tag (and its…
JosephDoggie
  • 1,514
  • 4
  • 27
  • 57
0
votes
1 answer

SSRS shared datasets missing

Source files for shared datasets are lost/missing. Any way to generate these from the SSRS report definition that is referencing them? Thanks!
dnndeveloper
  • 1,631
  • 2
  • 19
  • 36
0
votes
1 answer

Out of memory exception Error when generating a SSRS report

I'm creating an SSRS report using report builder that generated large amount of data based on from to dates parameters. If I run the report up to 3 months the report works fine, however when generating the report for a longer period generating…
Georges Sabbagh
  • 259
  • 3
  • 12
  • 27
0
votes
1 answer

How to do SSRS Document Map bookmarking for subreports

I have a SSRS solution with several subreports in one report. Client needs bookmark(in PDF) for each subreport as shown below. Left section shows SSRS design page with textboxes and subreports stacked . Right side shows the result we need to…
Jz Worx
  • 41
  • 3
  • 9
0
votes
1 answer

Issues with Passing Multi-value Parameters to a Drill through Report

I have two reports were I pass multi-valued parameters to it's underlining data and both reports work very well independently. The parameter strings are being split using the function dbo.UTILfn_Split. When trying to drill from the main or Summary…
UpwardD
  • 739
  • 4
  • 12
  • 36
0
votes
1 answer

Using a table value function in a SSRS dataset causing an error

My dataset works fine in SSMS but when I try to insert it into SSRS I get the error Incorrect syntax near the keyword 'CONVERT' (Error 156) The reason why I used a function was to split a string in order to get the fields Attention, Address 1, and…
David
  • 113
  • 1
  • 13
0
votes
0 answers

SSRS 2008 R2 Missing reference to System.Numerics

I have an SSRS report that I wrote, taking advantage of System.Numerics.BigInteger. When the client installs the report they get this error: The client is using .NET version 4.6.1 and the report works when installed on my local server. When I wrote…
Jmaurier
  • 767
  • 2
  • 10
  • 28
0
votes
1 answer

Naming worksheets once an SSRS report is exported into Excel

I have a single report which includes several tablixes. Once the report is run, it is exported into Excel by the team using it. For each tablix I clicked into its properties and ticked Add a page break after doing this ensures that when the report…
Will F
  • 417
  • 2
  • 6
  • 17
0
votes
1 answer

SSRS expression not working for Runningvalue

Please kindly suggest why my below expression not working RunningValue(Fields!EXST_CHECK.Value,CountDistinct,"PROGRAM_DATA")/RunningValue(Fields!PATIENT_REGISTRATION_ID.Value,CountDistinct,"PROGRAM_DATA") Error - The Value expression for the text…
XYZ
  • 41
  • 7
0
votes
1 answer

SSRS - How To Display Top N on Column chart

I have a column chart that has 40+ categories, what I want to accomplish is to display the top N on the column chart and combine the rest of the categories as "Other Category" so that it will fit in the column chart. I can set-up the top N in the…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
0 answers

Custom ssrs expression not working when trying to connect to SQL Server 2008 servers

I am working on a ssrs report where I am using a custom data source i.e. I am using ssrs expression ="data source=" & Parameters!ServerName.Value & ";initial catalog=master;integrated security=sspi" to use multiple connections from selected…
Malik Kattubadi
  • 11
  • 1
0
votes
1 answer

SSRS - Interactive Sorting with LookupSet Expression

I have a report that I need to add an interactive sorting, but the column that I need to add the sorting has a LookUpSet =Join(LookupSet(Fields!ReportUNC.Value, Fields!ReportUNC.Value, Format(Fields!cntSelfService.Value, "###,#######0"),…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
1 answer

Deleting two special characters and text between

I have a report showing text data in a field from SQL Server database. Sometimes users need to put special code at the end of the text, so they put that code between two $. In the SSRS report I need to hide that code and the two $ and show only the…
Amr Magdy
  • 19
  • 4
0
votes
0 answers

dashboard in SSRS with filters per chart

Take for example the following dataset Time | Action | Location 2018-01-01| Kick | Colombia 2018-01-01| Run | Spain I would like to create a report in SSRS that has these pie charts 1) Chart showing Action=Kick for all locations. i.e in…
rukiman
  • 597
  • 10
  • 32
1 2 3
…
99 100