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.

Assessment of IM on several issues, please?

9 posts in PB Infomaker Report Writer Last posting was on 1999-06-11 13:55:11.0Z
Frank Burleigh Posted on 1999-05-18 15:05:17.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 18 May 1999 10:05:17 -0500
From: Frank Burleigh <burleigh@indiana.edu>
Organization: Indiana University School of Law
X-Mailer: Mozilla 4.51 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
To: burleigh@indiana.edu
Subject: Assessment of IM on several issues, please?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 69
Message-ID: <348_374181AD.7DD2A3EC@indiana.edu>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6309
Article PK: 241294

We use Sybase' ASE 11.9.2 engine, Borland tools for client development,
and Seagate's Crystal Reports for report work. I once tried IM (v5), as
it came with ASE 11.5. I recall feeling that it was very clunky and
extremely slow--but at the time I was working against paradox tables
through a wacky Microsoft ODBC driver for Paradox tables, so maybe that
experience was not a fair test.

In any case, while Crystal Reports generally does what I need it to do,
there are a few issues with it that are a problem for us, and Seagate
has been non responsive on these issues. So I want to evaluate IM as
either a supplementary tool or as a replacement. I would appreciate
honest assessment of IM on these issues to help me decide whether to
spend much time experimenting with IM:

1. Multicolumn reports. The area where Crystal falls down is its poor
support for multicolumn (e.g. newspaper columns) reports. In
particular, CR doesn't think of a column as a page, so keeping details
together with their group headers or footers is a real problem in a
multicolumn report. In a recent example, a report listing people by
state would be quite happy to print the state name at the bottom of a
column, then continue with the names of those in the state in the next
column. While is isn't unusual in report writers I've seen, some users
won't accept such results.

2. Report deployment. Crystal Reports has some nice deployment
features:
- You can make an exe that a user can run.
- CR has its Report Engine that can be called from client (e.g., C++)
apps.
- Seagate provides a (VCL) component for Borland's Delphi and C++
Builder tools so you can set a bunch of report properties, then run the
report. I think you can even alter the SQL that's in the report.

3. CR has a language with a fairly rich set of functions for handling
text, math, etc. What does IM have? In what contexts can "formulas" be
used--e.g., as fields, summarizing formulas as if they were db fields,
grouping on formulas as though they were db fields, referring to other
formulas and using formula results in IF tests?

4. Handling of text: this is another area where CR is perhaps a bit
weak, but you can usually find a workaround. We do much work with
addresses, so a report writer that doesn't know to close up null fields
in some way or that requires formulas to find the non empty fields would
be a bit of a drag.

5. Licensing. What sort of license is required for distributing reports
within the organization (assuming reports can be run separate from IM
itself, that is)?

--
Frank Burleigh
Indiana University School of Law
Bloomington, IN 47405
burleigh@indiana.edu 812-855-9170


Terry Dykstra Posted on 1999-05-18 18:08:21.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Assessment of IM on several issues, please?
Date: Tue, 18 May 1999 12:08:21 -0600
Lines: 88
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_0Y#DajVo#GA.295@forums.sybase.com>
References: <348_374181AD.7DD2A3EC@indiana.edu>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6308
Article PK: 241293

See comments below.

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Frank Burleigh wrote in message <374181AD.7DD2A3EC@indiana.edu>...
>We use Sybase' ASE 11.9.2 engine, Borland tools for client development,
>and Seagate's Crystal Reports for report work. I once tried IM (v5), as
>it came with ASE 11.5. I recall feeling that it was very clunky and
>extremely slow--but at the time I was working against paradox tables
>through a wacky Microsoft ODBC driver for Paradox tables, so maybe that
>experience was not a fair test.
>
>In any case, while Crystal Reports generally does what I need it to do,
>there are a few issues with it that are a problem for us, and Seagate
>has been non responsive on these issues. So I want to evaluate IM as
>either a supplementary tool or as a replacement. I would appreciate
>honest assessment of IM on these issues to help me decide whether to
>spend much time experimenting with IM:
>
>1. Multicolumn reports. The area where Crystal falls down is its poor
>support for multicolumn (e.g. newspaper columns) reports. In
>particular, CR doesn't think of a column as a page, so keeping details
>together with their group headers or footers is a real problem in a
>multicolumn report. In a recent example, a report listing people by
>state would be quite happy to print the state name at the bottom of a
>column, then continue with the names of those in the state in the next
>column. While is isn't unusual in report writers I've seen, some users
>won't accept such results.
>

