reporting

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...

Any good report/multiple grid/multiple gridview component for Silverlight?

Looking for a Silverlight report component. Nothing fancy, typical report layout would be - a bunch of colored grids on the same endless page. Currently contemplating about giving a try to a Component's One flexi grid control. Is it any good. Any directions and recomendations? Thank you. ...

SQL query with week days

Hi I would like to know what is the best way of creating a report that will be grouped by the last 7 days - but not every day i have data. for example: 08/01/10 | 0 08/02/10 | 5 08/03/10 | 6 08/04/10 | 10 08/05/10 | 0 08/06/10 | 11 08/07/10 | 1 is the only option is to create a dummy table with those days and join them altogether? th...

[Delphi] How would you display a DBGrid's contents in a table within a Word or RTF document?

I'm using Rave to generate reports, but it's poor at generating Word docs. My reporting needs are simple; the only thing I can't do easily within code is make a table. I'd love suggestions about how to display a [DB]Grid's contents (or underlying ClientDataSet records) within a bordered table, in Word or RTF compatible format. Thanks, a...

Count in RS using equivalent to a where clause in Transact SQL

I have a result set like follows from a stored procedure and I need to calculate an aggregate count with a table in a report template. There are more columns returned but this is the caliumn for whci I need the aggreagte. Value 10 94 20 200 90 100 and I need to calculate the number of rows where Value is < 90. So the answer should be 2...

Enterprise Reporting Tool

What are the best enterprise reporting tools like WebFocus and Crystal Reports which can be used from heterogeneous data sources? ...

Crystal Reports / VS'08 - Design, Elements floating to top

Hey, I'm trying to edit some .RPT files via VS08/Crystal Reports. Problem is, if i create new elements or delete/move existing elements, the text below (within a new section) floats up to (or above) the element i created. How do i create elements with an absolute "top-value"? Other than that, if there are there any design-essentials-t...

Centering a subreport on an RDLC

Hello all, i have a subreport on an RDLC that i want to center in the page but i'm having trouble finding anything about doing this. Any help would be appreciated. ...

Reporting services + report parameters and custom dropdown length

Hi, I have some report and plenty of parameters inside that report. One of parameter contains values stored inside dropdown list (that are downloaded from db). Is there any way I can set the maximum length of that dropdown control? The problem is that when I expand drop down list I have a horizonal scrollbar because some values inside...

SQL Reporting - Local report - Dynamically Change the Height of an Image Control using a value From DB

Hi there all, Please can you help me out as Documentation on this is very Poor. I have a local report for an ASP.net Application. There is a Image on this report which i need to Control I need to set the Height and Width of the image with values from the Database. Please can someone out the Help me with this. Many Thanks, Niven So...

How do I show blank entries on a BIRT Table sub-group?

Hi, I am trying to create a table with two groups in a BIRT report. I first group by year, and then by a criteria in a second column. Let's say this criteria is one of [A, B, C, D]. If there doesn't exist a criteria for a year, the default in BIRT is for it to be blank. For example, if 2011 didn't have any B or D criteria, my report ...

Database Schema For Task Reporting

I have a task tracking application, which is very basic. It currently has a number of tasks and the progress is updated as the tasks get completed, from 0 to 100%. The problem is, this data is all very transient and I want to add reporting over the top of the tasks, so things like: Number of tasks added between two dates Number of tas...

Date Format in Reporing Services

Hi I need to convert this value usign expressions in reporting services From 20100804 to Day 04 , Month 08, Year 2010 Is this posible? Thanks ...

How to efficiently store ever changing datasets (search results) for periodic reports

Hi all. I am having trouble coming up with a good way to store a dataset that continually changes. I want to track and periodically report on the contents of specific websites. For example, for a certain website I want to keep track of all the PDF documents that are available. Then I want to report periodically (say, quarterly) on the n...

Report data is not displayed - WPF

Hi, I have just started to make report in wpf, but getting following error An error occurred during local report processing. The report definition for report 'Project Path' has not been specified. Could not nto fild file 'File Path' here is my code private void Window_Loaded(object sender, RoutedEventArgs e) { List<Model....

Adding Reporting Capabilities to MVC?

Background: I currently have a Web Forms, ASP.NET 3.5/C# application which I'm interested in converting to MVC 2. It's a relatively tiny app so the exercise shouldn't take too long. The two primary functions the appliction does is allow users to 1) view and enter their data - metrics 2) view output reports of this data aggreggated at ...

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? ...

How to create reports in Access via ADO When data is in SQL Server?

I have an Access 2003 project in which all data is stored in SQL Server 2008. I am using ADO to view/update data via forms that are completely unbound. For example, a form has several textboxes and combo boxes on it. When the form is loaded I use ADO to make a call to a stored procedure on SQL SQL, it returns a recordset and I populate t...

Microsoft Excel as end to end reporting solution for .Net applications

Is it possible that capabilities of Microsoft Excel be leveraged for offering an end-to-end professional quality reporting solution? Assuming we use processing capabilities on the server side and rendering capabilities on the client side, can such a combination be used to replace popular commercial reporting solutions? I will appreciat...

How to make a GOOD reporting Interface

Hi All, I have a ton of associated data revolving around a school, students, teachers, classes, locations, etc etc I am faced with a challenge put fourth by my client; they want to have reports on everything. This means they want the ability to cross reference data points every which way and i think i'm just short of writing a pretty...