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.

Add reports dynamically

5 posts in DataWindow Last posting was on 2009-04-07 16:34:06.0Z
Mariano Recuero Posted on 2009-04-02 10:51:33.0Z
Sender: deb.49d49328.1804289383@sybase.com
From: Mariano Recuero
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Add reports dynamically
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49d498b5.e52.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Apr 2009 02:51:33 -0800
X-Trace: forums-1-dub 1238669493 10.22.241.41 (2 Apr 2009 02:51:33 -0800)
X-Original-Trace: 2 Apr 2009 02:51:33 -0800, 10.22.241.41
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89096
Article PK: 418346

hi,
environment: client / server . PB 11.5 DB: FireBird.
Id like to know if its possible add reports (dw) to my
software dynamically.
Facts: software i have to develop is for a foreing company,
but i develop it for an intermediate company(IC) not for end
user(EU). The intermediate company just want a report module
with filtering criteria before retrieve report.
EU cand request some new reports to IC and IC request the
develoment of those reports. So i send IC the final reports
but IC doesnt want to update the sofware everytime, just
reports.
So he propose to me make an update system by ftp....then
- First, i suggest IC that if user will update report by
ftp, then it could update the whole software, its the same
procedure.

- Second, this is the reason of my answer...is it possible
add new reports with no new compilations of software?
i dont know if throught .psr file or another file could be
possible add dynamically those reports or just retrieve data
from those dw.....

Regards


Jeremy Lakeman Posted on 2009-04-02 11:56:34.0Z
From: Jeremy Lakeman <jeremy.lakeman@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Add reports dynamically
Date: Thu, 2 Apr 2009 04:56:34 -0700 (PDT)
Organization: http://groups.google.com
Lines: 52
Message-ID: <3ea9d2a8-0c89-4ab2-b597-846171844dfb@d19g2000prh.googlegroups.com>
References: <49d498b5.e52.1681692777@sybase.com>
NNTP-Posting-Host: 114.30.106.123
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1238673503 2815 127.0.0.1 (2 Apr 2009 11:58:23 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 2 Apr 2009 11:58:23 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: d19g2000prh.googlegroups.com; posting-host=114.30.106.123; posting-account=euaBtgoAAAC_vDxfsxmpMKlBxHaHpmRS
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.9.1b3) Gecko/20090305 Firefox/3.1b3,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!news.glorb.com!postnews.google.com!d19g2000prh.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89099
Article PK: 418348


On Apr 2, 8:51 pm, Mariano Recuero wrote:
> hi,
> environment: client / server . PB 11.5 DB: FireBird.
> Id like to know if its possible add reports (dw) to my
> software dynamically.
> Facts: software i have to develop is for a foreing company,
> but i develop it for an intermediate company(IC) not for end
> user(EU). The intermediate company just want a report module
> with filtering criteria before retrieve report.
> EU cand request some new reports to IC and IC request the
> develoment of those reports. So i send IC the final reports
> but IC doesnt want to update the sofware everytime, just
> reports.
> So he propose to me make an update system by ftp....then
> - First, i suggest IC that if user will update report by
> ftp, then it could update the whole software, its the same
> procedure.
>
> - Second, this is the reason of my answer...is it possible
> add new reports with no new compilations of software?
> i dont know if throught .psr file or another file could be
> possible add dynamically those reports or just retrieve data
> from those dw.....
>
> Regards

Option 1
Deploy all report datawindow's in pbd's.
Call addtolibrarylist when the application starts to add the latest
version of report libraries

Option 2
Use libraryimport to compile the latest version of the reports into
you application at run time.
This way you can store the latest syntax of each report individually
in the database

Option 3
Just call dw_1.create(ls_syntax) when you run the report. (Any nested
reports or dropdown's will need to be in the application already
through either option 1 or 2, though I *think* there is another way to
do even that dynamically)

That's the easy part. Next you will need to define the retrieval
arguments and prompt the user for valid values.
I'd suggest using openuserobject to create a control for each argument
inherited from a common ancestor, using a database table to define
which control goes where and has which data-type. Then call retrieve
with too many arguments (the unused ones will be ignored) like this;

any a[20]
dw_1.retrieve(a[1], a[2], a[3], ... a[20])


M. Searer Posted on 2009-04-03 21:02:05.0Z
From: "M. Searer" <nospam@nospam.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49d498b5.e52.1681692777@sybase.com>
In-Reply-To: <49d498b5.e52.1681692777@sybase.com>
Subject: Re: Add reports dynamically
Lines: 31
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d6794d@forums-1-dub>
Date: 3 Apr 2009 13:02:05 -0800
X-Trace: forums-1-dub 1238792525 10.22.241.152 (3 Apr 2009 13:02:05 -0800)
X-Original-Trace: 3 Apr 2009 13:02:05 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89114
Article PK: 418364

you can add .pbls to the library list dynamically; so all you need is infomaker to create reports.

you could also store the report export in just files or in the database