In IM you can create so called N-Up reports, which are essentially newspaper
reports. IM works the same in this respect as CR.
For regular reports you can also specify how many columns you want to use.

>2. Report deployment. Crystal Reports has some nice deployment
>features:
>- You can make an exe that a user can run.
Same for IM
>- CR has its Report Engine that can be called from client (e.g., C++)
>apps.
IM can serve as OLE server. IM objects can be called directly from
Powerbuilder.

>- Seagate provides a (VCL) component for Borland's Delphi and C++
>Builder tools so you can set a bunch of report properties, then run the
>report. I think you can even alter the SQL that's in the report.
>
I don't know what you mean by a VCL component.

>3. CR has a language with a fairly rich set of functions for handling
>text, math, etc. What does IM have? In what contexts can "formulas" be
>used--e.g., as fields, summarizing formulas as if they were db fields,
>grouping on formulas as though they were db fields, referring to other
>formulas and using formula results in IF tests?
>
IM has many functions, that you can use anywhere, in footers, headers, any
group band. You can sort, filter, create groups based on any db column or
computed ) object in the report.

>4. Handling of text: this is another area where CR is perhaps a bit
>weak, but you can usually find a workaround. We do much work with
>addresses, so a report writer that doesn't know to close up null fields
>in some way or that requires formulas to find the non empty fields would
>be a bit of a drag.
>
Autoseize height, slide up, slide left are supported.

>5. Licensing. What sort of license is required for distributing reports
>within the organization (assuming reports can be run separate from IM
>itself, that is)?

Unlimited distribution of the exes created with IM, including the database
drivers.

The native drivers are actually very fast. They also offer better support
for calling stored procedures than most ODBC drivers.
IM supports nested and composite reports.
IM supports the pipeline as well, allowing you to easily move data between
databases.
You can create simple data entry forms as well.
You can save IM reports into .PSR files, allowing you to send these to other
people who don't have IM. The nice feature of these PSR files is that they
give you the full sorting, filtering, printing capabilities as the 'live'
reports do. They can also be used in webservers using the datawindow
plugin.


Frank Burleigh Posted on 1999-05-18 18:55:30.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 18 May 1999 13:55:30 -0500
From: Frank Burleigh <burleigh@indiana.edu>
Organization: Indiana University School of Law
X-Mailer: Mozilla 4.51 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Assessment of IM on several issues, please?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 45
Message-ID: <348_3741B7A2.6A1B10DA@indiana.edu>
References: <348_374181AD.7DD2A3EC@indiana.edu> <348_0Y#DajVo#GA.295@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6307
Article PK: 241297

Excellent response, thank you so much! Of course ;-) now I have
followups! Please see below.

> > Frank Burleigh wrote in message <374181AD.7DD2A3EC@indiana.edu>...

Terry Dykstra wrote:

[snip]

> In IM you can create so called N-Up reports, which are essentially newspaper
> reports. IM works the same in this respect as CR.

When you say IM works much as CR, do you mean that it has the same
problem with orphaned group headers and footers as CR? This is the main
problem that needs to be overcome. (By orphaned, I mean that a group's
header might be printed at the bottom of one column with detail record
printing beginning in the next column--some people find this confusing.)

> >4. Handling of text: this is another area where CR is perhaps a bit
> >weak, but you can usually find a workaround. We do much work with
> >addresses, so a report writer that doesn't know to close up null fields
> >in some way or that requires formulas to find the non empty fields would
> >be a bit of a drag.
> >
> Autoseize height, slide up, slide left are supported.

Excellent. CR lacks these features unless you use what Seagate calls a
text object.

> You can create simple data entry forms as well.

What would you do with this? I mean, what can you do with the "entered"
data?

Another question: CR recently included the notion of a parameter that
the report's author can define. CR, including from run-time reports,
prompts for a value, and then you can test that value to do something
different in a formula or to formatting, or the parameter value can be
passed to the SQL for the report.

Again, I appreciate any contributions.

