custom report - bold formatting specific rows

P

Pleasanton

I have created a custom report, table and filter. I would like to change
which rows are formatted 'bold' based on specific criteria. Example - I'd
like to bold all fields with resource name = research. Other fields would be
standard text.

How can I change formatting of a row in a report based on specific criteria?
 
J

John

Pleasanton said:
I have created a custom report, table and filter. I would like to change
which rows are formatted 'bold' based on specific criteria. Example - I'd
like to bold all fields with resource name = research. Other fields would be
standard text.

How can I change formatting of a row in a report based on specific criteria?

Pleasanton,
You say you created a custom report but what type of report is it, Task,
Resource, crosstab, etc. Depending on the report type, you may be able
to use the Marked field to identify those rows that have the "research"
resource name. You then use the Text button in the Report window to set
the font for rows with the Marked field as "yes".

John
Project MVP
 
P

Pleasanton

Thanks John,

I'd created a custom task report. I see the 'text' option in the reports
dialogue box gives the option to change font (e.g. bold) for Marked Tasks
among other things. Follow up question. I use the field "flag6" for tasks
that are important to my project. Is there a way to get "flag6" to show in
the Text Styles menu so I can then use that field to apply bold fonts to
those rows?
 
J

John

Pleasanton said:
Thanks John,

I'd created a custom task report. I see the 'text' option in the reports
dialogue box gives the option to change font (e.g. bold) for Marked Tasks
among other things. Follow up question. I use the field "flag6" for tasks
that are important to my project. Is there a way to get "flag6" to show in
the Text Styles menu so I can then use that field to apply bold fonts to
those rows?
Pleasanton,
Unfortunately not. However, you can do what you want with some fairly
simple VBA.

John
Project MVP
 
P

Pleasanton

John,
VBA keeps coming up as an option for what I'd like to do. I don't know VBA.
Coudl you point me to a tutorial or examples of code?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top