By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,219 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

Not visible when Null reporting problem

P: n/a
I searched the groups and tried several approaches but still cannot
find a solution.

I have a table that has several hundred fields that may or may not
need to be displayed in a report, depending on whether they are NULL
or not. (Due to limitations of out software, the table needs to be
designed this way)

The data needs to be displayed like this:

Record One Field1 Field2 (fields in this line are never null)
Field3 Field4 Field5 Field6 (fields in this line are related to each
other and are either all null or all not null)
Field8 Field9 Field10 Field11 (fields in this line are related to each
other and are either all null or all not null)
Field12 Field13 Field14 Field15 (fields in this line are related to
each other and are either all null or all not null)
Field16 Field17 Field18 Field19 (fields in this line are related to
each other and are either all null or all not null)
Field20 Field21 Field22 Field23 (fields in this line are related to
each other and are either all null or all not null)
....
Record Two Field1 Field2 (fields in this line never null)
Field3 Field4 Field5 Field6 (fields in this line are related to each
other and are either all null or all not null)
Field8 Field9 Field10 Field11 (fields in this line are related to each
other and are either all null or all not null)
Field12 Field13 Field14 Field15 (fields in this line are related to
each other and are either all null or all not null)
Field16 Field17 Field18 Field19 (fields in this line are related to
each other and are either all null or all not null)
Field20 Field21 Field22 Field23 (fields in this line are related to
each other and are either all null or all not null)
....

I want to display only those lines that have data in them. The number
of lines that contain data varies greatly from record to record.

The suggestion to set the height to "0" and "Can Grow" to yes and
stacking on top of one another did not work because the values in the
columns end up displaying in a cascading manner.

Field8
Field9
Field10
Field11
Field12
Field13
Field14
Field15 etc.

Ideas anyone?

Thanks in advance.

Debbie

Apr 23 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
n 23 Apr 2007 12:17:15 -0700, Debbiedo <de**********@yahoo.comwrote:
>I searched the groups and tried several approaches but still cannot
find a solution.

I have a table that has several hundred fields that may or may not
need to be displayed in a report, depending on whether they are NULL
or not. (Due to limitations of out software, the table needs to be
designed this way)

The data needs to be displayed like this:

Record One Field1 Field2 (fields in this line are never null)
Field3 Field4 Field5 Field6 (fields in this line are related to each
other and are either all null or all not null)
Field8 Field9 Field10 Field11 (fields in this line are related to each
other and are either all null or all not null)
Field12 Field13 Field14 Field15 (fields in this line are related to
each other and are either all null or all not null)
Field16 Field17 Field18 Field19 (fields in this line are related to
each other and are either all null or all not null)
Field20 Field21 Field22 Field23 (fields in this line are related to
each other and are either all null or all not null)
...
Record Two Field1 Field2 (fields in this line never null)
Field3 Field4 Field5 Field6 (fields in this line are related to each
other and are either all null or all not null)
Field8 Field9 Field10 Field11 (fields in this line are related to each
other and are either all null or all not null)
Field12 Field13 Field14 Field15 (fields in this line are related to
each other and are either all null or all not null)
Field16 Field17 Field18 Field19 (fields in this line are related to
each other and are either all null or all not null)
Field20 Field21 Field22 Field23 (fields in this line are related to
each other and are either all null or all not null)
...

I want to display only those lines that have data in them. The number
of lines that contain data varies greatly from record to record.

The suggestion to set the height to "0" and "Can Grow" to yes and
stacking on top of one another did not work because the values in the
columns end up displaying in a cascading manner.

Field8
Field9
Field10
Field11
Field12
Field13
Field14
Field15 etc.

Ideas anyone?

Thanks in advance.

Debbie
Set the top of fields 8, 9, 10 and 11 to EXACTLY the same value.
Set each height to .0007. Set can grow to yes.

Set the top of fields 12, 13, 14 and 15 to EXACTLY the same value and at least
..0014 below the top of fields 8, 9, 10 and 11.
Set each height to .0007. Set can grow to yes.

When printed the tops of the second row of fields will all be the same and will
be below the longest field of the first row.
(8) (9) (10) (11)
------- ------- ------- -------
------- ------- ------- -------
-------
-------
(12) (13) (14) (15)
------- ------- ------- -------
------- ------- ------- -------
-------
-------
Chuck
Apr 24 '07 #2

P: n/a
On Apr 23, 12:17 pm, Debbiedo <deb_dolit...@yahoo.comwrote:
I searched the groups and tried several approaches but still cannot
find a solution.