--
Frank Burleigh
Indiana University School of Law
Bloomington, IN 47405
burleigh@indiana.edu 812-855-9170


Terry Dykstra Posted on 1999-05-19 18:13:03.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Assessment of IM on several issues, please?
Date: Wed, 19 May 1999 12:13:03 -0600
Lines: 71
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_6eJ#pKio#GA.298@forums.sybase.com>
References: <348_374181AD.7DD2A3EC@indiana.edu> <348_0Y#DajVo#GA.295@forums.sybase.com> <348_3741B7A2.6A1B10DA@indiana.edu>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6302
Article PK: 241285

see comments below

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.

Frank Burleigh wrote in message <3741B7A2.6A1B10DA@indiana.edu>...
>Excellent response, thank you so much! Of course ;-) now I have
>followups! Please see below.
>
>> > Frank Burleigh wrote in message <374181AD.7DD2A3EC@indiana.edu>...
>
>Terry Dykstra wrote:
>
>[snip]
>
>> In IM you can create so called N-Up reports, which are essentially
newspaper
>> reports. IM works the same in this respect as CR.
>
>When you say IM works much as CR, do you mean that it has the same
>problem with orphaned group headers and footers as CR? This is the main
>problem that needs to be overcome. (By orphaned, I mean that a group's
>header might be printed at the bottom of one column with detail record
>printing beginning in the next column--some people find this confusing.)
>

Actually, the N-Up style report doesn't allow you to create groups.
When using tabular reports with the 'print multiple columns' option (which
gives the same result as the n-up report), it will handle the page break
properly when you set the 'new page on group break'. No 'orphan' stuff at
the bottom of a column.

>> >4. Handling of text: this is another area where CR is perhaps a bit
>> >weak, but you can usually find a workaround. We do much work with
>> >addresses, so a report writer that doesn't know to close up null fields
>> >in some way or that requires formulas to find the non empty fields would
>> >be a bit of a drag.
>> >
>> Autoseize height, slide up, slide left are supported.
>
>Excellent. CR lacks these features unless you use what Seagate calls a
>text object.
>
>> You can create simple data entry forms as well.
>
>What would you do with this? I mean, what can you do with the "entered"
>data?
>
It is just for quick and dirty data maintenance. You can create freeform,
grid-style, one-to-many, many-to-one data entry forms. We use them for
instance to give some functionality to users that their off the shelf
programs don't offer.
If you ahve PB, you can customize these basic forms or create new ones that
allow you to create quite sohisticated applications.

>Another question: CR recently included the notion of a parameter that
>the report's author can define. CR, including from run-time reports,
>prompts for a value, and then you can test that value to do something
>different in a formula or to formatting, or the parameter value can be
>passed to the SQL for the report.


Retrieval arguments are used to make the SQL flexible: select * from table
where myfield = :myargument etc.
Besides using the retrieval arguments in the SQL part, you can also use them
on the report itself, for instance to set filter, sorts, compute etc. Even
though you define retrieval arguments in the SQL painter of your report, you
don't have to use them in the select statement in order to use them on the
report.


Larry Molter Posted on 1999-06-11 13:55:11.0Z
Newsgroups: sybase.public.infomaker.general
From: larry.molter@tamabay.rr.com (Larry Molter)
Subject: Re: Assessment of IM on several issues, please?
Date: Fri, 11 Jun 1999 13:55:11 GMT
X-Newsreader: Forte Free Agent 1.11/32.235
Lines: 17
Message-ID: <348_37611513.2913098@forums.powersoft.com>
References: <348_374181AD.7DD2A3EC@indiana.edu> <348_0Y#DajVo#GA.295@forums.sybase.com> <348_3741B7A2.6A1B10DA@indiana.edu> <348_6eJ#pKio#GA.298@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6214
Article PK: 240150


>>> In IM you can create so called N-Up reports, which are essentially
>newspaper

Terry, N-up is not really the same as 'newspaper-style' reports. In a
newspaper report, the data snakes down one column then goes to the top
of the next column, and so forth. An N-up report, while it is a
multi-column report, does not snake. Data is sorted left-to-right
across the page, not down the columns. Also, N-up is a presentation
style, newspaper is a print-time option. Almost any style of report
could be printed in newspaper style.

I know the original posting was a while ago, but I just happened
across it today.

