Win a copy of Escape Velocity: Better Metrics for Agile Teams this week in the Agile and Other Processes forum!

Mainur Rahman

+ Follow
since Aug 23, 2006
Cows and Likes
Total received
In last 30 days
Total given
Total received
Received in last 30 days
Total given
Given in last 30 days
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Mainur Rahman

I am using iReport 1.5.2
My table is as like
Date warehouse delivery No

I want Output will be as like
Date WH10WH20WH30total delivery

I can�t use crosstab in iReport
Pls send me the steps of crosstab�� which I can create this report
what should I do???
Please help��
Mainur rahman
What Is JDBC?
Working with leaders in the database field, JavaSoft developed a single API for database access--JDBC. As part of this process, they kept three main goals in mind:

JDBC should be an SQL-level API.

JDBC should capitalize on the experience of existing database APIs.

JDBC should be simple.

An SQL-level API means that JDBC allows us to construct SQL statements and embed them inside Java API calls. In short, you are basically using SQL. But JDBC lets you smoothly translate between the world of the database and the world of the Java application. Your results from the database, for instance, are returned as Java variables, and access problems get thrown as exceptions. Later on in the book, we go a step further and talk about how we can completely hide the existence of the database from a Java application using a database class library.

Because of the confusion caused by the proliferation of proprietary database access APIs, the idea of a universal database access API to solve this problem is not a new one. In fact, JavaSoft drew upon the successful aspects of one such API, Open DataBase Connectivity (ODBC). ODBC was developed to create a single standard for database access in the Windows environment. Although the industry has accepted ODBC as the primary means of talking to databases in Windows, it does not translate well into the Java world. First of all, ODBC is a C API that requires intermediate APIs for other languages. But even for C developers, ODBC has suffered from an overly complex design that has made its transition outside of the controlled Windows environment a failure. ODBC's complexity arises from the fact that complex, uncommon tasks are wrapped up in the API with its simpler and more common functionality. In other words, in order for you to understand a little of ODBC, you have to understand a lot.

In addition to ODBC, JDBC is heavily influenced by existing database programming APIs such as X/OPEN SQL Call Level Interface. JavaSoft wanted to re-use the key abstractions from these APIs, which would ease acceptance by database vendors and capitalize on the existing knowledge capital of ODBC and SQL CLI developers. In addition, JavaSoft also realized that deriving an API from existing ones can provide quick development of solutions for database engines that support the old protocols. Specifically, JavaSoft worked in parallel with Intersolv to create an ODBC bridge that maps JDBC calls to ODBC calls, thus giving Java applications access to any database management system (DBMS) that supports ODBC.

JDBC attempts to remain as simple as possible while providing developers with maximum flexibility. A key criterion employed by JavaSoft is simply asking whether database access applications read well. The simple and common tasks use simple interfaces, while more uncommon or bizarre tasks are enabled through extra interfaces. For example, three interfaces handle a vast majority of database access. JDBC nevertheless provides several other interfaces for handling more complex and unusual tasks.

15 years ago
New iReport Group


Here created new iReport group.
Join here for any iReport solution�.

Group Email Addresses

Discussion and Conversation will give the appropriate solution.


Mainur Rahman.
iReport group
16 years ago
when i create subreport using iReport 1.2.1 version
the following error occuring

Error filling print...
net.sf.jasperreports.engine.JRException: Could not load object from
location : D:/subb.jasper
at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate
at net.sf.jasperreports.engine.fill.JRFillBand.evaluate
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill
at net.sf.jasperreports.engine.fill.JRFiller.fillReport
at net.sf.jasperreports.engine.JasperFillManager.fillReport
at net.sf.jasperreports.engine.JasperFillManager.fillReport
at Source)
Print not filled. Try to use an EmptyDataSource...!


pls help me with proper instructions
I m using iReport 1.2.1 version
I want to create a simple crosstab� as like the follows

My table is as like

Date warehouse (WH) Delivery No
7/7/2006 10 10-1
7/7/2006 20 20-1
7/7/2006 20 20-2
7/7/2006 30 30-1
8/7/2006 10 10-2
8/7/2006 10 10-3
11/7/2006 30 30-2
11/7/2006 20 20-3

I want to make a report using crosstab in iReport�..

I want report will be as like

Date WH10 WH20 WH30 total delivery
7/7/2006 1 2 1 4
8/7/2006 2 0 0 2
11/7/2006 0 1 1 2

my questions are:

01. what should I do???
02. Can I use sub report in the details field of the crosstab?
03. How I count/sum the wh in the crosstab? (cause the WH is arrange as row in my database table )

I want step by step instructions
I have not clear concepts about crosstab, but I know crosstab will give the solution of this problem

Please help��

Mainur rahman
Data Source problem:

I am using iReport1.2.1
My questions are---

01.What is the basic concept of data source?
02.How can I create a data source in iReport?

Pls help me by proper instructions.