reporting

Sorting a Crystal Reports 2008 Cross-tab in two directions

I have a table that shows a list of doctors, facilities, and charges. I set up a Cross-tab Report in Crystal Reports 2008, putting the doctors on the rows, the facilities on the columns, and the sum of the charges (and a couple of related numbers) as the summary fields. When I did this same report in Excel, I had no trouble sorting by s...

Flexible reporting system with dynamically loaded assemblies

I want to build a flexible reporting system for my application. So far I only have a concept in my head and need some tips on implementation. I'm using Crystal Reports to render reports and I know how to load reports dynamically. Now, the idea is that every report will be packaged as a separate assembly (.dll). The reporting framework w...

Report in local mode - Multiple subreports.. Problem with hidden property

Hi We have a report (local mode) in our ASP.NET solution, which contains multiple subreports. The report has multiple parameters, for each subreport one parameter. These parameters are subreport1Hidden, subreport2Hidden, ... I bind these parameters to the Hidden value of the subreports. This works fine, but when I export to PDF the...

Freeform Reporting tool

I am looking for free form reporting tool. Free/open source is preferred. It should work without a data source and one should be able to print at any place on a page. I need this because I am using an age old but very fast semi RDBMS which does not support concept of Data Set, Data Source, etc. that as required by all reporting engin...

In WPF, can you bind a ListView (NOT DataGrid) to a Matrix (Cross-Tab) DataSet?

Is it possible in WPF to bind a ListView (NOT a DataGrid) to a Matrix (Cross-Tab) DataSet in which the columns are unknown beforehand? Using the Northwind database as an example: the simple query below will return a wellknown dataset which can easily be bound to a listview: SELECT Year(o.OrderDate) AS [Year], Month(o.OrderDate) AS [Mo...

In SQL Reporting Services, how to filter a dataset according to a parameter?

Hello, I've got an unfiltered dataset to deal with so as to generate a report (SQL Server 2005, btw). Let's say I've got a Name column, and I'd want to ad a parameter to my report, so as to select only the names containing some characters. Does one know how to deal with these filters? I tried with no luck this: =Fields!Name.Value ...

Dynamically generating RDLC - What stops me from using a StringBuilder for building the XML

Hi I'm building a Local Report. Because of some limitations of the Hidden property, I need to dynamically generate the report. I found some documentation here. The ReportViewer Control needs a stream. I don't really like the method that's used in the documentation. And building an XmlDocument isn't very readable imo. Is there some...

Scripts to documents (Matlab's publish functionality in python)

Matlab has this great tool called publish. This tool converts a regular matlab script with minimal formatting stuff into structured, nice looking reports (HTML, LateX, RTF). It is capable of handling graphics, mathematical formulae etc. Is there a similar tool for Python? ...

Mysql Daily Performance Reporting

I wish to create a daily report on how my mysql server perform on the day. But it seems like mysql only stores aggregate data since uptime. One way is to generate a report and then do a mysql restart (or do a FLUSH STATUS). Any other suggestions to do the same? ...

Creating a custom SSRS control

Is it possible to create a custom third party for Reporting Services? The Dundas chart controls are an example of this however I am unsure if support for these have been internally built into SSRS.. ...

BIRT: Java - eventhandler, loaction of the files

Hello! I want to implement eventhandling for my reports via java-classes... where do i have to put the files? And do i need .class-files or .jar-files? BIRT 2.1.3, RCP - Designer ...

Best way to represent format for presentation of cells in a grid?

I am building a dynamic reporting feature for a client. They want to create new stored procedures, and have them correspond to new reports. We are using T-SQL and each cell in a grid/report can have its own formatting and/or functionality. I'm looking for a format specification to identify presentation, color and conditionals for data.....

Comments in SSRS Report Expressions

I'm using some complicated expressions in Reporting Services to control the value, format etc of data in a report (see MSDN). Is it possible to insert code comments into these expressions, and if so, what is the syntax? By code comments I mean something like: // single line comment /* or multi line comment */ ...

How do I architect and implement self-serve custom reporting?

What type of architecture, design and software would one need to provide something similar to the excellent custom report functionality provided by google analytics. To be more specific we want to user to be able to specify dimensions and metrics from a list and generate a report. Do we need a data warehouse? Do we need OLAP? Would ...

SQLite reports on iPhone SDK

What is the preferred method of creating simple reports on the iPhone-SDK platform? I'm thinking that ideally I could create PDFs and display them, is this feasible? Are there some built-in facilities, some available libraries? ...

Active Report, IIS Problem

Hi everyone, I am using ASP.NET mvc, and DataDynamic ctiver Reports for .NET 3.0 as my reporting engine. I have designed my reports and it warks fine on Visual Studio Development Server. But when I deploy it on my IIS (5.1 on Winxp SP2), I have propblems with AdobeAcrobat reports viewer and chart reports. IIS returns an error: [NotSu...

Visual Studio 2008 SP1 Not allowing to add website datasources

Hi all. I have a project with two reports (master.rdlc & detail.rdlc) wich both uses datasets to fill data. So far so good. They work ok, or used to work ok. For some reason, they lost the references to the datasets and the datasets are not showing in the Website Data Sources window so I'm unable to work with them. Also in the window W...

Best UI control to create expandable report in ASP.NET?

I have a SQL Server table full of training course progress. I want to make a report. The report is to be a list of users where each row shows their name, completion status, and percentages. They are to be able to expand each row to show sub-rows which elaborate with section by section detailed stats. What is the best UI control to use in...

Reporting Services paragraf

How to add paragraf to Microsoft Reporting textbox? When i put empty chars, they are not rendered, i try with Functions Space, LSet... VbTab.... For example i want This is text But i get This is text Thanks in advance. ...

SSRS - Producing a report that is not dynamic in size

I want to build a report that is completely static in size and shape. I'm attempting to mimic a hand-entered report that someone in my organization has been building from a word doc for years. The critical piece appears to be fixing the number of rows that are produced in the various Table grids that fill the page. I would like them t...