reporting

Time slicing in Oracle/SQL

Hello, I have a large-ish Oracle table containing rows representing units of work, with columns for start time and end time in addition to other meta-data. I need to generate usage graphs from this data, given some arbitrary filtering criteria and a reporting time period. E.g., show me a graph of all of Alice's jobs for the 24-hour pe...

asp.net - Generate Powerpoint file on the fly

I have a client of my web based application who heavily uses the data from our system for powerpoint presentations. We currently allow data to export in more traditional file types...PDF, CSV, HTML, and a few others. Powerpoint doesn't seem to be really automated. Is there a way, on the ASP.NET server side, to automate the creation an...

Database Abstraction in a Reporting Application

In a reporting application, Is it possible to abstract reporting logic and the database schema details? I have a Reporting Services application with a reasonably complex reporting logic, I am trying to migrate the application to some other databases. (Databases that are built for the same purpose but developed by different software-hou...

What is the best solution to do Reporting on Object data for .NET ?

Hi, Our projects are using objects as the data source to reports. Our business layer is returning single objects or IEnumerable. Our reports (quite complex) need to display value-type properties of the object, and its related objects. Typical case would be, from a List, display a master report with category data, then a subreport with ...

Sum IIF Expression

Im trying to sum an expression in visual studio and just keep getting an #error but not sure why as this si the first time i have tried to sum an expression, only ever done it on a single field before. Any Suggestions!!! =IIf(Fields!STATUS.value = "Completed" AND Fields!DONOTINVOICE.value = True, Fields!ORDERCOST.Value, "") ...

Best Update Method for MySQL DB

I have read through the solutions to similar problems, but they all seem to involve scripts and extra tools. I'm hoping my problem simple enough to avoid that. So the user uploads a csv of next week's data. It gets inserted into the DB, no problem. BUT an hour later he gets feedback from everyone, and must make updates accordingly. H...

Can PowerShell script out SQL Server Reporting Services RDL files?

Is it possible to use PowerShell to script out SQL Server Reporting Services rdl files in SQL Server 2008? If so, can someone provide a code example of doing this? This would be a useful replacement for using a 3rd party tool to script out RDL files created by business users outside of my Business Intelligence department. CLARIFICATIO...

XY-Scatter Chart In SSRS Won't Display Points

I'm a bit confused with this one. I have a Dataset with a BackupDate and a BackupTime as well as a BackupType. The BackupDate is comprised of 12 characters from the left of a datetime string within a table. The BackupTime is comprised of 8 characters from the right of that same datetime string. So for example: BackupDate would be 'D...

How to display loading graphics in Firefox in Microsoft Reporting Services

I am using MS reporting services and some of the reports are taking longer than it should. By default the report viewer displays a loading graphics in IE. However, this graphics is not visible in Firefox. It works fine in IE. How can I display the loading graphics in Firefox? Any help would be appreciated. Thanks in advance. Regards N...

Hosting a bare-bones XAML editor in my application?

In our application, we allow administrators of an install to design templates for name tags that are printed when they check-in from a kiosk (sort of like checking in for a flight at a kiosk and printing out a boarding pass). For example, the template might look something like this: [FirstName] [LastName] [Company] [PersonImage] [BarCo...

Best reporting engine for WPF without a database?

Does anyone know of a Reporting Engine for WPF? Most of the ones I could find are still for WinForms. I'm happy enough using a WinForms one in WPF with a WinForms host so long as the tool has a UserControl that can be embedded in a window. Also, I'm not using a database and all my data is in XML so the Reporting Engine needs to be able...

Grouping by a report item in SSRS 2005 - textbox - any workarounds?

Hi, I want to group by a report item, but that's not allowed. So I tried creating a parameter...not allowed as well. Tried referencing from footer...failed again. This is somewhat complicated. Let me explain: I have textbox22, it's value is: =Code.Calc_Factor(Fields!xx.Value, fields!yy.Value...) This is embedded VB code in the report ...

Business reporting with per-page print control

Does anyone know of a reporting tool that allows for controlling the print job on a page by page basis? Specifically, I need to be able to insert escape sequences to the printer. The closest I have found is ActiveReports. It provides an interface like this: SystemPrinter sp = new SystemPrinter(); sp.StartJob("jobname"); foreach(Pag...

ASP.NET output expense report in Excel

On this project I am working on right now, one of the newest feature requests is to output expense information which is stored into expense report that matches an Excel worksheet they already use for all of their expense reporting. I was curious if there was a way that I could take this excel worksheet (with all of its layout already d...

How do you handle reporting filters in ASP.NET MVC?

For a given report, the user will want to have multiple filtering options. This isn't bad when the options are enumerations, and other 'static' data types, however things can get silly fast when you need a select list that is populated by fields stored in a table in the backend. How do you handle this scenario? I find myself constantl...

LinqDataSource does not work with Microsoft.Reporting.LocalReport

I´m trying to generate a report using a LinqDataSource, placed on a aspx page, and a LocalReport. The code speaks for himself: //Creating report Microsoft.Reporting.WebForms.LocalReport report = new Microsoft.Reporting.WebForms.LocalReport(); report.ReportPath = Request.PhysicalApplicationPath + @"path\To\report...

Exception line numbers are messed-up on CCNET build reports

We are having an integration server (CruiseControl.NET) building and validating a couple of .NET 3.5 libraries. When some integration code fails, the exception is logged and appears in a custom report. Yet, the line numbers reported by the exception messages are messed-up - usually short from 50 / 100 lines below the place where the exc...

Feature differentiation: Rails / Django

Are there any important features in Rails or Django which do not exist in the other framework? Is there anything important missing - for an enterprise web app - in either one? This question is not intended to be argumentative - I am trying to make an informed technology decison for an upcoming project. Two of the concerns I ha...

Client side report printing from PHP web apps

I was looking for a solution for client side printing of reports and pre formatted forms from a PHP web based app. Note that these are not printing of HTML pages. Rather nicely aligned fixed formated Receipts, Order Forms, Ledger etc. Something that I have though of. Using PDF: Is there a simple one click way to print the report from c...

Is there a quick way to report database metadata in SQL Server 2005?

Are there any system stored procs to report the stats and metadata of a database itself in SQL Server 2005? What I need is a quick way to output a list of tables, the size of each table, the number of rows in each table and so on. Stored procs for individual tables and metadata would also be useful. Advice appreciated. ...