Columnar Report- this is for Duane

[Anne]

I have previously put this to the group, but I think I was not able to
express well what I needed.

I have a columnar Report( but not a normal columnar report in a subform. The
subreport consists of aboout 14 data fields grouped together into one nice
little quare by GangID. In the subform, the Groupheader for GangId is set to
new row or column after sections. The subreport is linked to the main form
by PourID.
Each pour can have up to 6 gangs, each gang can have up to 8 items.

Each row represents one gang and fills with data for the gang and starts a
new row for the gangID.
I am using Duane Hookom's routine of filling the report with empty
rectangulars for the rows, which works perfectly now.
My one stumper:
I can put the the GangID in front of the subreport and use Hide Duplicates
to just show the gang# one time, but no such luck with labels. I need to put
labels in front of the report or the subreport, but there is no option to
hide duplicates.
I also need total lenghts for each gang someplace with the gang, but
everything I have tried does not work.

My report comes out perfect, but I do need to have labels and running
totals.
I had a meeting with the people I am writing the database for and they said
they could deal with the input in normal columnar format, but the report
needs to look they way it did when it was an excel spreadsheet.
Help?
Anne

 

[Duane Hookom]

I wish I had a clue what you were talking about with pours, gangs, items,
reports in subforms, quares,... my head is spinning.

HELP!

 

[Anne]

Duane, I hope perhaps one of these days I will be able to express my
questions in a better way.

I know you are probably the only person who has the knowledge to address the
problem I am trying to solve, because I have seen a cool report, which fits
my need exactly on some website, but I can't find it anymore. With some
searching I will eventually find it again, and when I find it, I might asked
you again for some additional questions. At this time I give up or in and
resign my self to the fact, that I know what I am trying to do is possible
to do without the help of a guru. I demo, where you showed how to do, what I
want to do, but I can't find the friggen link again. From what I have seen,
you are the authority on difficult reports.
I have a problem expressing myself.

Although I have been in this country for 41 years, my youth was spent in
Germany and I still have problem getting my point across. My sons, came hear
at the age of 12 and went to school here, but he went to school here and the
is an American all the way, he doesn't even remember German very much. I
some sence I am still translating after all these years. Even my sence
structure at time, result in a translated German sentence. I have come a
long way.
I know you are my answer to this difficult problem, because it is not a
normal structure of a report. So when I find the right word to make you
understand, I will try again. Being able to attach a file, would easily make
you understand what I am looking for, but this is not possible on this
newgroup.
For now, I have to tell you that I am greatful for any help you have given
me so far, and you were a great help when I started.
You let me send a small version of my database before, to show you, what I
cannot express, and you wrote for the the blank rectanglur code for filling
reports field with emply columns.
I am re-using this over and over.
Thanks,
Anne
I will contact you on your websit.
I don't think anyone else but you can help me with this wierd setup