reporting

Whats a good API for generating reports for a java web application?

I have a J2EE application that has a lot of reports, the situation now is the following: Report filters' values are sent to the application over DWR mainly, the data are retrieved from Oracle DB throw DB procedures and returned back to the client. However, some customization is required every now and then (new data filters, columns, or...

Ruby on Rails: What Reporting and/or Charting Tools Are Available?

I'm just starting out with Ruby/Rails and am wondering what Rails developers use to provide reports and/or charts on Rails sites. In ASP.NET I use the tools from DevExpress but I don't know enough about the Rails ecosystem to know what is available. Any insight would be appreciated. ...

Cognos reports showing no data from url

I can run all my reports from report studio just fine. So its not a question of query or data or even report specs. When i call them from URL i am getting no data in the report. There obviously should be data. We had just upgraded from 8.2 to 8.3 and it is not all the reports... only a select few. This is serious problem since our u...

How to merge Cognos Reports

We currently have a manual process when we update reports on live.. from our test environment.... to manually merge changes into our new development environment. This is tedious. Is there a way to automatically merge two version of the same report so both changes take? Is it possible to merge the xml report specs of the two? without ...

SQL Server Metrics

Hello, We are using SQL Server as our database server. We've built a consumer product and are looking to build a dashboard that has metrics on our user base. We're a team of two and were wondering if SSAS or if TSQL was the way to go to get metrics. Caveats We're not up to speed on SSAS so there would be a learning curve The data n...

schema-less data warehouse and reporting

We have a system that generates many events as the result of a phone call/web request/sms/email etc, each of these events need to be able to be stored and be available for reporting (for MI/BI etc) on, each of these events have many variables and does not fit any one specific scheme. The structure of the event document is a key-value...

Passing parameters from SL Reporting to Reporting Services

I am trying to figure out how to pass some of the options from Microsoft SL Reporting to my report in SQL Reporting Services. I need to use them as parameters for my SQL statement in the report and can not figure out how to accomplish the connection between the two programs. During runtime, SL Reporting creates the RptRuntime table that...

SQL Server 2005 Reporting Services Matrix Total Data Highlighting

I have created a SQL Server 2005 matrix with a total column. I want to be able to change the colors of the totals only so they stand out from the rest of the data. I can change the color of the "total" label, but not the actual data. Can anyone give me a clue of how to do this? ...

SOAP call with query on result (SSRS, Sharepoint)

Hi! I created a report in VS using a shared data source which is connected to a sharepoint list. In the report I created a dataset with a SOAP call to the data source so I get the result from the sharepoint list in a table. this is the soap call <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems&lt;/SoapActi...

Passing parameter via url to sql server reporting service

I'm trying to pass a parameter via the url to SSRS and it appears not to work! I'm trying to pass a userId (string) via the url which will be passed to the database and used by the query. base url: http://blah/Reports/Pages/Report.aspx?ItemPath=MyReport tried this but it doesn't work: http://blah/Reports/Pages/Report.aspx?ItemPath=MyR...

Selenium Ruby Reporting

I'm trying to set the environment for testing using Selenium and selenium-client gem. I prefer unit test style over RSpec style of tests. Do I have to build my own system for reporting then? How can I add exception handling without having begin-rescue-end in each test? Is there any way to do that using mixins? ...

Django Reporting Options

I want to create a new "Business" application using the Django framework. Any suggestions as to what I can use as a reporting framework? The application will need to generate reports on various business entities including summaries, totals, grouping, etc. Basically, is there a Crystal reports-like equivalent for Django/Python? ...

Right reporting solution in a .Net environment

I have a reporting requirement in my web application for which I am looking for off the shelf solution. I don't have any experience of reporting softwares so thought of checking with SO community if anyone have any idea of reporting solution which fits my requirements. The application will be developed in .Net and apart from other funct...

Crystal reports or Eclipse BIRT

I'm looking at a reporting solution for an existing application. Currently it has code for reporting. Users have expressed interest in Crystal reports. Eclipse BIRT seems to do the same thing(s) and cost nothing. Reports will be BIG ( tens of thousands of pages) and cover about a dozen report sets. Tables, graphs and charts. Large g...

How do I get to choose year and month along with date in SSRS Date Picker (Calendar) Control?

I see the date picker (calendar) control on my report giving out an option to pick dates as parameters for a report. However if the user want to select an older date (01/01/2000) through calendar, he/she has to scroll back month at a time all the way to Jan 2000 month to select 1st date. Is there a way to incorporate year and month pi...

Reporting for multi-tenant web app

We have a multi-tenant web-based Enterprise application using Hibernate over MySQL. We use Jasper Reports for any reports that our customers require, but now we also need to offer ad-hoc reporting so that Users can run their own queries. How have others accomplished this? I am thinking that I can either: Provide a full export in exce...

hosting asp.net pages within the app

The goal is to generate some html reports and html emails using templates hosted within the app perhaps using cassini so the report files will be saved in app_home\Report\Templates*.MyReport file The app would allow a report (.aspx) page to be selected, loads it using cassini/asp.net hosting api processing some custom markup to popul...

sql reporting services problem with subreport in 3rd level group

i'm getting an error when trying to put a subreport inside a inside a 3rd level group of a table or list (it doesn't matter, same error) i have put a clean subreport withouth datasource without parameters, just a textbox when i put that subreport inside 1st or 2nd level group it's ok, when i put it inside a 3rd level group(or higher) i ...

Empty report when using VS2008 report wizard and stored procedure

I'm using VS2008, writing a C# .NET app. I have an SQL Server 2005 database server with a database which contains several stored procedures. I want to show the stored procedure data in a report. So, as a test I created a brand new VS2008 C# project based on the "Reporting -> Reports Application" project type. I went through the wizard,...

sql reporting services formats ( datetime, numbers ...

i put the format of a textbox using expression like Format(Fields!name.Value, "dd/MM/yyyy") can i somehow set a global format for datetime and currency/floats without having the need to set it for each textbox in part ...