dBASE Reports - Suppresifduplicate

Author

Suppresifduplicate

Robert Bravery

2005-09-27, 7:24 am

HI,

Cant seem to get the suppresifduplicate to work correctly in the detail
band. With this set to true, duplicate field values still show in the
reports detailed band, even right after eachother

ANy help
Thanks
Robert

Robert Bravery

2005-10-27, 8:02 am

So I guess nobody has an answer or nobody's using it

Robert

"Robert Bravery" <me@u.com> wrote in message
news:FiVnJ50wFHA.1232@news-server...
> HI,
>
> Cant seem to get the suppresifduplicate to work correctly in the detail
> band. With this set to true, duplicate field values still show in the
> reports detailed band, even right after eachother
>
> ANy help
> Thanks
> Robert
>
>

Frank J. Polan

2005-10-27, 8:02 am

Robert

Below is a simple report - PLUS 2.6 - that shows it working. Do you
have a turnkey we can look at

Frank Polan

//----------------------------------------------------
/* use this to create tables for turnkey */
/////////////// test.wfm ////////////////
close databases
close all
clear all
release all
clear memory
clear program
set proc to
//

if file('test.dbf')
drop table 'test.dbf'
endif
create table 'test.dbf' ( ;
field1 char (10), ;
field2 char (10) ;
)

insert into test (field1, field2) values ('abc', 'def')
insert into test (field1, field2) values ('abc', 'jkl')
insert into test (field1, field2) values ('abc', 'pqr')

//

** END HEADER -- do not remove this line
//
// Generated on 10/04/2005
//
local r
r = new rbReport()
r.render()

class rbReport of REPORT
with (this)
metric = 3 // Inches
autoSort = false
endwith

this.TEST1 = new QUERY()
this.TEST1.parent = this
with (this.TEST1)
left = 1.0833
top = 0.2917
sql = 'select * from "test.dbf"'
requestLive = false
active = true
endwith

with (this.printer)
duplex = 1 // None
orientation = 1 // Portrait
paperSource = 7
paperSize = 1
resolution = 0 // Default
color = 2 // Color
trueTypeFonts = 0 // Default
endwith

this.STREAMSOURCE1 = new STREAMSOURCE(this)
with (this.STREAMSOURCE1.detailBand)
height = 0.1736
endwith

this.STREAMSOURCE1.detailBand.TITLETEXTFIELD1 = new
TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TITLETEXTFIELD1)
canRender = {||this.parent.firstOnFrame}
height = 0.2083
left = 0.1354
top = 0.0257
width = 0.75
prefixEnable = false
suppressIfBlank = true
text = "<H3>Field1</H3>"
endwith

this.STREAMSOURCE1.detailBand.TEXTFIELD11 = new
TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTFIELD11)
height = 0.2035
left = 0.1354
top = 0.2292
width = 0.75
variableHeight = true
prefixEnable = false
suppressIfDuplicate = true
text = {||this.form.test1.rowset.fields["field1"].value}
endwith

this.STREAMSOURCE1.detailBand.TITLETEXTFIELD2 = new
TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TITLETEXTFIELD2)
canRender = {||this.parent.firstOnFrame}
height = 0.2083
left = 1.3125
top = 0.0569
width = 0.75
prefixEnable = false
suppressIfBlank = true
text = "<H3>Field2</H3>"
endwith

this.STREAMSOURCE1.detailBand.TEXTFIELD21 = new
TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTFIELD21)
height = 0.2035
left = 1.3125
top = 0.2604
width = 0.75
variableHeight = true
prefixEnable = false
text = {||this.form.test1.rowset.fields["field2"].value}
endwith

this.PAGETEMPLATE1 = new PAGETEMPLATE(this)
with (this.PAGETEMPLATE1)
height = 11.0
width = 8.5
marginTop = 0.75
marginLeft = 0.75
marginBottom = 0.75
marginRight = 0.75
gridLineWidth = 0
endwith

this.PAGETEMPLATE1.STREAMFRAME1 = new
STREAMFRAME(this.PAGETEMPLATE1)
with (this.PAGETEMPLATE1.STREAMFRAME1)
height = 8.0521
left = 0.25
top = 0.9479
width = 6.5
form.STREAMFRAME1 = form.pagetemplate1.streamframe1
endwith

with (this.reportGroup.headerBand)
height = 0.1736
endwith

with (this.reportGroup.footerBand)
height = 0.1736
endwith

this.firstPageTemplate = this.form.pagetemplate1
this.form.pagetemplate1.nextPageTemplate = this.form.pagetemplate1
this.form.pagetemplate1.streamframe1.streamSource =
this.form.streamsource1
this.form.streamsource1.rowset = this.form.test1.rowset

endclass
//-------------------------------

On Tue, 4 Oct 2005 23:35:54 +0200, "Robert Bravery" <me@u.com> wrote:

>
>So I guess nobody has an answer or nobody's using it
>
>Robert
>
>"Robert Bravery" <me@u.com> wrote in message
>news:FiVnJ50wFHA.1232@news-server...
>
>

Sponsored Links