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

Default Chinese Characters in SSRS

We use SSRS (2008 R2) to present data from several languages. We use labels with the Arial font. If the characters loaded from the database cannot be presented by Arial, SSRS converts them automatically to the relevant font that includes the special…
Silvano Bini
  • 23
  • 1
  • 5
0
votes
1 answer

SSIS/SSRS-The variable "MyNameSpace::MyVariableName" specified by VariableName property is not a valid variable

Environment: SQL Server 2008 R2 I keep getting this error on a scheduled job running on SQL Server 2008 R2: Error: Code: 0xC02020EE Source: Data Flow Task - Fix Missing this and that Row Count - This Not Fixed [148] Description: The variable…
DiligentKarma
  • 5,198
  • 1
  • 30
  • 33
0
votes
2 answers

SSRS reports show repeating data from row above it

I like using the out of the box table Wizard for SSRS. However the default behavior is not showing repeating data from one row to another. Is there a way to change that behavior? For instance I would like Portland repeated twice instead of only…
Anthony
  • 913
  • 3
  • 23
  • 32
0
votes
2 answers

SQL split row contents to multiple rows

Hello I am new to sql and I am not sure if it is possible like below I have a row like this: abc,xyz; bcd,ddd; qqq,eee I want to write a query which will split the row to multiple rows like this: abc,xyz bcd,ddd qqq,eee Rows may contain 1 or 2 or…
Piyush Jain
  • 5
  • 6
0
votes
1 answer

In a query, how do I convert nvarchar that is formatted as hh:mmAM[PM] to time

I need to query a table with records that have a start_time and end_time field. Their data type is nvarchar(100) and formatted like this example: 09:30AM I need to do a before or after comparison on these fields, and to do so I need them in the time…
office_sql_guy
  • 1
0
votes
2 answers

Is possible to concatenate multible fields with one that is a conditional iif statement

I'm working on an ssrs report using Report builder 2008, currently trying to concatenate using something like this but when I do so, I receive an error for the field 'lifeamount' specifying that the expression can only refer to fields within the…
KAL077
  • 85
  • 1
  • 1
  • 7
0
votes
1 answer

SSRS adding percentages to the end of the line

So I have a report that looks like this I am trying to add a percentage of total in the last column that works the same way the current Total is working right now. For instance nest to the total for email I would like to see 88% (Total types, 214…
Anthony
  • 913
  • 3
  • 23
  • 32
0
votes
0 answers

SSRS - listing out CUSTOM data sources?

I am trying to change the server for several dozen reports, all developed by different people, that use a mix of: Shared Datasources (have a query for this) Custom Data Sources in RDLs (not perfect but I have a PowerShell script that will download…
mbourgon
  • 1,286
  • 2
  • 17
  • 35
0
votes
0 answers

Reporting Services Report Export to Excel Crashed in My Program

I have a problem ssrs report export to excel in my application .I taken always this error .I attached picture.How can I solve problem ? I think it can be internet options security settings but I didn't find anything :
Sezer Erdogan
  • 167
  • 1
  • 9
  • 34
0
votes
2 answers

SSRS calculate % of desired colums in column group in matrix

SELECT PatchPhase.PhaseName, MAX(PatchPhase.Sequence) AS seq, PatchState.Application, PatchState.Objectname, PatchState.Jobname, PatchState.Streamname, COUNT(*) AS Total, PatchState.Jobdescription, PatchState.Status, PatchState.Timestamp …
Piyush Jain
  • 5
  • 6
0
votes
1 answer

increase gap between bars in multi category groups

current imageI want to increase gap between bars in my SSRS bar chart after every group is finished (e.g. after every month). I have 2 category groups month and level. in each month there are 3 levels and I want to increase gap after 3 columns. can…
Piyush Jain
  • 5
  • 6
0
votes
1 answer

SSRS report multivalue report filtering and grouping

Let's start with the basics. Here's the simplified structure of the data coming into the report: ID | Tags 1 |A| 2 |A|B| 3 |B| 4 |A|C|D| 5 |B|D| 6 |D|A|C| --I added this row to show that tags could be in any order I have a…
D.R.
  • 1,199
  • 5
  • 19
  • 42
0
votes
1 answer

report viewer control barcode field squeezed when printed

So I have a report (RDL) that has a bar code field on it. I have a report viewer control on an aspx page that will display the report correctly in preview mode on the page, including the bar code. Bar Code Image from Report Preview: When the report…
mbcharney
  • 355
  • 1
  • 4
  • 15
0
votes
1 answer

How to access or retrieve SSRS table ExecutionLog3 in CRM

I am looking for report's parameter which is stored in the table ExecutionLog3 on ReportServer database. Is it possible to access that table through any batchjob or javascript from CRM itself (not using SQL)? Can anyone give idea, if it is possible…
Anish
  • 588
  • 6
  • 21
0
votes
1 answer

Weighted average calculation not working

I'm attempting to calculate the weighted average but getting an "#Error". My current formula is outside the ground in the tablix…
user172839
  • 1,035
  • 1
  • 10
  • 19
1 2 3
…
99 100