Columns - Subreports - labeling nightmare

  • Thread starter Thread starter Alan B. Densky
  • Start date Start date
A

Alan B. Densky

Hi,

I have a unique problem:

1. Report consists of main report with a subreport in the detail section
2. Subreport is 2" wide
3. Main report is set to print 4 columns
4. Record source for sub report has four fields
a) Question Text
b) Answer Text
c) RecordID
d) ParentRecordID
5. Fields are located on the Subreport as follows:
[Question Text] [Answer Text]

Report works flawlessly and prints 4 colums of data, just as it should.
Everything lines up perfectly. The Question/Answer line in each column is
perfectly on line with the same question/answer line in the other columns.

THE PROBLEM:
I want the [Question Text] field to print in the left column only and not
repeat itself in each column

THIS IS WHAT I HAVE
[Question Text] [Answer Text] [Question Text] [Answer Text] [Question Text]
[Answer Text] etc

THIS IS WHAT I WANT
[Question Text] [Answer Text] [Answer Text] [Answer Text] [Answer Text]

Does anyone know how to accomplish this? I cannot change from the Main
Report/Subreport format. It's too complicated to explain why.
 
Alan said:
I have a unique problem:

1. Report consists of main report with a subreport in the detail section
2. Subreport is 2" wide
3. Main report is set to print 4 columns
4. Record source for sub report has four fields
a) Question Text
b) Answer Text
c) RecordID
d) ParentRecordID
5. Fields are located on the Subreport as follows:
[Question Text] [Answer Text]

Report works flawlessly and prints 4 colums of data, just as it should.
Everything lines up perfectly. The Question/Answer line in each column is
perfectly on line with the same question/answer line in the other columns.

THE PROBLEM:
I want the [Question Text] field to print in the left column only and not
repeat itself in each column

THIS IS WHAT I HAVE
[Question Text] [Answer Text] [Question Text] [Answer Text] [Question Text]
[Answer Text] etc

THIS IS WHAT I WANT
[Question Text] [Answer Text] [Answer Text] [Answer Text] [Answer Text]
Click to expand...

You might be able to use a similar approach to KB 153052,
but from a subreport the code would have to check
Me.Parent.Left

The part about setting Me.NextRecord will break it if the
subreport has more than one record though

Does anyone know how to accomplish this? I cannot change from the Main
Report/Subreport format. It's too complicated to explain why.
Click to expand...

I'm not sure I'm convinced of that ;-)

The KB would definitly apply if you could do away with the
subreport. Are certain that you can not come up with a
record source query that Joins the main report data to the
subreport's data?
 
Hi Marshall,

I had looked at 153052 before I wrote to the group. I'm very doubtful that
method will work because what I'm doing is so different from the sample. As
far as getting rid of the subreport, for very complicated reasons that
doesn't look too promising either. But I will revisit 153052 again and see
if I can do something with the ideas in it. I like to tell clients that the
only limitations are their imagination. This may be one time when that's not
true.

I was hoping that maybe someone out there has done this all ready and could
get me off the hook. Thanks for trying.

Alan Densky



Marshall Barton said:
Alan said:
I have a unique problem:

1. Report consists of main report with a subreport in the detail section
2. Subreport is 2" wide
3. Main report is set to print 4 columns
4. Record source for sub report has four fields
a) Question Text
b) Answer Text
c) RecordID
d) ParentRecordID
5. Fields are located on the Subreport as follows:
[Question Text] [Answer Text]

Report works flawlessly and prints 4 colums of data, just as it should.
Everything lines up perfectly. The Question/Answer line in each column is
perfectly on line with the same question/answer line in the other columns.

THE PROBLEM:
I want the [Question Text] field to print in the left column only and not
repeat itself in each column

THIS IS WHAT I HAVE
[Question Text] [Answer Text] [Question Text] [Answer Text] [Question Text]
[Answer Text] etc

THIS IS WHAT I WANT
[Question Text] [Answer Text] [Answer Text] [Answer Text] [Answer
Click to expand...
Text]

You might be able to use a similar approach to KB 153052,
but from a subreport the code would have to check
Me.Parent.Left

The part about setting Me.NextRecord will break it if the
subreport has more than one record though

Does anyone know how to accomplish this? I cannot change from the Main
Report/Subreport format. It's too complicated to explain why.
Click to expand...

I'm not sure I'm convinced of that ;-)

The KB would definitly apply if you could do away with the
subreport. Are certain that you can not come up with a
record source query that Joins the main report data to the
subreport's data?
Click to expand...
 
Alan said:
I had looked at 153052 before I wrote to the group. I'm very doubtful that
method will work because what I'm doing is so different from the sample. As
far as getting rid of the subreport, for very complicated reasons that
doesn't look too promising either. But I will revisit 153052 again and see
if I can do something with the ideas in it. I like to tell clients that the
only limitations are their imagination. This may be one time when that's not
true.

I was hoping that maybe someone out there has done this all ready and could
get me off the hook. Thanks for trying.
Click to expand...

I was first going to suggest using two different subreports,
one for the questions and one for the answers (making one or
the other visible), but I couldn't figure out if the
subreport lists a bunch of records or just one. You must
have some kind of grouping to keep the questions and the
answers lined up together, but I'd just be guessing if I
tried to figure out how the report is organized. As I
understand you, it's probably too complicated to explain in
a posting, so about all I can do at this point is wish you
good luck.
--
Marsh
MVP [MS Access]

Alan said:
I have a unique problem:

1. Report consists of main report with a subreport in the detail section
2. Subreport is 2" wide
3. Main report is set to print 4 columns
4. Record source for sub report has four fields
a) Question Text
b) Answer Text
c) RecordID
d) ParentRecordID
5. Fields are located on the Subreport as follows:
[Question Text] [Answer Text]

Report works flawlessly and prints 4 colums of data, just as it should.
Everything lines up perfectly. The Question/Answer line in each column is
perfectly on line with the same question/answer line in the other columns.

THE PROBLEM:
I want the [Question Text] field to print in the left column only and not
repeat itself in each column

THIS IS WHAT I HAVE
[Question Text] [Answer Text] [Question Text] [Answer Text] [Question Text]
[Answer Text] etc

THIS IS WHAT I WANT
[Question Text] [Answer Text] [Answer Text] [Answer Text] [Answer
Click to expand...
Text]
Click to expand...
Marshall Barton said:
You might be able to use a similar approach to KB 153052,
but from a subreport the code would have to check
Me.Parent.Left

The part about setting Me.NextRecord will break it if the
subreport has more than one record though



I'm not sure I'm convinced of that ;-)

The KB would definitly apply if you could do away with the
subreport. Are certain that you can not come up with a
record source query that Joins the main report data to the
subreport's data?
Click to expand...
Click to expand...
 
Back
Top