reporting-services

Do Crystal Reports or Reporting Services support themes in Visual Studio 2010?

Do Crystal Reports or Reporting Services support themes in Visual Studio 2010? So that different reports share common attributes, the same way css works for web pages? I know they didn't in earlier versions and wondered if they added this support. While at it, any .NET reporting tools which support themes? ...

SQL Server Reporting Services 2008 - run reports from console app

Hi, I've like to be able to run reports from a console application. The reason I need to do this is because we have a single template with a few params and many reports running off that template - each providing different arguments. It is easier for us to schedule a console app and have the report arguments read from a database. How ca...

SSRS wrap text in Text Boxes....

I have an SSRS report with a Text box that the user needs to enter notes into. If the user types a super long sentence, the text extends beyond the edge of the page in MS Word. I have set the property CanGrow to false. Is there something that needs to be done to ensure the text wraps inside the text box? ...

SQL Server Reporting Services ReportViewer authentication

I'm working on a project involving the .NET ReportViewer, and I'm having issues connecting to the Report Server. I'm a .NET newbie so bear with me. I can't put up the code but hopefully someone will be able to give me a little guidance here. I dragged the ReportViewer control from the toolbox onto a newly created page. Eleventy billi...

Column headers from different dataset in MS Reporting Services

Hey, I basically need to load table headers from one dataset and table data from another. Is it possible to do with MS Reporting services? As I can see table is associated with the data by DataSetName property and it can be only one dataset. ...

How do I write an if else statement in Reporting Services expression language?

I would like to write a Reporting Services "Expression" that basically behaves as the following (pseudo code)... if ([Fields!StateProvinceId.Value] == 1) { return "Ontario"; } else if ([Fields!StateProvinceId.Value] == 2) { return "Quebec"; } else if ([Fields!StateProvinceId.Value] == 3) { return "Manitoba"; } // ... // more ca...

From VSS to Subversion - things to watch out for

We have a SSIS, SSRS and SSAS code repository in VSS that we are moving to Subversion. We have made the sane choice of keeping history in VSS and are making it read-only. I am going to download my entire structure, make it writable, remove all VSS files and VSS info from the Solution and Project files, and then import it into Subversio...

When do I need to update the Report Model

Hi! There is a constant change (!) in our database, new columns are often added. Is reporting services the tool to choose for reporting in this case? Case1: Developers add a new column to a table used in a report. Will the old reports created with a report model based on the old table still work? Case2: Developers add a new column, ...

Reporting Services with Entity Framework

I am using SQL Reporting services to hit a WCF web service. My query is: <Query> <Method Name="GetADTHistory" Namespace="http://tempuri.org/"&gt; <Parameters> <Parameter Name="personId"><DefaultValue>7885323F-DE8D-47E5-907D-2991C838FF3E</DefaultValue></Parameter> </Parameters> </Method> <SoapAction> http://tempuri.org/IRe...

SSRS if string says this then change it to this

I have a field in SSRS and it returns from SQL saying "Incomplete" In SSRS I want to say anytime this field says "Incomplete" to change the string to "Pending" This has to be done in SSRS. Thanks! ...

What's a good standalone viewer/renderer for RS reports?

Not that technical a question I guess, but what do you guys use? I normally use CRM, but I have a use for a totally standalone one, and I'm not sure what to use for this. ...

Has anyone figured out a way to render a Reporting Services report at a resolution greater than 96ppi?

I've tried everything I can think of to change the rendering parameters for a report that I need to render as a 300ppi TIFF. Here's one of several attempts using the URL approach. As we went from 96ppi to 300ppi the size of the 8.5 x 11 image increases dramatically, but the resolution remainded at 96ppi. //s0550284/ReportServer?/ERecor...

Report Headers not repeating on random pages in SSRS 2008 when exporting to PDF

I am writing a report in SSRS 2008 that has the following advanced layout: Static Static Static Static Group1 Details Static Static The settings for the top 4 static rows (which are my headers) are set to RepeatOnNewPage = true, FixedData = true, and KeepWithGroup = After. When viewing the report through SSRS or through V...

MySQL open source reporting services

Hi, I am currently working on a project where reporting services are required. The database back end is built using MySQL and I would like to have something with similar functionality to say SSRS. Does anyone have any experience with an open source solution for this? Any they would particularly recommend? It would have to be accesse...

SSRS. Group 2 different parts of a row in the report

I use SQL 2008 I have report with few groups on the left, then some numbers and another numbers (further on the right) which has to be groupped as well. Field1 Filed2 Filed3 Num1 Num2 Num3 Num4 fff sss aaa 1000 2000 3000 4000 bbb 2000 3000 ccc 4000 5000 i.e. Num3 and Num4 are the same for eac...

SSRS: Performance concerned with replace

I'm trying to replace text in a field in an SSRS report with a lot of data. Are there any performance concerns between the following? =iif(Fields!Field1.Value="Word 1", "Word 2", Fields!Field1.Value) ...and... =Replace(Fields!thisItem.Value, "Word 1","Word 2") ...

Cached Shared Dataset: ExecutionTime?

SQL Server Reporting Services (SSRS) 2008 R2 I've set up a shared dataset that takes a few minutes to execute. It is shared between three reports, and is the core data for these reports. (Some other datasets exist in the reports for parameter population.) I've enabled caching on the dataset, and would like to add the dataset execution ...

At a Cross-Roads: Choice Between MySQL vs MSSQL -> Importance: Reporting

I am currently working on an application for the health care industry for my firm. This application is geared towards the smaller end of the spectrum (as in 50 or less users). The application will offer both a windows forms (wpf) app and a Silver Light app. This application will be used in the insurance side of the health care equation (...

SSRS runs report for 30 sec however it takes only 3 sec in SQL Studio...

SSRS report calls sproc from SQL 2008 and it takes 30 sec to render it. If I call the same sproc with the same params it takes 3 sec to finish. SQL server and SSRS are on the same box. What can I do about it? ...

How to do a mailing using a reporting tool?

Env.: Reporting Services or XTraReport, SqlServer Express 2008 R2, VS2008, WinForms, C# Hi All, My WinForms app must send a customized letter to a bunch of people (whose contact info is in SqlServer). This is the typical job for Word Mail/Merge. But I'd like to do it without Word installed on client computers. I'd rather use MS Repor...