Report Format Question

  • Thread starter Thread starter Zane
  • Start date Start date
Z

Zane

I am trying to design a report to be exported into
excel. One thing I would like is the form to look like a
table (borders around everything). The second thing,
probably much more difficult than the first is trying to
get the background color of a cell to correspond with
that fields status. In other words for each record there
is a status color associated with it. When I send the
report to excel I would like the background color of that
cell to be the status color associated with that record.
Any help with either of these question would be greatly
appreciated. Thanks
Zane
 
To show a report with the borders around each field,
simply set the border color to black and place the
textboxes directly against each other. Make sure to set
the can shrink property for the detail band to yes (also
applies to the other bands if you wish to include them.
You cna also set the conditional format for each text box
to show a certain color (from the format dropdown menu).
I am not sure that this conditional format will transfer
to excel when you export.
Good luck and hope this helps.
Fons
 
Back
Top