Larry Molter
digital fusion, inc


Frank Burleigh Posted on 1999-05-20 23:16:38.0Z
Newsgroups: sybase.public.infomaker.general
Date: Thu, 20 May 1999 18:16:38 -0500
From: Frank Burleigh <burleigh@indiana.edu>
Organization: Indiana University School of Law
X-Mailer: Mozilla 4.6 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Assessment of IM on several issues, please?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 100
Message-ID: <348_374497D6.BFBF465A@indiana.edu>
References: <348_374181AD.7DD2A3EC@indiana.edu> <348_0Y#DajVo#GA.295@forums.sybase.com> <348_3741B7A2.6A1B10DA@indiana.edu> <348_6eJ#pKio#GA.298@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6297
Article PK: 241282

Thanks again. I wish I had known n-up reports couldn't do groups before
I spent some hours trying to understand why the group options were
greyed on the menu. ;-)

As you suggested, I tried the DBLIB *and* System 10/11 direct drivers.
Both produced the complaint that sp_pb60sp and sp_pb60table can't be
found. Using these drivers does not let me do anything, since no db
objects seem visible.

I must be doing something really dumb here.

Keep in mind there is no PB here--just IM and Sybase ASE. Is there
perhaps some other piece that I haven't installed? Some script that
needs to be run in the DB? If you are not in ASE I suppose you may not
have confronted this...

But I sure appreciate your helpfulness.

Terry Dykstra wrote:
>
> see comments below
>
> --
> Terry Dykstra (TeamSybase)
> Canadian Forest Oil Ltd.
> Frank Burleigh wrote in message <3741B7A2.6A1B10DA@indiana.edu>...
> >Excellent response, thank you so much! Of course ;-) now I have
> >followups! Please see below.
> >
> >> > Frank Burleigh wrote in message <374181AD.7DD2A3EC@indiana.edu>...
> >
> >Terry Dykstra wrote:
> >
> >[snip]
> >
> >> In IM you can create so called N-Up reports, which are essentially
> newspaper
> >> reports. IM works the same in this respect as CR.
> >
> >When you say IM works much as CR, do you mean that it has the same
> >problem with orphaned group headers and footers as CR? This is the main
> >problem that needs to be overcome. (By orphaned, I mean that a group's
> >header might be printed at the bottom of one column with detail record
> >printing beginning in the next column--some people find this confusing.)
> >
> Actually, the N-Up style report doesn't allow you to create groups.
> When using tabular reports with the 'print multiple columns' option (which
> gives the same result as the n-up report), it will handle the page break
> properly when you set the 'new page on group break'. No 'orphan' stuff at
> the bottom of a column.
>
> >> >4. Handling of text: this is another area where CR is perhaps a bit
> >> >weak, but you can usually find a workaround. We do much work with
> >> >addresses, so a report writer that doesn't know to close up null fields
> >> >in some way or that requires formulas to find the non empty fields would
> >> >be a bit of a drag.
> >> >
> >> Autoseize height, slide up, slide left are supported.
> >
> >Excellent. CR lacks these features unless you use what Seagate calls a
> >text object.
> >
> >> You can create simple data entry forms as well.
> >
> >What would you do with this? I mean, what can you do with the "entered"
> >data?
> >
> It is just for quick and dirty data maintenance. You can create freeform,
> grid-style, one-to-many, many-to-one data entry forms. We use them for
> instance to give some functionality to users that their off the shelf
> programs don't offer.
> If you ahve PB, you can customize these basic forms or create new ones that
> allow you to create quite sohisticated applications.
>
> >Another question: CR recently included the notion of a parameter that
> >the report's author can define. CR, including from run-time reports,
> >prompts for a value, and then you can test that value to do something
> >different in a formula or to formatting, or the parameter value can be
> >passed to the SQL for the report.
>
> Retrieval arguments are used to make the SQL flexible: select * from table
> where myfield = :myargument etc.
> Besides using the retrieval arguments in the SQL part, you can also use them
> on the report itself, for instance to set filter, sorts, compute etc. Even
> though you define retrieval arguments in the SQL painter of your report, you
> don't have to use them in the select statement in order to use them on the
> report.

--
Frank Burleigh
Indiana University School of Law
Bloomington, IN 47405
burleigh@indiana.edu 812-855-9170


