[#835] - DB Connection related to report

Issue moved from:
https://sourceforge.net/tracker/index.php?func=detail&aid=1472955&group_...

Consult the original issue for any attachments.

[ 1472955 ] DB Connection related to report

Submitted By: Javy Dreamer - javydreamercsw
Date Submitted: 2006-04-19 05:58
Last Updated By: javydreamercsw - Comment added
Date Last Updated: 2006-04-19 06:28
Number of Comments: 2
Number of Attachments: 0
Category: Interface Improvements (example)
Group: Next Release
Assigned To: Nobody/Anonymous
Priority: 5

Summary: (?)
DB Connection related to report

I've found that the reports can be only ran in one db at thhe same time. I think that a great feature will be the ability of doing queries from different databases. Like Report from db1 and sub report from db2.

My main interest of using iReport is getting data from different sources. Maybe making the database connection information PART of the report itself will fix that, maybe use that as a default variable.

Comments

Date: 2006-04-19 06:28
Sender: javydreamercsw
Logged In: YES
user_id=1270691

I'm not sure how to exactly do that. Where do I set the subreport connection expression? I've looked in properties.

"Where "connection name" is the name of the connection in iReport."

Does that means a variable named "connection name" in the report?

I'll appreciate any help there. Thanks in advance.

Date: 2006-04-19 06:03
Sender: gt78SourceForge.net SubscriberProject Admin
Logged In: YES
user_id=616744

You can do it now using an expression for the subreport connection expression like this:

it.businesslogic.ireport.util.Misc.getConnection("connection name")

Where "connection name" is the name of the connection in iReport.

This works only in iReport but you can use this expression to set a temporary value for your parameters.

Giulio

No Files Currently Attached