Jump to content
Changes to the Jaspersoft community edition download ×

Enumerating results

2005 IR Help

Recommended Posts

By: Seanigan - seanigan

Enumerating results

2004-06-02 08:48

In jasper is there an easy way to enumerate the rows I get back from my query string?


I tried to do this via sql like so, but the query did not work in Jasper. Can I use more than one query in the query string?


DROP TABLE #temp_table;

SELECT Identity(int, 1, 1) as line_number,fname, lname FROM employee where employee_number = $P{EMPLOYEE_NUMBER}

select * from #temp_table;





By: Lucian Comanescu - lucicom

RE: Enumerating results

2004-06-02 23:40



No, query (as String) is 0 or 1 (dtd), but you can:

1. Implement your own JRDataSource and you can execute any number of sql you wish to

2. Move the above 3 queries in a stored procedure and specifiy the call procedure as query string.


Hope it helps,


Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...