reprots

[Patrick Stubbin]

I have a sub query that is the underlying input for a sub report imbedded in
the main body of a report. The query itself returns data that has multiple
instances of some fields, (ie duplicate value for some fields in a record but
not all fields).
I have created the sub report with the headings for each field and the data
fields in the 'detail' section, I wish to ensure that each set of records
that are grouped by the first field appear together in a column as a group
and then then next group displayed in the next field across and so on.

No amount of fiddling with the newrowcol detail or page setup allows me to
get it right. it is proving frustrating. the one time i got it to work i had
it set up as printed down then across, but this would not work when imbedded
into the main report due to the page set of the sub report and that of main
report being different i think. I hide duplicate values of the first field

included below is example of how it should appear, but i just cant get it to

field1 field2 field3 field1 field2 field3

xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx


xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx

the above just wont work for me, please any thoughts on how to get it to work

 

[Duane Hookom]

Your first statement about having a "sub query" as the underlying input for
a sub report might be scaring some responders off. A "subquery" is a select
statement contained in another select statement. The use of input isn't the
correct term either. I think you mean the Record Source of the sub report.

Besides all that, I am picturing your data/records as scheduled events that
you want to appear under a date heading across in a subreport. Is this
perception close to what you want?

 

[Patrick Stubbin]

yes
--
Regards


Patrick Stubbin

Your first statement about having a "sub query" as the underlying input for
a sub report might be scaring some responders off. A "subquery" is a select
statement contained in another select statement. The use of input isn't the
correct term either. I think you mean the Record Source of the sub report.

Besides all that, I am picturing your data/records as scheduled events that
you want to appear under a date heading across in a subreport. Is this
perception close to what you want?

 

[Duane Hookom]

You can create a multiple column main report with copies of a subreport in
the detail section. For instance, if you wanted a report of supervisors
across a report with their subordinates listed under them:
John Mary Bill
====== ====== ======
Gary Mark Tina
Sam Eric Joe
Pete Sally
Jake

PARTIAL DATA
===================
EmpID FirstName SupID
1 John
2 Mary
3 Sam 1
4 Gary 1
5 Eric 2
.....
You could create a main report that is three columns wide and displays just
the supervisors. Then create a small subreport that is based on all
employees. Add the subreport under the supervisor name and set the Link
Master to the EmpID and the Link Child to SupID.