I have created two reports in Access 2007 that are virtually identical except for the data source. In both of them I have set up conditional formatting on a field to make the font italic when Expression is [Status]="Holding" In one of the reports the conditional formatting is applied and in the other it isn't. I've even tried settin...
I have a conditional sum in my grouping =sum(iif(Fields!Letter.Value="Service",0,Fields!Mailed.Value)) I keep getting the #error on half the fields. There all numbers. In my proc im calling the fields that are erroring outare doing a calculation. I tried putting those into a subquery and calling and it errored out. Im not sure whe...
I'd like to create a dynamic reporting webpage using JSP. Basically it should contain the following parts: Filter: The user can specify the filter conditions and press a filter button. HTML-output: The result of the filter can be seen here. It's one large html page (or several if one page would be too large). It may contain links to ot...
I'm looking for reporting solution for .net, my company has used Crystal Reports XI (and its Server edition) and SQL Server Reporting Services for our previous projects. However we're going to develop a new product and we want a fast, easily deployed/managed assemblies,programmable report document object, and has runtime report designer....
Hi there, Im using Jasper Reports to generate a word (docx) document but I have a problem when I want to try to print the doc. The exporter messes up the margins of the page. Does anyone know how to prevent that from happening. I know how to set the margin in iReport, but it just makes the data generate further from the page borders, b...
Maybe not specific to reports but still... In my asp.net mvc web application there's a section for reports that show 5 columns of data that map almost directly to a table in the db. The problem is, in some cases, the length of that report may exceed 40,000 records (I know, nobody can really process 40,000 records of data but the report...
We're currently evaluating different Java reporting engines, and having a web-based ad-hoc report designer is a requirement. We don't need anything too fancy, but we need users to be able to define a report with columns X, grouped by Y, sorted by Z, etc... We've found that many of the open source tools do have graphical report designers...
BACKGROUND I'm writing a method that will (eventually) take as input a System.Data.DataTable and render it as an (simple,tabular) SSRS report into a Winform using the Microsoft's ReportViewer Control (http://www.gotreportviewer.com/) In order to do this I need to (1) dynamically create an RDL file based on the DataTable (2) load the RD...
I'm familiar with aggregating junit test results within a single build, but are there any tools that let you aggregate results across different builds? I'd like to discover which tests failed most frequently, though not necessarily continuously. ...
I would like to insert an image into this expession instead of True and False =IIf(Sum(Fields!cont.Value, "DataSet7")<>Sum(Fields!tot.Value, "DataSet7"), True,False) i would like to insert a red or green image to compare this two fields thanks to all who wants to help me ...
Hi, I am looking for an Open Source & Free Browser based Adhoc / End User Reporting Tool preferably based on Java (any other technologies are also welcome). I have researched on JasperServer Pro, BIRT & Pentaho. Even though these are open source & free, the end user/adhoc reporting components needs to be paid annual license fees which...
I started learning .net about 3 years ago. I have gone thru a boot camp during that time learning OO and various data access technologies such as NHibernate, Subsonic, LINQ TO SQL. didn't wanna try EF cause it hasn't reached version 3 :) As far as reporting goes, I have heard that many ORM'S fall flat on their face when it comes to rep...
Hi there. I want to write rdlc's row count to on page. How can i do that? Thanks ...
Has anyone got any recommendations for a reporting framework, where it is possible to export into a word document and have charts editable inside MS Word. By this I mean the user should be able to double click on the chart and customize it, add trend lines, labels etc.. So far I have evaluated BIRT and SQL Reporting Services, but as far...
On the application I am currently working on, we need a way for users to generate reports in Microsoft Word or Excel format (export and print). One of the requirement is that the users would create the report template using a Word or Excel template document. I've tried to google a reporting tool that uses word and excel templates for r...
I have successfully connected to DB2 database using db2jcc.jar and now facing another issue. When i create a dataset and preview it. BIRT viewer throws following error. Cannot get the decimal value from column: 1. Cannot get BigDecimal value in the result set. SQL error #1: [IBM][JDBC Driver] CLI0610E Invalid column number. SQLSTATE=S1...
looking for a good easy way to generate reports on data my application holds. rather than building it painfully by writing it all out and formatting it with /n 's etc is there an easier method? It could be into excel, or just a list... Maybe the only way is to do it like I was thinking... ...
What is the best way (most intuitive to users) or best practice for displaying the results of a divide by 0 error when doing reporting? Within the report, I capture this error, however, when displaying it on a human readable report; I am not sure how to note this. An example would be something like Weight / Revenue ratio. For a given...
Hi Guys! I want to create a 'google analytics' type application for the web - i.e. a web-based tool to do some reporting and graphing for my database. The problem is that the database is HUGE, so I can't do the queries in real time because they will take too long and the tool will be unresponsive. How can I use a cron job to help me...
I've been trying to use JasperReports to print in a resolution above 72dpi, with no success. I need to use some resolution above 72dpi because I'm going to print in those pre-formatted adhesive labels, which need a certain level of precision when setting the positions. But, as JasperReports can only use pixels, and AFAIK only supports t...