I hadn't even thought of JasperReports yet. but, I could probably create a 'special EO', copy the attributes that I want to report on. and print this third EO.
or as you said pass the second EO as a parameter object and use a sub report. i was doing that for my to-many relations. My issue was I couldn't image how to connect to two different databases at the same time. It appears this is the easier of the difficult parts. Ted --- On Wed, 8/22/12, [email protected] <[email protected]> wrote: > From: [email protected] <[email protected]> > Subject: Re: creating a second database connection > To: "Theodore Petrosky" <[email protected]> > Cc: "Amedeo Mantica" <[email protected]>, "Paul Yu" <[email protected]>, > "[email protected]" <[email protected]> > Date: Wednesday, August 22, 2012, 7:21 PM > Jasper Reports? You can't use two > data sources in the same report, you will have to use > sub-reports. > > Envoyé de mon iPhone > > Le 2012-08-22 à 19:19, "Theodore Petrosky" <[email protected]> > a écrit : > > > db two is to read only. I want to munge together a > report. I'll try the two models and see how it works out. it > just sounds too simple. > > > > Ted > > > > > > --- On Wed, 8/22/12, Paul Yu <[email protected]> > wrote: > > > >> From: Paul Yu <[email protected]> > >> Subject: Re: creating a second database connection > >> To: "Amedeo Mantica" <[email protected]> > >> Cc: "[email protected]" > <[email protected]> > >> Date: Wednesday, August 22, 2012, 6:28 PM > >> But cross model joins would be an > >> issue? > >> > >> Sent from my iPad > >> > >> On Aug 22, 2012, at 4:09 PM, Amedeo Mantica <[email protected]> > >> wrote: > >> > >>> Just create two eomodels > >>> > >>> Sent from my iPhone > >>> > >>> On 22/ago/2012, at 21:55, Theodore Petrosky > <[email protected]> > >> wrote: > >>> > >>>> I have an app that captures data on events > and > >> writes this to my postgresql database. > >>>> > >>>> I have other data that lives in an Oracle > database > >> that I need to query to merge with to create a > report. > >>>> > >>>> like (data from PG) + (data from Oracle) = > >> myReport. > >>>> > >>>> I have no experience trying to connect to a > second > >> database in an app. Are there any examples of doing > this? > >>>> > >>>> Please, I have no idea where to start. > >>>> > >>>> Ted > >>>> > _______________________________________________ > >>>> Do not post admin requests to the list. > They will > >> be ignored. > >>>> Webobjects-dev mailing list > ([email protected]) > >>>> Help/Unsubscribe/Update your Subscription: > >>>> https://lists.apple.com/mailman/options/webobjects-dev/amedeomantica%40me.com > >>>> > >>>> This email sent to [email protected] > >>> > _______________________________________________ > >>> Do not post admin requests to the list. They > will be > >> ignored. > >>> Webobjects-dev mailing list > ([email protected]) > >>> Help/Unsubscribe/Update your Subscription: > >>> https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com > >>> > >>> This email sent to [email protected] > >> _______________________________________________ > >> Do not post admin requests to the list. They will > be > >> ignored. > >> Webobjects-dev mailing list ([email protected]) > >> Help/Unsubscribe/Update your Subscription: > >> https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com > >> > >> This email sent to [email protected] > >> > > > > _______________________________________________ > > Do not post admin requests to the list. They will be > ignored. > > Webobjects-dev mailing list ([email protected]) > > Help/Unsubscribe/Update your Subscription: > > https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca > > > > This email sent to [email protected] > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
