reporting

Enterprise Reporting Solutions

Hello everyone, What options are there in the industry for enterprise reporting? I'm currently using SSRS 2005, and know that there is another version coming out with the new release of MSSQL. But, it seems like it might also be a good time to investigate the market to see what else is out there. What have you encountered? Do you li...

SQL query to compare product sales by month

I have a Monthly Status database view I need to build a report based on. The data in the view looks something like this: Category | Revenue | Yearh | Month Bikes 10 000 2008 1 Bikes 12 000 2008 2 Bikes 12 000 2008 3 Bikes 15 000 2008 1 Bikes 11 000 2007 ...

What is your reporting tool of choice?

Every project invariably needs some type of reporting functionality. From a foreach loop in your language of choice to a full blow BI platform. To get the job done what tools, widgets, platforms has the group used with success, frustration and failure? ...

Best way to perform dynamic subquery in MS Reporting Services?

I'm new to SQL Server Reporting Services, and was wondering the best way to do the following: Query to get a list of popular IDs Subquery on each item to get properties from another table Ideally, the final report columns would look like this: [ID] [property1] [property2] [Select COUNT(*) FROM AnotherTable WHERE ForeignID=ID] There...

How do you track your hours?

Every programming job I've had has required me to track my hours, entering them into a system once a week. I've never been good at it. For the past few years, I've been running Timesnapper* on all my machines, and on the night before hours were checked I'd slog through the records and painstakingly enter the hours in. The alternative, o...

In Exchange (2003) how do I list the forms used in the public folder tree ?

Does anyone have a script or can anyone point me in the right direction to query an Exchange (2003) public folder tree to determine all the forms being used ? I need an output of form object/display name and count for each form type in each folder. ...

MS Access Reporting - can it be pretty?

I am working on a project converting a "spreadsheet application" to a database solution. A macro was written that takes screen shots of each page and pastes them into a PowerPoint presentation. Because of the nice formatting options in Excel, the presentation looks very pretty. The problem I'm having is that I haven't ever seen an Acc...

File format for generating dynamic reports in applications

We generate dynamic reports in all of our business web applications written for .Net and J2EE. On the server side we use ActiveReports.Net and JasperReports to generate the reports. We then export them to PDF to send down to the browser. Our clients all use Adobe Reader. We have endless problems with the different versions of Adobe ...

Employee Web Usage From Proxy Logs

I need to find/create an application that will create employee web usage reports from HTTP proxy logs. Does anyone know of a good product that will do this? @Joe Liversedge - Good point. I don't have to worry about this, however, as I am the only person in my company with the know-how to pull off an SSH tunnel. ...

What .NET reporting tools are best for dynamic report generation?

Perhaps I need to define "dynamic generation". By this I mean using graphics primitives to draw on the page (such as DrawText or DrawLine, etc) This is what System.Drawing.Printing provides. I often need to create forms and reports for Windows applications that either require dynamic generation or where I need control over the formattin...

Display blanks instead of 0 or 0.0 in a BIRT report

When using an aggregate control in some reports you would prefer to see a blank field instead of 0. There does not appear to be a way to do this automatically. Does anyone have a way that this can be done. Note, you want to maintain the '0' value for the field in cases when you export, but you want to show a blank when rendering to PD...

Can we have customized "Date Prompt" in cognos8?

Hi, I am working with Cognos8 Report Studio. In my report there are two date prompts, (1) START date, (2) END date. Users can select two different dates or two same dates. But the report has valid data only for last business date of each month. For example, if Jan 31 is Sunday, valid data is available only for Jan 29 which is Friday(las...

report generation on php?

one of the most frequent requests i get is to create XY report for YZ App. This apps are normally built on php, so far i have manually created most of this reports, and while I enjoy the freedom of building it like i want, it usually becomes pretty tedious to calculate subtotals,averages, exporting to different formats etc. What solutio...

SSRS 2005 Matrix and border styles when exporting to XLS

The Matrix in SSRS (SQL Server Reporting Services 2005) seems to have issues with certain the border styles when exporting to XLS (but not PDF or web view; maybe other formats, not sure?). For example: Create a matrix and set the Matrix border style to Black Solid 1px, but all 4 of the cells to have a border style of Black None 1px. Whe...

Reporting with db4o

I've used db4o with much success on many projects in the past. Over time it seems to have evolved greatly, and with modern trends like LINQ on everyone's tongue it has peaked my interest again, especially now that I know that it is starting to support transparent activation and persistence which intrigue me quite a bit, but a friend pose...

Best Reporting application

Desinging web application and for reporting iam using crystal reports.sometimes the crystal reports gives runtimes error. What can i do to make my report faster. Retrieving around 1MB of data. It is the month end sales report. what is the best method to solve this issue. ...

Initialization Troubles with BIRT Runtime Engine API

Hi, I'm new to BIRT and I'm trying to make the Reprt engine running. I'm using the code snippets provided in http://www.eclipse.org/birt/phoenix/deploy/reportEngineAPI.php But I have a strange exception: java.lang.AssertionError at org.eclipse.birt.core.framework.Platform.startup(Platform.java:86) and nothing in the log file. May...

Working with .qr2 reports in .NET?

We use an ERP that has a bunch of reports in QuickReport format (.qr2). From what I could search, Quickreports has an interface for Delphi but not for .NET. Anyone know if there's a (preferably free/OSS) solution for converting .qr2 reports to something I could work with in C#? Or a component for reading these reports directly? ...

Looking for a tutorial on SQL Server Reporting Services (SSRS)

where can i find the best tutorial about MS SQL server reporting services.. ...

Crystal Reports and LINQ

Has anyone figured out how to use Crystal Reports with Linq to SQL? ...