Put heading in separate column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a multi-column subreport that I am running to make a footer. The
footer needs to have consultants listed, each with their specialty and
address. The consultants need to run horizontally across the page.

It's working pretty well, with each new consultant in a new column, BUT

In every case, my first entry has to be our firm.

If I put our firm's information in the report header, it comes out with that
on top of the first column's detail section.

If I were to put it into the detail section, it would repeat before every
consultant.

I could change the data in the table so that our firm was listed as a
consultant on every project, but that seems like a really clumsy way to fix
this problem, and an issue with data normalization.

Is there any way to force a column break after the header? So that the
first detail section would print parallel to it?

Thanks
 
r. howell said:
I have a multi-column subreport that I am running to make a footer. The
footer needs to have consultants listed, each with their specialty and
address. The consultants need to run horizontally across the page.

It's working pretty well, with each new consultant in a new column, BUT

In every case, my first entry has to be our firm.

If I put our firm's information in the report header, it comes out with that
on top of the first column's detail section.

If I were to put it into the detail section, it would repeat before every
consultant.

I could change the data in the table so that our firm was listed as a
consultant on every project, but that seems like a really clumsy way to fix
this problem, and an issue with data normalization.

Is there any way to force a column break after the header? So that the
first detail section would print parallel to it?
Click to expand...


It would be best to add the data for your firm to the
multicolumn subreport's record source. If you have an entry
for you firm in the table of consultants, you can use a
UNION query to add it to the other data for the report.

SELECT 1 As SortOrder, consutant, specialty, address
FROM Consultants INNER JOIN contract
ON whatever
UNION ALL
SELECT 0, consutant, specialty, address
FROM Consultants
WHERE consultant = "yourfirm"

Then set the subreports top level sorting to the SortOrder
field.
 
Back
Top