I have a table that has several hundred fields that may or may not
need to be displayed in a report, depending on whether they are NULL
or not. (Due to limitations of out software, the table needs to be
designed this way)

The data needs to be displayed like this:

Record One Field1 Field2 (fields in this line are never null)
Field3 Field4 Field5 Field6 (fields in this line are related to each
other and are either all null or all not null)
Field8 Field9 Field10 Field11 (fields in this line are related to each
other and are either all null or all not null)
Field12 Field13 Field14 Field15 (fields in this line are related to
each other and are either all null or all not null)
Field16 Field17 Field18 Field19 (fields in this line are related to
each other and are either all null or all not null)
Field20 Field21 Field22 Field23 (fields in this line are related to
each other and are either all null or all not null)
...
Record Two Field1 Field2 (fields in this line never null)
Field3 Field4 Field5 Field6 (fields in this line are related to each
other and are either all null or all not null)
Field8 Field9 Field10 Field11 (fields in this line are related to each
other and are either all null or all not null)
Field12 Field13 Field14 Field15 (fields in this line are related to
each other and are either all null or all not null)
Field16 Field17 Field18 Field19 (fields in this line are related to
each other and are either all null or all not null)
Field20 Field21 Field22 Field23 (fields in this line are related to
each other and are either all null or all not null)
...

I want to display only those lines that have data in them. The number
of lines that contain data varies greatly from record to record.

The suggestion to set the height to "0" and "Can Grow" to yes and
stacking on top of one another did not work because the values in the
columns end up displaying in a cascading manner.

Field8
Field9
Field10
Field11
Field12
Field13
Field14
Field15 etc.

Ideas anyone?

Thanks in advance.

Debbie
Last I knew, you could have only 255 columns in a table, but that
hardly is comforting.

The idea of zero and can grow might work if you are up to using
subreports. I did not try it, but maybe you can use each row as a
subreport. Now that I think about it, that might work. Set the
fields in each row in a subreport. For example, let's say that Fields
3 thru 6 are in subreport3To6. Then in the format event for the
detail on the main report, check if field3 is null and set
report.subreport.visible = not (isNull(Field3)).

Without trying that, I sure can't guarantee it would work.

