Re: Need to Create Better Tracking Gantt Reports!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jason (jason.mann_at_axa-insurance.co.uk)
Date: 09/13/04 

Date: Mon, 13 Sep 2004 03:13:41 -0700

Jack,
(have sent you seperate email with Excel attachment)

Thank you for your reply. I attach a copy of the format
of report (In excel) that I
need to mimic so that I can try and automate part of my
month end reporting
process.

The bit I have most difficulty in translating from MS
Project is in the example 'activity
19' on the attached. This has multiple deliveries (key
milestones which I have
flagged in MS Project) that I have to show in a
single 'bar'. The best I have got so
far is a yellow summary bar for the activity with the key
milestones shown as a black
diamond underneath this bar. This is no good because I
end up with 6 lines of
information for the summary bar followed by each
milestone. To achieve my goal I would need some way of
combining the summary
bar with the key milestones so that they are on the same
single line? If you have any
ideas it would be most helpful.

Can I get Years, Quarters and Months at the top? I can
only seem to get two to
display e.g. quarters and months.

Is there a way of changing the background to a task name?
e.g. I want 'Programme
Name' to be white text with Blue background? There doesn't
seem to be an option
for this.

I hope this is a bit clearer?
Regards
Jason

>-----Original Message-----
>
>"Jason" <jason.mann@axa-insurance.co.uk> wrote in message
>news:8faa01c49682$2a748250$a301280a@phx.gbl...
>> I need to produce reports for Senior Mgmt but am having
>> problems getting the required level of professional-
>> looking reports!
>>
>> I would like to produce a Gantt style report showing
each
>> Phase of work and then each Activity. For each activity
I
>> want a single bar. Each bar needs to be coloured yellow
>> with work completed (Percentage work complete)in blue.
>> I need to show the activity start and finish. I want to
>> show baseline and final 'key' milestones (I have flagged
>> these). I can create a view that is similar to what I am
>> looking for but I want to 'fine tune' and manipulate the
>> data further. I get to a certain point but I am now out
of
>> formatting options!
>
>What do you mean that you are out of formatting options?
>You are allowed 40 different bar styles.
>What you are describing can be easily created with less
than 10 of these.
>
>Maybe if you can describe your problem futher it will be
possible to find a
>solution.
>
>-Jack
>
>
>.
>

Relevant Pages

  • tracking report. FAO JackD. or anyone else that can help
    ... Project into a report is where I have multiple deliveries ... (key milestones which I have flagged in MS Project) ... have to show in a single 'bar' on a report. ... >What do you mean that you are out of formatting options? ...
    (microsoft.public.project2000)
  • Re: Merging with Access queries - Multiple
    ... Access Report to an .RTF file. ... > of the loss of formatting, fonts, etc.). ... Word can really only use a "flat file" as the data source. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Maintain Formatting during copy paste
    ... Microsoft MVP (Word) ... "Suzanne S. Barnhill" wrote: ... report, if the document is blank the paste works fine, and no she does ... special formatting as she types. ...
    (microsoft.public.word.tables)
  • RE: How do I make SQL within Code become report source
    ... When I took the formatting off the table, ... "Kenny A." ... There is no need to set the SQL of report because you want to change the ... You will change the SQL of the report if you want to change the Source table ...
    (microsoft.public.access.reports)
  • Re: Access 2.0 report
    ... I also verified from the properties that Field24 is correct. ... Is it possible that there two formatting issues butting heads within the ... Event then Code Builder and I then verify that it is for the Detail1 ... report. ...
    (microsoft.public.access.reports)