reporting-services

RDCL 2008 /*Local Query*/

Hi all, I am new for RDCL 2008 format. I used RDLC 2005 format for a while and it works fine. However, recently, my company is changing to RDLC 2008 format from RDLC 2005 format. The original report rendering engine crashed. Because in RDLC 2008 format, the connection string and the query string became <ConnectString>/* Local Connection...

Where can I download the ReportDefinition.xsd for SSRS 2008 R2

I need to dynamic generation rdlc file,but MS website link is broken: reportdefinition 2010 ...

Empty or Null value display in SSRS text boxes

Using SSRS (2008) what is the best way you have found to handle null or empty values and replace them with something else to display. The quite obvious solutions is =IIF(IsNothing(Fields!MyField.Value),"NA",Fields!MyFields.Value) That works though it is tedious, my hope was to find something like an EmptyText property on the textbox b...

Crystal Reports alternatives.. and does SQL Reporting Services have field definitions only option?

Okay, two part question I guess. I liked Crystal Reports, although now (if I understand correctly) the licensing model means if I deploy Crystal 2010 via say webform within my application, I have to purchase a runtime license of $2000+ ? I haven't used SSRS (SQL Server Reporting Services), although I gather that you can use the reportv...

Suitable platform for developing browser based database application (reporting) with SQL Server?

I need to develop a dynamic web page retrieve data from a stored procedure on a SQL Server. Considering the licensing issue, development resources, security and maintainability, can someone suggest a suitable platform for this project? I have a Ubuntu server running Drupal and also a Windows Server 2003 running SQL Server 2000 and IIS ...

How do I hide sections based upon some criteria?

I'm working on a SQL Server Reporting Service report, that will eventually be in my WPF app. There are certain sections of the report which should only be shown, if certain conditions are met. How do I make sections appear or be hidden/collapsed in the Report Viewer? (I'm working in VS 2010.) ...

Interacting with Reporting services with C#

Is there an API or interop for interacting with Reporting Services 2005/2008 from .Net or in particular C#? The reason is we have some business logic for our row-level security in our application server, and would like our application server to work with the reporting services. Any guidance on this would be really appreciated. I foun...

How to format SSRS Tablix

Hi is there anyway to format ssrs tablix? I mean, I would like to apply some styles, themes similer to charts. Is it possible? Thanks in advance ...

reportviewer is not visible in c# express 2010 win form at design-time

I installed Microsoft Report Viewer Redistributable 2008 and use report viewer in the C# express 2008 win forms, also i installed Microsoft Report Viewer Redistributable 2010 and use it in the C# express 2008 win forms, but in c# express 2010 when i add reportviewer (2008 and 2010) to win form it is not visible at design-time, why? ...

SQL DataSet using Model

Help I am attempting to create some report on a report server model. I need to create a text type DataSet, using sql. Once I have written the SQL and click on OK it attempt to load back into Design>>Data view, but fall over. It show the below error A connection cannot be made to the database. Set and test the connection string. Add...

Drilldown Reports

Help I am attempting to create a drill down report using report server and Visual Studio 2005. I have been able to create a tree structure, but the original report looks like it opened a new report. (Crystal Report) This was done by the report hiding all other data apart from the drilled data and the data title. I can’t seem to be abl...

Help for using (exernal images) from the website with SSRS

I have a small web site where i maintain users data. I maintain the users data in table and store there images like /images/users/user_id.jpeg on the server. I am using the ReportViewer control in the asp.net page to show the reports from SSRS in the web application. Now user want reports where they can see the users image in the repor...

How do I specify parameters to a SP and to the report?

I think I've got a fundamental misunderstanding going on, concerning a SQL Server Reporting Services report, which I'm trying to make run locally in a WinForms app (eventually it will be in a WPF app, but that's later). I'm don't write many reports, and whenever I have in the past, I've used Crystal Reports. But we're trying to get awa...

SQL Server Reporting Services - http 403 forbidden - website declined to show this webpage

Reporting Services was working fine until recently, now when I try to deploy and run a report from Business Intelligence Studio I get this error. Similarly when I try to connect to the ReportServer URL directoy from IE Explorer, (set to http:///ReportServer I get the same error, so it's not specific to the report but probably rather to...

Using 2008, how do I add the rich textbox?

Using 2008, how do I add the rich textbox to my toolbox? ...

SSRS 2008 Error Message. What does it mean?

Anyone have a clue what this error message means? An unexpected error occurred while compiling expressions. native compiler return value ‘128’ ...

Multi data in 1 line with reporting service

Hi all. I'm beginner reporting service and i have problem. I have dataset with many borrower like this: Loans Borrower DateCreate ----------------------------------------------- L1 name 1 10/7/2010 L1 name 2 10/7/2010 L1 name 3 10/7/2010 L2 ...

I want to Repeat Page Header on each Page for reports.Repeat on NewPage is not appearing in properties of Tablix member in SSRS 2008.

How to Repeat Page Header on each Page. Repeat on NewPage Property is not appearing in ssrs 2008 tablix memeber property ...

SQL Server Reporting Service

Hi everybody. Recently I saw a presentation in which the reporting part of the software had a nice feature. When we hovered the mouse over the charts in the report, datailed information regarding that part of the chart appeared as a tooltip. Is there such a feature in SQL Server reporing services 2005? If not, how can I add it? Also ...

SSRS report parameters

In my SSRS report there are 2 parameters called DataSourceIDList and ReporterIDlist. DataSourceIDList : is a drop down list and this will populate based on SQL query. ReporterIDlist : is a drop down list and this will populate reporters based on selected Datasourceid from DataSourceIDList and this is also a SQL query. both parameters ...