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.

Columns in a report (v 5.0.04)

5 posts in PB Infomaker Report Writer Last posting was on 1998-11-25 10:57:42.0Z
Tom Walker Posted on 1998-11-20 17:13:44.0Z
Newsgroups: sybase.public.infomaker.general
Date: Fri, 20 Nov 1998 17:13:44 +0000
From: Tom Walker <twalker@aston-zoraster.co.uk>
X-Mailer: Mozilla 4.5 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Columns in a report (v 5.0.04)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 12
Message-ID: <348_3655A347.4D4E1DCE@aston-zoraster.co.uk>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6712
Article PK: 241698

I've created a simple report (names, home addresses, telephone nos,
email addresses) which prints out correctly in a single column.

As it is fairly narrow, I wanted to make it a two column report and set
the columns box in the report properties - now it prints two columns but
the right hand column only has a couple of data items for each
individual, the rest are blank!

Is this a known problem or have I missed something?


Terry Dykstra Posted on 1998-11-23 19:53:43.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Columns in a report (v 5.0.04)
Date: Mon, 23 Nov 1998 12:53:43 -0700
Lines: 26
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_g1LH4DxF#GA.159@forums.powersoft.com>
References: <348_3655A347.4D4E1DCE@aston-zoraster.co.uk>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6708
Article PK: 241694

Let me just get the picture straight: you created a computed column where
you concatenate these columns: my_column = name + " " + home_address +
telphone + " " + email
Then you specify to use 2 newspaper columns on the 'print specification'
tab?
This scenario works for me. The thing to watch out for are the null values.
If any of the values are missing, then the computed column will evaluate to
null. You can use the IsNull() function to check for nulls and combine it
with an if() statement to build the proper computed field.
--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Tom Walker wrote in message <3655A347.4D4E1DCE@aston-zoraster.co.uk>...
>I've created a simple report (names, home addresses, telephone nos,
>email addresses) which prints out correctly in a single column.
>
>As it is fairly narrow, I wanted to make it a two column report and set
>the columns box in the report properties - now it prints two columns but
>the right hand column only has a couple of data items for each
>individual, the rest are blank!
>
>Is this a known problem or have I missed something?
>


Tom Walker Posted on 1998-11-24 13:22:04.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 24 Nov 1998 13:22:04 +0000
From: Tom Walker <twalker@aston-zoraster.co.uk>
X-Mailer: Mozilla 4.5 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Columns in a report (v 5.0.04)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 46
Message-ID: <348_365AB2F8.2E29DFA4@aston-zoraster.co.uk>
References: <348_3655A347.4D4E1DCE@aston-zoraster.co.uk> <348_g1LH4DxF#GA.159@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6707
Article PK: 241692

Not as complicated as you suggest - just a bunch of 9 or 10 fields (with one
trim function combining first and last names.

If I execute the report in a single column (newspaper columns 1) all the data in
each detail entry prints out.

If I execute the report with 2 columns, only a couple of the fields print (same
fields each time) for every detail entry which appears in the second column -
the first column is still fully populated with data! Also only 2 out of the 5
fields in the header show in the 2nd column.

I've just tried recreating the executable using 5.0.01 and get the same symptoms
as 5.0.04.

Terry Dykstra wrote:

> Let me just get the picture straight: you created a computed column where
> you concatenate these columns: my_column = name + " " + home_address +
> telphone + " " + email
> Then you specify to use 2 newspaper columns on the 'print specification'
> tab?
> This scenario works for me. The thing to watch out for are the null values.
> If any of the values are missing, then the computed column will evaluate to
> null. You can use the IsNull() function to check for nulls and combine it
> with an if() statement to build the proper computed field.
> --
> Terry Dykstra (TeamPS)
> Canadian Forest Oil Ltd.
>
> Tom Walker wrote in message <3655A347.4D4E1DCE@aston-zoraster.co.uk>...
> >I've created a simple report (names, home addresses, telephone nos,
> >email addresses) which prints out correctly in a single column.
> >
> >As it is fairly narrow, I wanted to make it a two column report and set
> >the columns box in the report properties - now it prints two columns but
> >the right hand column only has a couple of data items for each
> >individual, the rest are blank!
> >
> >Is this a known problem or have I missed something?
> >


Terry Dykstra Posted on 1998-11-25 00:21:47.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Columns in a report (v 5.0.04)
Date: Tue, 24 Nov 1998 17:21:47 -0700
Lines: 64
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_VN1xR#$F#GA.52@forums.powersoft.com>
References: <348_3655A347.4D4E1DCE@aston-zoraster.co.uk> <348_g1LH4DxF#GA.159@forums.powersoft.com> <348_365AB2F8.2E29DFA4@aston-zoraster.co.uk>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6703
Article PK: 241688

I can't reproduce this with IM5.0.04. I'll do some more research.
What happens when you remove the offending columns (from the select
statement) and then readd them? I've seen IM do some strange things
depending on what the default printer is at the time the report is run.
Does it make any difference when you change your default printer to a
different one?

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