"Mariano Recuero" wrote in message news:49d498b5.e52.1681692777@sybase.com...
> hi,
> environment: client / server . PB 11.5 DB: FireBird.
> Id like to know if its possible add reports (dw) to my
> software dynamically.
> Facts: software i have to develop is for a foreing company,
> but i develop it for an intermediate company(IC) not for end
> user(EU). The intermediate company just want a report module
> with filtering criteria before retrieve report.
> EU cand request some new reports to IC and IC request the
> develoment of those reports. So i send IC the final reports
> but IC doesnt want to update the sofware everytime, just
> reports.
> So he propose to me make an update system by ftp....then
> - First, i suggest IC that if user will update report by
> ftp, then it could update the whole software, its the same
> procedure.
>
> - Second, this is the reason of my answer...is it possible
> add new reports with no new compilations of software?
> i dont know if throught .psr file or another file could be
> possible add dynamically those reports or just retrieve data
> from those dw.....
>
> Regards


ChrissDeGrece Posted on 2009-04-07 04:53:47.0Z
From: ChrissDeGrece <chriss_degrece_NOSPAM_@yahoo.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Add reports dynamically
References: <49d498b5.e52.1681692777@sybase.com>
In-Reply-To: <49d498b5.e52.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49dadc5b$1@forums-1-dub>
Date: 6 Apr 2009 21:53:47 -0700
X-Trace: forums-1-dub 1239080027 10.22.241.152 (6 Apr 2009 21:53:47 -0700)
X-Original-Trace: 6 Apr 2009 21:53:47 -0700, vip152.sybase.com
Lines: 55
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89119
Article PK: 418373

This is what I do:

1) Export my DW to an XML style file like this

<REPORTNAME>Customers List</REPORTNAME>
<CATEGORYNAME>Customers</CATEGORYNAME>
<REPORT>
......DwSyntax Here........
</REPORT>
<PARAMETERS>2</PARAMETERS>
<PARAM1>Customer ID;id;decimal;0</PARAM1>
<PARAM2>Customer Name;cusname;char;0</PARAM2>

2) Customer imports that and it's stored in the database, DWsyntax is
stored in a "reports" table and parameters are stored in a
"reportparams" table. Alternatively he can have a folder for all reports
and Import/Run them from there.

This way we can add any criteria or do any modifications wants without
needing any retrieval arguments and of course NO recompilation.

In every DW we add a "WHERE 1=1 AND .....<other criteria>...." , then
our report viewer just replaces the string "1=1" with the parameters and
the values the user entered in order to filter the results.


HTH

Chriss

Mariano Recuero wrote:
> hi,
> environment: client / server . PB 11.5 DB: FireBird.
> Id like to know if its possible add reports (dw) to my
> software dynamically.
> Facts: software i have to develop is for a foreing company,
> but i develop it for an intermediate company(IC) not for end
> user(EU). The intermediate company just want a report module
> with filtering criteria before retrieve report.
> EU cand request some new reports to IC and IC request the
> develoment of those reports. So i send IC the final reports
> but IC doesnt want to update the sofware everytime, just
> reports.
> So he propose to me make an update system by ftp....then
> - First, i suggest IC that if user will update report by
> ftp, then it could update the whole software, its the same
> procedure.
>
> - Second, this is the reason of my answer...is it possible
> add new reports with no new compilations of software?
> i dont know if throught .psr file or another file could be
> possible add dynamically those reports or just retrieve data
> from those dw.....
>
> Regards


KL Posted on 2009-04-07 16:34:06.0Z
Sender: 6f9e.49db5295.1804289383@sybase.com
From: KL
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Add reports dynamically
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49db807e.75bf.1681692777@sybase.com>
References: <49d498b5.e52.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Apr 2009 09:34:06 -0700
X-Trace: forums-1-dub 1239122046 10.22.241.41 (7 Apr 2009 09:34:06 -0700)
X-Original-Trace: 7 Apr 2009 09:34:06 -0700, 10.22.241.41
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89129
Article PK: 418381

Should be able to just re-compile and update the report.pbd,
and not the entire app.

How do/would the UE get to new reports?
Pick from a list, based on database entries?

Or, are you really essentially massaging the same report,
just changing the columns and criteria, and maybe a table or
two?

JAT KL

> hi,
> environment: client / server . PB 11.5 DB: FireBird.
> Id like to know if its possible add reports (dw) to my
> software dynamically.
> Facts: software i have to develop is for a foreing company
> , but i develop it for an intermediate company(IC) not for
> end user(EU). The intermediate company just want a report
> module with filtering criteria before retrieve report.
> EU cand request some new reports to IC and IC request the
> develoment of those reports. So i send IC the final
> reports but IC doesnt want to update the sofware everytime
> , just reports.
> So he propose to me make an update system by ftp....then
> - First, i suggest IC that if user will update report by
> ftp, then it could update the whole software, its the same
> procedure.
>
> - Second, this is the reason of my answer...is it possible
> add new reports with no new compilations of software?
> i dont know if throught .psr file or another file could be
> possible add dynamically those reports or just retrieve
> data from those dw.....
>
> Regards