Groups > dBase > dBase reports > Re: Controls not showing on report




Controls not showing on report

Controls not showing on report
Wed, 27 Jun 2007 03:40:02 -040
On the group header section I have some datalinked controls that are NAMED
something like follows:

row1col1   row1col2   row1col3   row1col4
row2col1   row2col2   row2col3   row2col4
row3col1   row3col2   row3col3   row3col4
row4col1   row4col2   row4col3   row4col4
row5col1   row5col2   row5col3   row5col4

Each control is datalinked to a field. My problem is this:
If there is a value of 0 in the first column then I dont want to show any of the
data for that row. That I can do.
However this could lead to havnig gaps on the report itself which does not look
pretty. 
To handle this I wrote some code in each of the canRender events for the first
column that checks for 0. If found then move all of the subsuquent controls
underneath the current one up the report on top of the ceuurent control.

This works fine for 3 out fo of 4 columns. As soon as the third column controls
position on the rport changes it is not visible on the the prointed report.
Whether it has rendered or not I do not know. It is not a Zorder problem as I
have chaked that the controls were added rowq, row2, and so on.

Can anyone offer some assistance?

Thanks,


John




Post Reply
Re: Controls not showing on report
Wed, 27 Jun 2007 05:34:42 -070
John Noble wrote:
> On the group header section I have some datalinked controls that are NAMED
something like follows:
> 
> row1col1   row1col2   row1col3   row1col4
> row2col1   row2col2   row2col3   row2col4
> row3col1   row3col2   row3col3   row3col4
> row4col1   row4col2   row4col3   row4col4
> row5col1   row5col2   row5col3   row5col4
> 
> Each control is datalinked to a field. My problem is this:
> If there is a value of 0 in the first column then I dont want to show any
of the data for that row. That I can do.
> However this could lead to havnig gaps on the report itself which does not
look pretty. 
> To handle this I wrote some code in each of the canRender events for the
first column that checks for 0. If found then move all of the subsuquent
controls underneath the current one up the report on top of the ceuurent
control.
> 
> This works fine for 3 out fo of 4 columns. As soon as the third column
controls position on the rport changes it is not visible on the the prointed
report. Whether it has rendered or not I do not know. It is not a Zorder problem
as I have chaked that the controls were added rowq, row2, and so on.
> 
> Can anyone offer some assistance?

suppressIfBlank = true?

Ken

-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/dbase/dBASEReportsBook.htm
http://www.goldenstag.net/GSP
Post Reply
Re: Controls not showing on report
Wed, 27 Jun 2007 12:15:33 -040
> > 
> > Can anyone offer some assistance?
> 
> suppressIfBlank = true?
> 
> Ken

Hi Ken,

tried that
still showing nothing.

John
Post Reply
Re: Controls not showing on report
Thu, 28 Jun 2007 00:39:40 -040
In article <6jBhjZNuHHA.1108@news-server>, john@nospam says...
> 
> > > 
> > > Can anyone offer some assistance?
> > 
> > suppressIfBlank = true?
> > 
> > Ken
> 
> Hi Ken,
> 
> tried that
> still showing nothing.
> 
> John


John,

Perhaps you should show us some of your code so that we can see what you 
are doing.

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
Post Reply
Re: Controls not showing on report
Thu, 28 Jun 2007 05:03:36 -040
Geoff Wass [dBVIPS] Wrote:

> 
> Perhaps you should show us some of your code so that we can see what you 
> are doing.
> 
Hello Geoff,

Here is the code that is causing the problem

I have changed the control names to make the problem more understandable.

Thanks,

John

function TEXTrow1DESCRIPTION1_canRender
   
          
// if there is no local amount
      if this.form.acc0051.rowset.fields["row1boxes"].value = 0.00
   
          
    // row2
form.streamsource1.group1.headerband.textrow2description1.top   -= 0.2
            form.streamsource1.group1.headerband.textrow2boxes1.top         -=
0.2
            form.streamsource1.group1.headerband.textrow2rate1.top          -=
0.2
            form.streamsource1.group1.headerband.textrow2amount1.top        -=
0.2
             
         // row 3
            form.streamsource1.group1.headerband.textrow3description1.top   -=
0.2
            form.streamsource1.group1.headerband.textrow3boxes1.top         -=
0.2
            form.streamsource1.group1.headerband.textrow3rate1.top          -=
0.2
            form.streamsource1.group1.headerband.textrow3amount1.top        -=
0.2
             
         // row 4
            form.streamsource1.group1.headerband.textrow4description1.top   -=
0.2
            form.streamsource1.group1.headerband.textrow4boxes1.top         -=
0.2
            form.streamsource1.group1.headerband.textrow4rate1.top          -=
0.2
            form.streamsource1.group1.headerband.textrow4amount1.top        -=
0.2
   
         // row 5
            form.streamsource1.group1.headerband.textrow5description1.top   -=
0.2
            form.streamsource1.group1.headerband.textrow5boxes1.top         -=
0.2
            form.streamsource1.group1.headerband.textrow5rate1.top          -=
0.2
            form.streamsource1.group1.headerband.textrow5amount1.top        -=
0.2
            
            return false
         endif
          
   
   return true
   
   
   function TEXTrow2DESCRIPTION1_canRender
   
          
            
	  // if there is no north amount
	 if this.form.acc0051.rowset.fields["row2boxes"].value = 0.00


	 // row3
	    form.streamsource1.group1.headerband.textrow3description1.top -= 0.2
	    form.streamsource1.group1.headerband.textrow3boxes1.top -= 0.2
	    form.streamsource1.group1.headerband.textrow3rate1.top -= 0.2
	    form.streamsource1.group1.headerband.textrow3amount1.top -= 0.2

	 // row 4
	    form.streamsource1.group1.headerband.textrow4description1.top -= 0.2
	    form.streamsource1.group1.headerband.textrow4boxes1.top -= 0.2
	    form.streamsource1.group1.headerband.textrow4rate1.top -= 0.2
	    form.streamsource1.group1.headerband.textrow4amount1.top -= 0.2

	 // row 5
	    form.streamsource1.group1.headerband.textrow5description1.top -= 0.2
	    form.streamsource1.group1.headerband.textrow5boxes1.top -= 0.2
	    form.streamsource1.group1.headerband.textrow5rate1.top -= 0.2
	    form.streamsource1.group1.headerband.textrow5amount1.top -= 0.2

	    return false
	 endif
    
   
   return true
Post Reply
<< Previous 1 2 Next >>
( Page 1 of 2 )
about | contact