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
4  1701 
n 23 Apr 2007 12:17:15 -0700, Debbiedo <de**********@y ahoo.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
On Apr 23, 12:17 pm, Debbiedo <deb_dolit...@y ahoo.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.subrepor t.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
On Apr 23, 9:23 pm, eng...@ridesoft .com wrote:
On Apr 23, 12:17 pm, Debbiedo <deb_dolit...@y ahoo.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.subrepor t.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
On Apr 23, 9:08 pm, Chuck <libb...@school link.netwrote:
n 23 Apr 2007 12:17:15 -0700, Debbiedo <deb_dolit...@y ahoo.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: jeff regoord |
last post by:
A user inputs a float value. The scanf() function gets the value.
However, I need to create an error handler with an if else statement
saying invalid input if the input is not a number. Does anybody know
how I could do this?
|
by: Jay Walker |
last post by:
I created a custom DataGridColumn based on Marcie Robillard's MSDN
Article:
Creating Custom Columns for the ASP.NET Datagrid
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/creatingcustomcolumns.asp
The problem I am having is that the data in the custom datagridcolumn
is not saved to viewstate and after postback, the column does not
contain data.
|
by: jpr |
last post by:
Hello,
I have a form with twa txtboxes named mytxt and txtresult.
The txtresult gets its data from a module (GetInterval).
I have written this statement:
If IsNull (Me.mytxt) then
Me.txtresult) = Null
|
by: Jimmy Stewart |
last post by:
I have a calculated control "ContactInfo" on my form ... ="Attn: " &
In the OnCurrent event for the form I have the following code...
If Me.Contact Is Null Then
Me.ContactInfo.Visible = False
End If
The idea is, that if there is no contact listed (I have the contact field on
the form with visible property set to no) then this line will not display.
|
by: dgardner |
last post by:
This one has me stumped and I hope someone can help.
I have a form with a button on it. When I click the button, I want a
label named lblWait to be visible. (When the form opens, the label is
not visible.)
I have this line of code:
Me.lblWait.Visible = True
Then there is a line that defines strSQL. This takes a minute or so.
| | |
by: barrathi |
last post by:
Hi all
i need one query help!
for reporting purpose i wrote one query - follows
select s.tran_empid as EmpId, e.M_EMPL_NAME as EmpName, p.PROJ_NAME as Project, t.TITL_NAME as Title,CASE WHEN s.tran_param='Project Level Key Initiatives' THEN round((sum(s.tran_revscore)/(s.tran_weightage/100))) END as PLKI,CASE WHEN s.tran_param='Quality' THEN round((sum(s.tran_revscore)/(s.tran_weightage/100))) END as Quality,CASE WHEN...
|
by: =?Utf-8?B?VGVycnk=?= |
last post by:
Hi,
I have a couple of labels on a form and their visible property is bound
to boolean properties on a custom object. When I first load the form, all
works as it should. This form is 'tied' together with a search form, and the
user can go back and forth. When the user hits ok, the form is hidden and
the search form is shown and visa-versa. The problem is that when the form
is hidden when the labels visible property is False, and then...
|
by: crabsdf |
last post by:
My project is a single method class which takes a xml object and, using Apache FOP, transforms it into a PDF which is returned as an output stream.
Here is full code
package transactionStatement;
import javax.xml.transform.TransformerFactory;
import javax.servlet.*;
import org.jdom.*;
import java.io.ByteArrayOutputStream;
import java.io.File;
|
by: sanjay |
last post by:
Hi,
I have a doubt about passing values to a function accepting string.
======================================
#include <iostream>
using namespace std;
int main()
{
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
