reporting

Dot matrix fast printing with precise layout in Java

I'd like to know what practical way of constructing reports for EPSON Dot Matrix printers exists in Java. At this time, I'm having the LX300+II model to play with. I know that there are basically two ways of using this printer: As a typewriter, outputting directly raw ASCII data to the parallel port Graphical printing, with graphical ...

"Unit testing" a report

How would you "unit test" a report created by some report engine like Crystal Reports or SQL Server Reporting Services? ...

SQL Query make columns results into rows

I'm using reporting services to make a report graph. However my data looks like this: Table1 C01 C02 C03 C04 1 2 3 4 I need to do a sql query to return data that looks like this: Any_Col_name 1 2 3 4 I'm using MS Reporting Services with a Oracle DB. I cannot restructure the table. ...

Build report from tortoise svn client

I am looking for a solution to build release notes from svn. What I want is a command line utility or something which can get me all the comments of checked in files from a given date. Thanks ...

JavaScript - SQL Reporting Services

Can We insert javascript in a report rendered by sql reporting services? eg:- when mouse over happens over a cell i would like to open a div as in case of ajax modal popup control usage. ...

BIRT: Alternating row Color in a table group...

Hi! :-) Has anybody an idea of how the highlighting condition has to look like, to create alternating rows in groups? I want the every row with an even number of a table group (not of the whole table) to have a different color. Thanks in advance! :-) Patrick P.S.: I'm using BIRT 2.1.3 ...

What's a good way to generate availability reports for a web application?

I manage a number of web applications and am being asked to generate statistics around their availability based on length and time of day of any downtime. Does anyone know of any tools and/or services which are available to facilitate this? The applications are all java servlet applications with an oracle database on the back end. Acces...

Building a SSRS 2008 off an EDM

Can someone please outline the process of building a SQL Server Reporting Services 2008 report based on a ADO.Net Entity Framework Entity Data Model? If you know of any example, please point me to it. Thank you! ...

How can I represent data in a WYSIWYG format without using Crystal Reports?

I am searching a way to print data in tablesw with text and images, in a WYSIWYG, nice and good looking way. So far I have: header + images + web-like decorations + arabic labels & values + data in dataset (xml) + I need to give a way for buisness analysts to change the output layout. Crystal Report does all of this. But I don't like C...

BIRT Formating Legend of a bar chart

I have a small problem, a BIRT report I designed uses a bar chart. Now I want to increase the space between colored box and the text in the legend. Is that possible? (I'm using BIRT 2.1.3) EDIT: I forgot to mention I am using BIRT 2.1.3 with the RCP Designer. ...

Can any one recommend a vector graphics engine for reporting purposes?

Need to develop a .NET solution to graphically represent seats in sections, plotted in a stadium layout view, and output as a report... the seats would have different colours displaying sales status... ...

How do I put a StockSeries in front of a BarSeries on a combination chart in BIRT?

Hi all, Consider the below source code where I create a combination chart with a BarSeries and a StockSeries. The StockSeries generates three identical Candle-stick Stock figures with a box from values 12 to 14 and low and high values 10 and 16. The BarSeries generate three bar figures with heights 11, 13 and 15. public class StockBar...

Eclipse BIRT: Problem with number of rows in a dataset

Hello!:-) My new Problem is the following: An sql-query to a database (DB2) returns 1500 rows but BIRT shows me only 500 in the dataset-editior. To count them i used a computed column (Integer) with the following logic: Total.count(row["VPK"]) I'm using the RCP-Designer (BIRT 2.1.3). How can i get the other rows as well? Patrick ...

Set up SQL Server 2005 Reporting DB from SQL Server 2000

We recently moved from a simple DB recovery model (with daily full database dumps) on our SQL Server 2000 Standard database to full recovery -- combined with weekly full database backups, daily incremental, and transaction dumps every 10 minutes. Our previous reporting DB instance (SQL Server 2005) was built from the daily backups which...

Practical limit to number of SQL Server logins?

Working with an application that needs to provide row and column level security for user reports. The logic for the row filtering an column masking is in place, but there are still decisions to be made about identifying users at report execution time. The application uses a single SQL Server login to authenticate, as all rights are data...

Reporting vs. Coding - thoughts?

Recently I had a project in which I had to get some data from particular software system to a portlet. The software used a database, and I spent a fair bit of time modeling the data I wanted and then creating a web service so that my portlet could grab the information. Then it suddenly struck me that I was wasting my time. I grabbed B...

Formatting Timespans within Business Objects Desktop Intelligence (BO Deski)

Can anyone tell me how to format a given number of seconds (for example 16742 seconds) in a human readable form (for example 1d 5h 2m 13s) using a BO field formula or from within a T-SQL SELECT statement (where the Duration as Seconds is from a SUM aggregate)? ...

Report based on arbitrary data source (quantity and names of columns may change)

I need to export data of all columns (including technical like GUIDs for foreign keys) of an arbitrary table from a given database. I wanted to use LocalReport class as suggested here, but I can't think of how to set up the report for an arbitrary data source (even quantity and names of columns may change). Any help would be appreciate...

RDLC Medium Trust

Does anyone know of a free (for a non-profit group) RDLC reporting tool that will work under medium trust in IIS 7? ...

What is the best way to store usage reports over time?

Hello, I currently have a few server reports that return usage statistics whenever run. The data is collected from several different sources (mostly log files), so they're not in a database to begin with. The returned data are simple lists, for example, detailing how much disk space a user is using (user => space) average percent memor...