Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Datawindow reporting

2 posts in General Discussion (old) Last posting was on 2000-03-15 22:52:40.0Z
Rich Miller Posted on 2000-03-15 22:33:19.0Z
Newsgroups: sybase.public.easerver
From: "Rich Miller" <rmiller@nassau.cv.net>
Subject: Datawindow reporting
Date: Wed, 15 Mar 2000 17:33:19 -0500
Lines: 38
Organization: The IBT Group, LLC
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
NNTP-Posting-Host: hicks116-173.optonline.net 167.206.116.173
Message-ID: <347_K1Zp98sj$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26332
Article PK: 156999

We are having a problem with DataWindow reporting where the PB datawindows
are populated by resultSets from JAG. We've tried flattening the result set
so it was easier to populate the datawindow in PB (main report with several
sub-reports), but the breaks and grouping we require make this approach
little unwieldy.

Here are a few of ideas we have come up with. Please comment on them.

1. Use a Java datawindow/datastore that is designed against the Oracle
database. This would look exactly like the report we want to display to the
user. All of the grouping, breaks, joins, etc. that we need for the report.
I think this should be relatively easy to design in the datawindow painter.
The datawindow/datastore would be converted to a resultset and sent to the
PB app. The PB app would take the resultset and populate it's own version of
the datawindow/datastore.
Question - would the PB version look exactly like the Java version (break
for break, group for group)? Is this even possible? I tried this today with
no luck.

2. Our last resort is to design the datastore/datawindow in PB against
Oracle and put a PB NVO on JAG. We would then execute the NVO and do a
getFullState/setFullState from JAG to the PB app.
Question - Will this work?
Our concern doing this is that the I don't think that
getFullState/setFullState produces any kind of CORBA compliant data type
that another programming language could easily use.

Any thoughts on this?



Regards (as I am banging my head against the desk),

Rich
____________________________________


Mark Maslow Posted on 2000-03-15 22:52:40.0Z
Newsgroups: sybase.public.easerver
From: "Mark Maslow" <mark.maslow@sierraclub.org>
Subject: Re: Datawindow reporting
Date: Wed, 15 Mar 2000 14:52:40 -0800
Lines: 62
Organization: Sierra Club
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: machine001.sierraclub.org 207.90.163.1
Message-ID: <347_#7QHaItj$GA.261@forums.sybase.com>
References: <347_K1Zp98sj$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26328
Article PK: 156995

I've used method 2, and it works fine. The "FullState" is passed as an
array of byte, so is completely CORBA compliant.

You should be able to make method 1 work, but you would need to get the
dataobject definition from the server, or use the binary wizard to change it
into a Java class. You would also have to pass dropdowns and any other
child datawindows as separate result sets, and populate in your own code.
The advantage of method 1 is that it should perform somewhat better. But
method 2 is much easier to program - and my experience is that performance
is at least adequate.

Mark Maslow

Rich Miller <rmiller@nassau.cv.net> wrote in message
news:K1Zp98sj$GA.111@forums.sybase.com...
> We are having a problem with DataWindow reporting where the PB datawindows
> are populated by resultSets from JAG. We've tried flattening the result
set
> so it was easier to populate the datawindow in PB (main report with
several
> sub-reports), but the breaks and grouping we require make this approach
> little unwieldy.
>
> Here are a few of ideas we have come up with. Please comment on them.
>
> 1. Use a Java datawindow/datastore that is designed against the Oracle
> database. This would look exactly like the report we want to display to
the
> user. All of the grouping, breaks, joins, etc. that we need for the
report.
> I think this should be relatively easy to design in the datawindow
painter.
> The datawindow/datastore would be converted to a resultset and sent to the
> PB app. The PB app would take the resultset and populate it's own version
of
> the datawindow/datastore.
> Question - would the PB version look exactly like the Java version (break
> for break, group for group)? Is this even possible? I tried this today
with
> no luck.
>
> 2. Our last resort is to design the datastore/datawindow in PB against
> Oracle and put a PB NVO on JAG. We would then execute the NVO and do a
> getFullState/setFullState from JAG to the PB app.
> Question - Will this work?
> Our concern doing this is that the I don't think that
> getFullState/setFullState produces any kind of CORBA compliant data type
> that another programming language could easily use.
>
> Any thoughts on this?
>
>
>
> Regards (as I am banging my head against the desk),
>
> Rich
> ____________________________________
>
>
>