473,395 Members | 1,504 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

calling the stored procedure in Jasper Reports

Hi,
I am calling a stored procedure in my Jasper Reports, but it is giving me an error. Would it possible to execute stored procedures in the field wizard when you create the Jasper Report using the Jasper Assistant in Eclipse?

My code is

exec sp_ACCUM_MILEAGE_REPORT $P({veh_no} , $P {veh_no_rebuild_id} , $P { from_date } , $P { to_date }

Thanks in advance
Oct 19 '07 #1
2 13234
r035198x
13,262 8TB
Hi,
I am calling a stored procedure in my Jasper Reports, but it is giving me an error. Would it possible to execute stored procedures in the field wizard when you create the Jasper Report using the Jasper Assistant in Eclipse?

My code is

exec sp_ACCUM_MILEAGE_REPORT $P({veh_no} , $P {veh_no_rebuild_id} , $P { from_date } , $P { to_date }

Thanks in advance
Perhaps if you post the error message that you got ...
Nov 1 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: MD | last post by:
I am trying to create a dynamic SQL statement to create a view. I have a stored procedure, which based on the parameters passed calls different stored procedures. Each of this sub stored procedure...
5
by: Zlatko Matić | last post by:
Hello. How can I call some functions on MSDE when working in .mdb ? Especially in-line functions which are similar to stored procedures. How can I use MSDE in-line functions as recordsource for...
3
by: Lord0 | last post by:
Hi there, First of all I apologise for being a PHP noob. Is there a PHP equivalent of Java's Jasper Reports? http://jasperforge.org/sf/projects/jasperreports Basically Jasper is a bunch...
1
by: gsuns82 | last post by:
Hi all, I am new to Jasper reports concept,pls let me the following things. 1.Get me an url where i can download a sample application for jasper reporting. 2. I cant able to get samples from"...
0
by: rakeshc | last post by:
Hi, I am a new guy in jasper and iReport. I could create a report and subreport successfully with iReport. while running through iReport, it will ask for parameters and after supplying them,...
1
by: madhuparimi | last post by:
I am working on jasper reports.First i want to know how to generate a ireport using stored procedure. Can u please help me out and tell me how to generate an ireport using stored procedure
2
by: mkotula | last post by:
Hi, Brand new to jasper and IReport with Oracle. Was able to load and connect IReport to Oracle DB and created my first reports. Unable to connect Jasper to the DB nor import my IReport...
0
by: Sundhas | last post by:
Hey, i want to Use Dynamic japser to create reports of my database i.e MYSQL. Plus, i want to know that can i send attirbutes to dynamic jasper which a user is going to select from the front end...
0
by: prileep | last post by:
Hi, I am trying to invoke JASPER Reports designed using iReport 3.7.0. JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, param, conn); I am getting following error, root...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.