Terry Dykstra Posted on 1999-05-21 15:33:12.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Assessment of IM on several issues, please?
Date: Fri, 21 May 1999 09:33:12 -0600
Lines: 117
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_kWFbi65o#GA.225@forums.sybase.com>
References: <348_374181AD.7DD2A3EC@indiana.edu> <348_0Y#DajVo#GA.295@forums.sybase.com> <348_3741B7A2.6A1B10DA@indiana.edu> <348_6eJ#pKio#GA.298@forums.sybase.com> <348_374497D6.BFBF465A@indiana.edu>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6295
Article PK: 241281

When using the native driver, you must run the pbsyc.sql or pbsyc2.sql
scripts. See the manual 'conecting to your database version 6', chapter 3:
installing powersoft stored procedures in SQL Server databases (page 274).

I wish N-up reports had the group capability. I don't understand that
either.

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.

Frank Burleigh wrote in message <374497D6.BFBF465A@indiana.edu>...
>Thanks again. I wish I had known n-up reports couldn't do groups before
>I spent some hours trying to understand why the group options were
>greyed on the menu. ;-)
>
>As you suggested, I tried the DBLIB *and* System 10/11 direct drivers.
>Both produced the complaint that sp_pb60sp and sp_pb60table can't be
>found. Using these drivers does not let me do anything, since no db
>objects seem visible.
>
>I must be doing something really dumb here.
>
>Keep in mind there is no PB here--just IM and Sybase ASE. Is there
>perhaps some other piece that I haven't installed? Some script that
>needs to be run in the DB? If you are not in ASE I suppose you may not
>have confronted this...
>
>But I sure appreciate your helpfulness.
>
>Terry Dykstra wrote:
>>
>> see comments below
>>
>> --
>> Terry Dykstra (TeamSybase)
>> Canadian Forest Oil Ltd.
>> Frank Burleigh wrote in message <3741B7A2.6A1B10DA@indiana.edu>...
>> >Excellent response, thank you so much! Of course ;-) now I have
>> >followups! Please see below.
>> >
>> >> > Frank Burleigh wrote in message <374181AD.7DD2A3EC@indiana.edu>...
>> >
>> >Terry Dykstra wrote:
>> >
>> >[snip]
>> >
>> >> In IM you can create so called N-Up reports, which are essentially
>> newspaper
>> >> reports. IM works the same in this respect as CR.
>> >
>> >When you say IM works much as CR, do you mean that it has the same
>> >problem with orphaned group headers and footers as CR? This is the main
>> >problem that needs to be overcome. (By orphaned, I mean that a group's
>> >header might be printed at the bottom of one column with detail record
>> >printing beginning in the next column--some people find this confusing.)
>> >
>> Actually, the N-Up style report doesn't allow you to create groups.
>> When using tabular reports with the 'print multiple columns' option
(which
>> gives the same result as the n-up report), it will handle the page break
>> properly when you set the 'new page on group break'. No 'orphan' stuff
at
>> the bottom of a column.
>>
>> >> >4. Handling of text: this is another area where CR is perhaps a bit
>> >> >weak, but you can usually find a workaround. We do much work with
>> >> >addresses, so a report writer that doesn't know to close up null
fields
>> >> >in some way or that requires formulas to find the non empty fields
would
>> >> >be a bit of a drag.
>> >> >
>> >> Autoseize height, slide up, slide left are supported.
>> >
>> >Excellent. CR lacks these features unless you use what Seagate calls a
>> >text object.
>> >
>> >> You can create simple data entry forms as well.
>> >
>> >What would you do with this? I mean, what can you do with the "entered"
>> >data?
>> >
>> It is just for quick and dirty data maintenance. You can create
freeform,
>> grid-style, one-to-many, many-to-one data entry forms. We use them for
>> instance to give some functionality to users that their off the shelf
>> programs don't offer.
>> If you ahve PB, you can customize these basic forms or create new ones
that
>> allow you to create quite sohisticated applications.
>>
>> >Another question: CR recently included the notion of a parameter that
>> >the report's author can define. CR, including from run-time reports,
>> >prompts for a value, and then you can test that value to do something
>> >different in a formula or to formatting, or the parameter value can be
>> >passed to the SQL for the report.
>>
>> Retrieval arguments are used to make the SQL flexible: select * from
table
>> where myfield = :myargument etc.
>> Besides using the retrieval arguments in the SQL part, you can also use
them
>> on the report itself, for instance to set filter, sorts, compute etc.
Even
>> though you define retrieval arguments in the SQL painter of your report,
you
>> don't have to use them in the select statement in order to use them on
the
>> report.
>
>--
>Frank Burleigh
>Indiana University School of Law
>Bloomington, IN 47405
>burleigh@indiana.edu 812-855-9170


