reports

Is there a ridiculously easy report plugin for rails?

It's getting old rewriting report code for Rails applications. Ya have to create the query, the routes, the action, and the view...(yes, I'm lazy) Is there anything out there that would create a full report in even fewer steps? Here's what I imagine would be ideal: You have a Report record that has a name, query code (in Ruby or SQL),...

Access Reports Looking up field value based on another field value

I have a group in my report that groups by the MachineID field and displays the MachineID in the header by a textbox with this Control Source:=[MachineID]. In another table I have an index of MachineID and MachineName. Is there a way to make the textbox get and display the MachineName from the other table instead of just the MachineID fr...

SUM still includes suppressed values

I've got a report that includes some limited duplicate information, there are multiple dates possible, but I want the dollar values to display on only the first item. IE: Item 1 - Aug 3, 2010 - Cost $1000 Item 1 - Aug 4, 2010 - (Cost suppressed) Item 2 - Aug 3, 2010 - $100 Item 3 - Aug 4, 2010 - $200 When this is summed, it ...

Should I use stored procedures for reports in SQL Reporting Services

Hello, When I write report for SQL Reporting Services I put SQL-script inside my report (rdl). When I run this script in SQL Management Studio it takes about 1 second, but report are generated very long time (Sometimes report throws exception about timeout). Should I write stored procedure and use it in report? Will it be faster? And...

publish rdlc files in .net web app?

We have a web site that uses rdlc files to show some reports, but when I publish the website within visual studio these files are not included. how do I add these files to the publication? is copying these rdlc files to the publication secure? thanks ...

Windows Report (rdlc) How to filter a grouping by the count of the child items?

I have a simple report, one field as row, one field as value. The data is grouped by the row field. I want to display only the rows where there are more than 1 value items (thus hiding where there is only 1 value item). Anyone knows how to do it? If more details are needed ask away ...

Report designer and viewer of custom data in .NET

Hello. I've custom data list, for example list of persons: -name -surname -photo I'd like to give my customers opprtunity to design, how would they like to see this data in exported document: name | surname | photo or name surname photo etc. Do you know any easy to use tools that could help? It would be wonderful if they would...

How do I add a select time parameter to reporting services

I need to create a report that allows the user to give date and time range to report. I can set up the startdate and enddate but I can't seem to figure out how to add starttime and endtime. This is a report where they want to view what was processed between a certain date and time. ...

Mimicking Spreadsheet Style in a MS-Access Report

I've been tasked with creating a report in MS-Access that looks exactly like a spreadsheet that a vendor supplies to us for my company to fill in. The number of records per page is about 40 and there are usually 3-6 pages that need to be prepared. Each month there is a new report sent out and I just got finished writing it all in manual...

Oracle Reports 10g - Graph

I have build a stacked graph using oracle Reports 10g. I have 4 series in the graph, and i want to display marker text(data label in other words) for all except one series. i have tried with exceptional raiser but it is not worked out. any body have idea about it??? ...

repeat break columns in a single query group report oracle

From the oracle reports tutorial, http://download.oracle.com/docs/html/B10602_01/orbr_grpl_single.htm I have a requirement that is similar to the above report but would have the department id column to repeat each time instead of just once as above. So I tried following the steps and then moved the repeating frame of non-grouped fields...

Drilldown Reports

Help I am attempting to create a drill down report using report server and Visual Studio 2005. I have been able to create a tree structure, but the original report looks like it opened a new report. (Crystal Report) This was done by the report hiding all other data apart from the drilled data and the data title. I can’t seem to be abl...

Access Report Size Uncontrollable!!!

Hi all, I have a report in Access 2007 that is opened by pressing a button on a form. This button triggers an OpenReport macro, where the report is told to open in Print Preview view, and Dialog window mode. How can I manually set the size of this window, along with the opening zoom level? In the properties of the report, both AutoResi...

Identify which queries an Access 1997 report is using to generate?

I am updating an Microsoft Access 1997 mdb. I want to find out how one of the reports are generated and I am not sure which queries the program uses to generate the report. I am only able to access the design and preview mode or the report. Is there an easy way to identify how the report is generated? Specifically which queries, tables...

Nested map<K,V>'s instead of List< Object[] > as return values. Any problems?

The situation occurs when getting some data from the database to compose a report that is grouped by various fields. For example, grouped by month, then type and then actual vs prediction. The database query returns simply a List< Object[] >. But it is boring to directly render it as an HTML table. What I do is to group the data inside a...

Java Server question: Cheap/Mid-Level Creating report documents with designer (PDF/HTML)

What are some ways to create PDF reports in a Java server environment without having to use Java code to do so. Or maybe minimal Java code? We have used iText and various htmltopdf solutions. Those work, but they take a lot of Java code create the documents and you have to code the positioning of all the elements? Is there a solutio...

What is free-ware (or just cheaper) analog to Tableau (ad-hoc BI)?

I need an ability to connect to different sources (minimum MS SQL and Excel) and EASILY create ad-hoq reports, on the fly. What is the solution for this, apart from Tableau (http://www.tableausoftware.com/)? Thanks in advance. ...

oracle reports repeating a table

I have a requirement where multiple tables need to be generated in oracle reports. I tried inserting an report block within a repeating frame, but doing so makes the application hang. Is there any valid way to do this? Thanks in advance. ...

Adding Reporting Capabilities to MVC?

Background: I currently have a Web Forms, ASP.NET 3.5/C# application which I'm interested in converting to MVC 2. It's a relatively tiny app so the exercise shouldn't take too long. The two primary functions the appliction does is allow users to 1) view and enter their data - metrics 2) view output reports of this data aggreggated at ...

Rave Reports and Intraweb ?

Anyone have an example of using Rave Reports (PDF output) and Intraweb ? (or even WebBroker) in delphi ? I'm assuming you write to a memory stream and then output this to the browser. Any help on Rave Reports/Memory Streams and Intraweb or Webbroker appreciated. ...