Tom Walker wrote in message <365AB2F8.2E29DFA4@aston-zoraster.co.uk>...
>Not as complicated as you suggest - just a bunch of 9 or 10 fields (with
one
>trim function combining first and last names.
>
>If I execute the report in a single column (newspaper columns 1) all the
data in
>each detail entry prints out.
>
>If I execute the report with 2 columns, only a couple of the fields print
(same
>fields each time) for every detail entry which appears in the second
column -
>the first column is still fully populated with data! Also only 2 out of
the 5
>fields in the header show in the 2nd column.
>
>I've just tried recreating the executable using 5.0.01 and get the same
symptoms
>as 5.0.04.
>
>Terry Dykstra wrote:
>
>> Let me just get the picture straight: you created a computed column
where
>> you concatenate these columns: my_column = name + " " + home_address +
>> telphone + " " + email
>> Then you specify to use 2 newspaper columns on the 'print specification'
>> tab?
>> This scenario works for me. The thing to watch out for are the null
values.
>> If any of the values are missing, then the computed column will evaluate
to
>> null. You can use the IsNull() function to check for nulls and combine
it
>> with an if() statement to build the proper computed field.
>> --
>> Terry Dykstra (TeamPS)
>> Canadian Forest Oil Ltd.
>>
>> Tom Walker wrote in message <3655A347.4D4E1DCE@aston-zoraster.co.uk>...
>> >I've created a simple report (names, home addresses, telephone nos,
>> >email addresses) which prints out correctly in a single column.
>> >
>> >As it is fairly narrow, I wanted to make it a two column report and set
>> >the columns box in the report properties - now it prints two columns but
>> >the right hand column only has a couple of data items for each
>> >individual, the rest are blank!
>> >
>> >Is this a known problem or have I missed something?
>> >
>


Tom Walker Posted on 1998-11-25 10:57:42.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 25 Nov 1998 10:57:42 +0000
From: Tom Walker <twalker@aston-zoraster.co.uk>
X-Mailer: Mozilla 4.5 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Columns in a report (v 5.0.04)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 72
Message-ID: <348_365BE2A6.D68DFB3A@aston-zoraster.co.uk>
References: <348_3655A347.4D4E1DCE@aston-zoraster.co.uk> <348_g1LH4DxF#GA.159@forums.powersoft.com> <348_365AB2F8.2E29DFA4@aston-zoraster.co.uk> <348_VN1xR#$F#GA.52@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6702
Article PK: 241690

Changing the printer made no difference - even after recreating the exe file.

However, deleting and re-adding did seem to hav an effect - I tried it on one
field and it then printed that one OK.

As it was a simple report, I recreated it from scratch and it appears to be
working OK now.

Many thanks for your help.

Terry Dykstra wrote:

> I can't reproduce this with IM5.0.04. I'll do some more research.
> What happens when you remove the offending columns (from the select
> statement) and then readd them? I've seen IM do some strange things
> depending on what the default printer is at the time the report is run.
> Does it make any difference when you change your default printer to a
> different one?
>
> --
> Terry Dykstra (TeamPS)
> Canadian Forest Oil Ltd.
> Tom Walker wrote in message <365AB2F8.2E29DFA4@aston-zoraster.co.uk>...
> >Not as complicated as you suggest - just a bunch of 9 or 10 fields (with
> one
> >trim function combining first and last names.
> >
> >If I execute the report in a single column (newspaper columns 1) all the
> data in
> >each detail entry prints out.
> >
> >If I execute the report with 2 columns, only a couple of the fields print
> (same
> >fields each time) for every detail entry which appears in the second
> column -
> >the first column is still fully populated with data! Also only 2 out of
> the 5
> >fields in the header show in the 2nd column.
> >
> >I've just tried recreating the executable using 5.0.01 and get the same
> symptoms
> >as 5.0.04.
> >
> >Terry Dykstra wrote:
> >
> >> Let me just get the picture straight: you created a computed column
> where
> >> you concatenate these columns: my_column = name + " " + home_address +
> >> telphone + " " + email
> >> Then you specify to use 2 newspaper columns on the 'print specification'
> >> tab?
> >> This scenario works for me. The thing to watch out for are the null
> values.
> >> If any of the values are missing, then the computed column will evaluate
> to
> >> null. You can use the IsNull() function to check for nulls and combine
> it
> >> with an if() statement to build the proper computed field.
> >> --
> >> Terry Dykstra (TeamPS)
> >> Canadian Forest Oil Ltd.
> >>
> >> Tom Walker wrote in message <3655A347.4D4E1DCE@aston-zoraster.co.uk>...
> >> >I've created a simple report (names, home addresses, telephone nos,
> >> >email addresses) which prints out correctly in a single column.
> >> >
> >> >As it is fairly narrow, I wanted to make it a two column report and set
> >> >the columns box in the report properties - now it prints two columns but
> >> >the right hand column only has a couple of data items for each
> >> >individual, the rest are blank!
> >> >
> >> >Is this a known problem or have I missed something?
> >> >
> >