Frank Burleigh Posted on 1999-05-23 16:54:53.0Z
Newsgroups: sybase.public.infomaker.general
Date: Sun, 23 May 1999 11:54:53 -0500
From: Frank Burleigh <burleigh@indiana.edu>
Organization: Indiana University School of Law
X-Mailer: Mozilla 4.6 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Assessment of IM on several issues, please?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 132
Message-ID: <348_374832DD.18E3EBE6@indiana.edu>
References: <348_374181AD.7DD2A3EC@indiana.edu> <348_0Y#DajVo#GA.295@forums.sybase.com> <348_3741B7A2.6A1B10DA@indiana.edu> <348_6eJ#pKio#GA.298@forums.sybase.com> <348_374497D6.BFBF465A@indiana.edu> <348_kWFbi65o#GA.225@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6293
Article PK: 241279

Thanks for your reply.

Sybase is nuts. I found the references you mentioned. They point me to
a \SERVER directory on what I take to be the IM distribution media.
Well, for me, that's the ASE 11.9.2 CD, and there is no SERVER directory
there. Hence I don't have the scripts, it seems, and can't use their
report writer on their own DB!!!

I must be missing something. :-(

Terry Dykstra wrote:
>
> When using the native driver, you must run the pbsyc.sql or pbsyc2.sql
> scripts. See the manual 'conecting to your database version 6', chapter 3:
> installing powersoft stored procedures in SQL Server databases (page 274).
>
> I wish N-up reports had the group capability. I don't understand that
> either.
>
> --
> Terry Dykstra (TeamSybase)
> Canadian Forest Oil Ltd.
> Frank Burleigh wrote in message <374497D6.BFBF465A@indiana.edu>...
> >Thanks again. I wish I had known n-up reports couldn't do groups before
> >I spent some hours trying to understand why the group options were
> >greyed on the menu. ;-)
> >
> >As you suggested, I tried the DBLIB *and* System 10/11 direct drivers.
> >Both produced the complaint that sp_pb60sp and sp_pb60table can't be
> >found. Using these drivers does not let me do anything, since no db
> >objects seem visible.
> >
> >I must be doing something really dumb here.
> >
> >Keep in mind there is no PB here--just IM and Sybase ASE. Is there
> >perhaps some other piece that I haven't installed? Some script that
> >needs to be run in the DB? If you are not in ASE I suppose you may not
> >have confronted this...
> >
> >But I sure appreciate your helpfulness.
> >
> >Terry Dykstra wrote:
> >>
> >> see comments below
> >>
> >> --
> >> Terry Dykstra (TeamSybase)
> >> Canadian Forest Oil Ltd.
> >> Frank Burleigh wrote in message <3741B7A2.6A1B10DA@indiana.edu>...
> >> >Excellent response, thank you so much! Of course ;-) now I have
> >> >followups! Please see below.
> >> >
> >> >> > Frank Burleigh wrote in message <374181AD.7DD2A3EC@indiana.edu>...
> >> >
> >> >Terry Dykstra wrote:
> >> >
> >> >[snip]
> >> >
> >> >> In IM you can create so called N-Up reports, which are essentially
> >> newspaper
> >> >> reports. IM works the same in this respect as CR.
> >> >
> >> >When you say IM works much as CR, do you mean that it has the same
> >> >problem with orphaned group headers and footers as CR? This is the main
> >> >problem that needs to be overcome. (By orphaned, I mean that a group's
> >> >header might be printed at the bottom of one column with detail record
> >> >printing beginning in the next column--some people find this confusing.)
> >> >
> >> Actually, the N-Up style report doesn't allow you to create groups.
> >> When using tabular reports with the 'print multiple columns' option
> (which
> >> gives the same result as the n-up report), it will handle the page break
> >> properly when you set the 'new page on group break'. No 'orphan' stuff
> at
> >> the bottom of a column.
> >>
> >> >> >4. Handling of text: this is another area where CR is perhaps a bit
> >> >> >weak, but you can usually find a workaround. We do much work with
> >> >> >addresses, so a report writer that doesn't know to close up null
> fields
> >> >> >in some way or that requires formulas to find the non empty fields
> would
> >> >> >be a bit of a drag.
> >> >> >
> >> >> Autoseize height, slide up, slide left are supported.
> >> >
> >> >Excellent. CR lacks these features unless you use what Seagate calls a
> >> >text object.
> >> >
> >> >> You can create simple data entry forms as well.
> >> >
> >> >What would you do with this? I mean, what can you do with the "entered"
> >> >data?
> >> >
> >> It is just for quick and dirty data maintenance. You can create
> freeform,
> >> grid-style, one-to-many, many-to-one data entry forms. We use them for
> >> instance to give some functionality to users that their off the shelf
> >> programs don't offer.
> >> If you ahve PB, you can customize these basic forms or create new ones
> that
> >> allow you to create quite sohisticated applications.
> >>
> >> >Another question: CR recently included the notion of a parameter that
> >> >the report's author can define. CR, including from run-time reports,
> >> >prompts for a value, and then you can test that value to do something
> >> >different in a formula or to formatting, or the parameter value can be
> >> >passed to the SQL for the report.
> >>
> >> Retrieval arguments are used to make the SQL flexible: select * from
> table
> >> where myfield = :myargument etc.
> >> Besides using the retrieval arguments in the SQL part, you can also use
> them
> >> on the report itself, for instance to set filter, sorts, compute etc.
> Even
> >> though you define retrieval arguments in the SQL painter of your report,
> you
> >> don't have to use them in the select statement in order to use them on
> the
> >> report.
> >
> >--
> >Frank Burleigh
> >Indiana University School of Law
> >Bloomington, IN 47405
> >burleigh@indiana.edu 812-855-9170