If thsi were my problem and that did not work, then I'd set up one
control per row and format the single control as the concatenation of
the fields in the row. E.g. lets name the first one (in the example
above) as control3To6. Set it's height to zero and the control to
whatever is approprriate. You might have to use code to poupulated it
(you don't say what type of data this is). You biggest challenge
might be alignment of data. If you are proficient in VBA, you should
be able to build strings that are aligned (after a bit of testing).

I"m not sure any of this will help.
-- Larry Engles
Access developer since day 1 of Access 1.0

Apr 24 '07 #3

P: n/a
On Apr 23, 9:23 pm, eng...@ridesoft.com wrote:
On Apr 23, 12:17 pm, Debbiedo <deb_dolit...@yahoo.comwrote:


I searched the groups and tried several approaches but still cannot
find a solution.
I have a table that has several hundred fields that may or may not
need to be displayed in a report, depending on whether they are NULL
or not. (Due to limitations of out software, the table needs to be
designed this way)
The data needs to be displayed like this:
Record One Field1 Field2 (fields in this line are never null)
Field3 Field4 Field5 Field6 (fields in this line are related to each
other and are either all null or all not null)
Field8 Field9 Field10 Field11 (fields in this line are related to each
other and are either all null or all not null)
Field12 Field13 Field14 Field15 (fields in this line are related to
each other and are either all null or all not null)
Field16 Field17 Field18 Field19 (fields in this line are related to
each other and are either all null or all not null)
Field20 Field21 Field22 Field23 (fields in this line are related to
each other and are either all null or all not null)
...
Record Two Field1 Field2 (fields in this line never null)
Field3 Field4 Field5 Field6 (fields in this line are related to each
other and are either all null or all not null)
Field8 Field9 Field10 Field11 (fields in this line are related to each
other and are either all null or all not null)
Field12 Field13 Field14 Field15 (fields in this line are related to
each other and are either all null or all not null)
Field16 Field17 Field18 Field19 (fields in this line are related to
each other and are either all null or all not null)
Field20 Field21 Field22 Field23 (fields in this line are related to
each other and are either all null or all not null)
...
I want to display only those lines that have data in them. The number
of lines that contain data varies greatly from record to record.
The suggestion to set the height to "0" and "Can Grow" to yes and
stacking on top of one another did not work because the values in the
columns end up displaying in a cascading manner.
Field8
Field9
Field10
Field11
Field12
Field13
Field14
Field15 etc.
Ideas anyone?
Thanks in advance.
Debbie

Last I knew, you could have only 255 columns in a table, but that
hardly is comforting.

The idea of zero and can grow might work if you are up to using
subreports. I did not try it, but maybe you can use each row as a
subreport. Now that I think about it, that might work. Set the
fields in each row in a subreport. For example, let's say that Fields
3 thru 6 are in subreport3To6. Then in the format event for the
detail on the main report, check if field3 is null and set
report.subreport.visible = not (isNull(Field3)).

Without trying that, I sure can't guarantee it would work.

If thsi were my problem and that did not work, then I'd set up one
control per row and format the single control as the concatenation of
the fields in the row. E.g. lets name the first one (in the example
above) as control3To6. Set it's height to zero and the control to
whatever is approprriate. You might have to use code to poupulated it
(you don't say what type of data this is). You biggest challenge
might be alignment of data. If you are proficient in VBA, you should
be able to build strings that are aligned (after a bit of testing).

I"m not sure any of this will help.

-- Larry Engles
Access developer since day 1 of Access 1.0- Hide quoted text -

- Show quoted text -
On further thought: It really looks like you have folded several
tables into one. That is, at the minimum, you have the following:
ParentTable (has fields 1 and 2)
ChildTable1(has fields 3 - 6)
ChildTable2 (has fields 8 - 11) don't know what happened to field
7
etc.
Then there is no record at all for Child Table 1 to correspond to your
situation where they are all null.

It could be that ChildTable1 and ChildTable2 are really the same, but
just two rows (can't tell).

Then a report/subreport with this structure would automatically
provide what you are looking for in the report. Give it some thought.
-- Larry Engles
Access developer since day 1 of Access 1.0

Apr 24 '07 #4

P: n/a
On Apr 23, 9:08 pm, Chuck <libb...@schoollink.netwrote:
n 23 Apr 2007 12:17:15 -0700, Debbiedo <deb_dolit...@yahoo.comwrote:


I searched the groups and tried several approaches but still cannot
find a solution.
I have a table that has several hundred fields that may or may not
need to be displayed in a report, depending on whether they are NULL
or not. (Due to limitations of out software, the table needs to be
designed this way)
The data needs to be displayed like this:
Record One Field1 Field2 (fields in this line are never null)
Field3 Field4 Field5 Field6 (fields in this line are related to each
other and are either all null or all not null)
Field8 Field9 Field10 Field11 (fields in this line are related to each
other and are either all null or all not null)
Field12 Field13 Field14 Field15 (fields in this line are related to
each other and are either all null or all not null)
Field16 Field17 Field18 Field19 (fields in this line are related to
each other and are either all null or all not null)
Field20 Field21 Field22 Field23 (fields in this line are related to
each other and are either all null or all not null)
...
Record Two Field1 Field2 (fields in this line never null)
Field3 Field4 Field5 Field6 (fields in this line are related to each
other and are either all null or all not null)
Field8 Field9 Field10 Field11 (fields in this line are related to each
other and are either all null or all not null)
Field12 Field13 Field14 Field15 (fields in this line are related to
each other and are either all null or all not null)
Field16 Field17 Field18 Field19 (fields in this line are related to
each other and are either all null or all not null)
Field20 Field21 Field22 Field23 (fields in this line are related to
each other and are either all null or all not null)
...
I want to display only those lines that have data in them. The number
of lines that contain data varies greatly from record to record.
The suggestion to set the height to "0" and "Can Grow" to yes and
stacking on top of one another did not work because the values in the
columns end up displaying in a cascading manner.
Field8
Field9
Field10
Field11
Field12
Field13
Field14
Field15 etc.
Ideas anyone?
Thanks in advance.
Debbie

Set the top of fields 8, 9, 10 and 11 to EXACTLY the same value.
Set each height to .0007. Set can grow to yes.

Set the top of fields 12, 13, 14 and 15 to EXACTLY the same value and at least
.0014 below the top of fields 8, 9, 10 and 11.
Set each height to .0007. Set can grow to yes.

When printed the tops of the second row of fields will all be the same and will
be below the longest field of the first row.

(8) (9) (10) (11)
------- ------- ------- -------
------- ------- ------- -------
-------
-------
(12) (13) (14) (15)
------- ------- ------- -------
------- ------- ------- -------
-------
-------
Chuck- Hide quoted text -

- Show quoted text -
This worked great. Thanks

May 4 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.