reporting-services

Show the "Report loading" message programmatically in a web app?

Can I do that somehow from for example a codebehind file? Thanks :-) ...

Is it possible to specify the data source during execution of an SSRS report via the web service?

Hello all, I have a single server that hosts our production and development databases. It's running SQL Server 2008 (not R2) with SQL Server Reporting Services. I deploy a VS 2008 Reporting Services project to the server to provide the reports. All the reports use a single shared data source, currently pointing at the production databa...

SQL Reporting 2008 Multiple tables repeating on each page

Hey Guys Ive got a report that has 2 tables, Table1 & Table2. Table1 can have up to 5 rows and then needs to continue on the next page. Table2 which sits below Table1 also needs to be shown on the next page as well. I can get Table1 restricting its records and page breaking to another page though the issue is getting the second table ...

Why is CSV export missing in my SSRS report?

Hi, I have a few SSRS reports running on SQL Server 2008 Web Edition SP1 on my production web server. For some reason, CSV and XML export is not offered to me when viewing my reports in the report viewer. This applies to all reports on that server. As you can see, PDF, Word and Excel still work fine, it's just XML and CSV that are mi...

MS SQL SSRS. I have Page Setup button in BIDS designer but users dont have it in the Reports Manager

There are quite a few buttons in BIDS (VS2008) when I preview a report but in the Report Manager what the users can see - there is only Export button. I would like at least have Page Setup button so the user can manage the export. If for instance I want to export to PDF on landscape A3 - what do I do? P.S. the SSRS and DB are MS SQL ...

Unable to make Business Intelligence Projects. How do I resolve a "Configuration system failed to initialize" error message?

My problem is that I am receiving a "Configuration system failed to initialize." error every time I try to open or create a Business Intelligence Project in Business Intelligence Development Studio. I am on a fairly new install of Windows Server 2008 R2 Enterprise in which I first installed SQL Server 2008 R2 Enterprise (with the Busine...

RDL client-side (local) reporting on .NET 4.0?

I just stumbled across the VS2010 "upgrade or die" confrontation for the RDL report designer. Before I destroy a perfectly good monitor, I decided to take a deep breath and calmly ask if anyone can give me the real scoop on what is going on with RDL client-side reporting. I've seen it said that it can't be done with RDL 2008. Is this ...

Reporting Services: Exported to Excel results are different than the ones viewed on IE

I'm having this problem: The SQL Server holds a said value, let's say 990.30, the Reporting Services Report show a different value (948.33) when viewed online, in the brower and a third value (912.22) when the report is exported to Excel. There are no formulas on Excel, just plain values. Also, there's no formula on the layout of the r...

Difference between versions of Report Viewer Control

There are several versions of the Report Viewer Redistributable. If I'm reading things right, the versions do NOT correspond to a version of Reporting Services. Is this correct? They instead correspond to a version of the .net framework? Is anyone holding a link to a comparison of versions (8, 9, and 10)? I've tried searching for ...

Which datatype for base64 encoded image ?

Question: In order to store logos in a database and display them dynamically in ms-reporting service, I need to base64 encode the image. It doesn't work with binary saved images, due to MS limitations... Now my question: Which datatype do I use? Varchar, nvarchar or text? I guess varchar would be good enough, since base64 encoded, but ...

How are the row heights in an SSRS tablix calculated?

Hi, I am wondering how the row heights in an SSRS tablix are calculated. For instance, I have data for which the displayed and grouped by columns are close enough to be identical. However, some rows will for some unknown reason have a massive height with a lot of blank space. If you inspect the HTML output you can see that these rows h...

MS Reporting services - How to pass cell color

I am trying to create a report that has some data values. Each data value can be of a 'good' or 'bad' quality. I would like to pass a value color through the dataset using a custom C# data provider object. Once in the report designer, I can use 'Fields!MyColumn.Value' and it works fine. There is also an option to type 'Fields!MyColumn.C...

SQL Server Reporting Service

I'm trying to set up a Report server on my local machine, but I cannot get past the Database Setup step in the Reporting SErvices Configuration Manager. I have SQL Server 2005 on my machine, which runs XP SP3. I have reporting services installed, and the service is running, but anytime I try to setup the Reports and ReportServer datab...

ReportBuilder 2.0 creating dynamic tables

I was wondering... In C# you can have a checkbox's and foreach checkbox checked you could do something like create a HTML table and populate foreach box checked.... i want to do the same thing in reportbuilder 2.0 on user selection of projects to create tables and fill foreach project (at a more basic level) if i could just create a...

Installing SQLServer express 2005 Reporting Services after VS 2008/2010 install

I installed SQL Server Express 2005 a few years ago. Since then I've installed Visual Studio 2008/2010 Express, which installed SOME SSE 2008 components on my machine (Management Objects). Now, I want to go back and install the SQL Server Reporting Server component (part of 2005 Express Edition Toolkit) into my 2005 installation. The ins...

How to use DataSources and DataSets in LocalReport

Hi all, My company is going to use Azure environment for future applications. However, currently, Azure does not allow us to deploy reports to Azure SQL Server. Therefore, the only way to show report is using local ReportViewer. My job is to write a reporting engine that using local ReportViewer to show the report. However, I am facing...

I need to create a lookup table in Report Server Database

I am working on SSRS 2005. I work with third party databases and I cannot create the table in those databases. My only option is to have a lookup table in the ReportServer database. I dont know if its possible. Is there any way to create a lookup table on the ReportServer database? Thanks in advance. ...

Hidden rows in SSRS and Exporting to Excel issue

I have a report that has 3 expandable columns. I have a condition in one of the rows that says the following for the hidden property: =IIF(Parameters!GroupBy.Value = "Fleet", TRUE, FALSE) Basically this is saying that if the parameter picked is Fleet then the hidden value is set to true otherwise its set to false. It looks perfect in ...

Reporting Services error messages and navigate back to report

Guys, I am working on SQL Reporting services. I have a report where an invalid value is entered as part of the criteria for a report a new screen is produced with the error message, there are no buttons on this screen so the only way to navigate back to the report is by clicking on the browsers back button, in which case all of the sear...

How to restore Override Default button for default value in SSRS parameters configuration

If I click on an Override Default button, a textbox appears. How do I get the Override Default button back? ...