Unobtrusive Place To Put Report TItle and a List?

  • Thread starter Thread starter (PeteCresswell)
  • Start date Start date
P

(PeteCresswell)

I just wrote some code to convert render an MS Access report into a
Excel 2010 spreadsheet.

Right now, the first row of the sheet is the report's title and, over to
the right of the "real" data, is a list of funds covered by the report.

Seems to me like life would be easier for users if that title weren't
trashing up the first row - so there would just be column headers and
data like everybody's used to working with - and they could see the fund
list easily (now, because of the number of columns, it's off-screen for
most monitors).

But the title and the fund list have to go somewhere.

Only thing I can think of is one or two large yellow "Comments" box(es)
linked to one of the top cells.

Is there another alternative (besides laying in a bitmap)?
 
I just wrote some code to convert render an MS Access report into a
Excel 2010 spreadsheet.

Right now, the first row of the sheet is the report's title and, over to
the right of the "real" data, is a list of funds covered by the report.

Seems to me like life would be easier for users if that title weren't
trashing up the first row - so there would just be column headers and
data like everybody's used to working with - and they could see the fund
list easily (now, because of the number of columns, it's off-screen for
most monitors).

But the title and the fund list have to go somewhere.

Only thing I can think of is one or two large yellow "Comments" box(es)
linked to one of the top cells.

Is there another alternative (besides laying in a bitmap)?
Click to expand...

You can store values in a "Name". That would work well for the title,
but a list can only be entered as a string of delimited items.
 
On Sat, 28 Jun 2014 16:55:13 +1000, "Michael Bednarek"
You can store values in a "Name". That would work well for the title,
but a list can only be entered as a string of delimited items.
Click to expand...

You could use a text box for the title and start the spreadsheet data a
few rows below row 1 to give it space.
HTH
JJ
 
Per John Jones:
You could use a text box for the title and start the spreadsheet data a
few rows below row 1 to give it space.
Click to expand...

That's what I'm doing now - and throwing in a Freeze Panes to keep the
col headers visible.

But users are used to clicking entire columns to do things like Cut,
Copy, Paste, Format Cells, and Sort.
 
<FWIW>
I'm liking the idea of the data on one sheet with headings (ergo
fieldnames) and so I'd probably put the other report detail on a
separate sheet OR in a modeless userform.
 
You can store values in a "Name". That would work well for the title,
but a list can only be entered as a string of delimited items.
Click to expand...
<FWIW>
You can store a delimited string in a 'Name', just its length will be
limited to the max characters allowed!
 
Back
Top