--
Frank Burleigh
Indiana University School of Law
Bloomington, IN 47405
burleigh@indiana.edu 812-855-9170


Terry Dykstra Posted on 1999-05-25 15:13:49.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Assessment of IM on several issues, please?
Date: Tue, 25 May 1999 09:13:49 -0600
Lines: 158
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_5xzNNCsp#GA.232@forums.sybase.com>
References: <348_374181AD.7DD2A3EC@indiana.edu> <348_0Y#DajVo#GA.295@forums.sybase.com> <348_3741B7A2.6A1B10DA@indiana.edu> <348_6eJ#pKio#GA.298@forums.sybase.com> <348_374497D6.BFBF465A@indiana.edu> <348_kWFbi65o#GA.225@forums.sybase.com> <348_374832DD.18E3EBE6@indiana.edu>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6290
Article PK: 241275

They should be on the IM CD, not the ASE CD. Anyways,
I've sent you the scripts.

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.

Frank Burleigh wrote in message <374832DD.18E3EBE6@indiana.edu>...
>Thanks for your reply.
>
>Sybase is nuts. I found the references you mentioned. They point me to
>a \SERVER directory on what I take to be the IM distribution media.
>Well, for me, that's the ASE 11.9.2 CD, and there is no SERVER directory
>there. Hence I don't have the scripts, it seems, and can't use their
>report writer on their own DB!!!
>
>I must be missing something. :-(
>
>Terry Dykstra wrote:
>>
>> When using the native driver, you must run the pbsyc.sql or pbsyc2.sql
>> scripts. See the manual 'conecting to your database version 6', chapter
3:
>> installing powersoft stored procedures in SQL Server databases (page
274).
>>
>> I wish N-up reports had the group capability. I don't understand that
>> either.
>>
>> --
>> Terry Dykstra (TeamSybase)
>> Canadian Forest Oil Ltd.
>> Frank Burleigh wrote in message <374497D6.BFBF465A@indiana.edu>...
>> >Thanks again. I wish I had known n-up reports couldn't do groups before
>> >I spent some hours trying to understand why the group options were
>> >greyed on the menu. ;-)
>> >
>> >As you suggested, I tried the DBLIB *and* System 10/11 direct drivers.
>> >Both produced the complaint that sp_pb60sp and sp_pb60table can't be
>> >found. Using these drivers does not let me do anything, since no db
>> >objects seem visible.
>> >
>> >I must be doing something really dumb here.
>> >
>> >Keep in mind there is no PB here--just IM and Sybase ASE. Is there
>> >perhaps some other piece that I haven't installed? Some script that
>> >needs to be run in the DB? If you are not in ASE I suppose you may not
>> >have confronted this...
>> >
>> >But I sure appreciate your helpfulness.
>> >
>> >Terry Dykstra wrote:
>> >>
>> >> see comments below
>> >>
>> >> --
>> >> Terry Dykstra (TeamSybase)
>> >> Canadian Forest Oil Ltd.
>> >> Frank Burleigh wrote in message <3741B7A2.6A1B10DA@indiana.edu>...
>> >> >Excellent response, thank you so much! Of course ;-) now I have
>> >> >followups! Please see below.
>> >> >
>> >> >> > Frank Burleigh wrote in message
<374181AD.7DD2A3EC@indiana.edu>...
>> >> >
>> >> >Terry Dykstra wrote:
>> >> >
>> >> >[snip]
>> >> >
>> >> >> In IM you can create so called N-Up reports, which are essentially
>> >> newspaper
>> >> >> reports. IM works the same in this respect as CR.
>> >> >
>> >> >When you say IM works much as CR, do you mean that it has the same
>> >> >problem with orphaned group headers and footers as CR? This is the
main
>> >> >problem that needs to be overcome. (By orphaned, I mean that a
group's
>> >> >header might be printed at the bottom of one column with detail
record
>> >> >printing beginning in the next column--some people find this
confusing.)
>> >> >
>> >> Actually, the N-Up style report doesn't allow you to create groups.
>> >> When using tabular reports with the 'print multiple columns' option
>> (which
>> >> gives the same result as the n-up report), it will handle the page
break
>> >> properly when you set the 'new page on group break'. No 'orphan'
stuff
>> at
>> >> the bottom of a column.
>> >>
>> >> >> >4. Handling of text: this is another area where CR is perhaps a
bit
>> >> >> >weak, but you can usually find a workaround. We do much work with
>> >> >> >addresses, so a report writer that doesn't know to close up null
>> fields
>> >> >> >in some way or that requires formulas to find the non empty fields
>> would
>> >> >> >be a bit of a drag.
>> >> >> >
>> >> >> Autoseize height, slide up, slide left are supported.
>> >> >
>> >> >Excellent. CR lacks these features unless you use what Seagate calls
a
>> >> >text object.
>> >> >
>> >> >> You can create simple data entry forms as well.
>> >> >
>> >> >What would you do with this? I mean, what can you do with the
"entered"
>> >> >data?
>> >> >
>> >> It is just for quick and dirty data maintenance. You can create
>> freeform,
>> >> grid-style, one-to-many, many-to-one data entry forms. We use them
for
>> >> instance to give some functionality to users that their off the shelf
>> >> programs don't offer.
>> >> If you ahve PB, you can customize these basic forms or create new ones
>> that
>> >> allow you to create quite sohisticated applications.
>> >>
>> >> >Another question: CR recently included the notion of a parameter that
>> >> >the report's author can define. CR, including from run-time reports,
>> >> >prompts for a value, and then you can test that value to do something
>> >> >different in a formula or to formatting, or the parameter value can
be
>> >> >passed to the SQL for the report.
>> >>
>> >> Retrieval arguments are used to make the SQL flexible: select * from
>> table
>> >> where myfield = :myargument etc.
>> >> Besides using the retrieval arguments in the SQL part, you can also
use
>> them
>> >> on the report itself, for instance to set filter, sorts, compute etc.
>> Even
>> >> though you define retrieval arguments in the SQL painter of your
report,
>> you
>> >> don't have to use them in the select statement in order to use them on
>> the
>> >> report.
>> >
>> >--
>> >Frank Burleigh
>> >Indiana University School of Law
>> >Bloomington, IN 47405
>> >burleigh@indiana.edu 812-855-9170
>
>--
>Frank Burleigh
>Indiana University School of Law
>Bloomington, IN 47405
>burleigh@indiana.edu 812-855-9170