tif file report per resource

tif file report per resource

Basically I want to generate a report build on task usage. The report
will generate tasks for each resource within a date range. The trick
here is I want to generate a separate tif file for each resource. I
was able to create a page break for resources but that gives me only
one tif file. Is there a way to create a report which generates a
separate tif file per resource? Using macros or page break?

Thanks!

date: Mon, 25 Aug 2008 11:55:22 -0700 (PDT) author: Yohan

RE: tif file report per resource

Sounds like some VBA is in order... but yes, that could be done with some 
effort
-- 
If this post was helpful, please consider rating it.

Jim

Check out my new blog for more information:
http://www.msprojectblog.com



"Yohan" wrote:

> Basically I want to generate a report build on task usage. The report
> will generate tasks for each resource within a date range. The trick
> here is I want to generate a separate tif file for each resource. I
> was able to create a page break for resources but that gives me only
> one tif file. Is there a way to create a report which generates a
> separate tif file per resource? Using macros or page break?
> 
> Thanks!
>

date: Mon, 25 Aug 2008 12:46:21 -0700 author: Jim Aksel

Re: tif file report per resource

Hello Yohan,

Have you tried filtering the Task Usage view using the "Using Resource 
in date range" filter and then creating the tiff file?

I hope this helps.  Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information 
about Microsoft Project

"Yohan"  wrote in message 
news:e8319b89-738d-41a9-95e3-00e6bbd4dab1@i20g2000prf.googlegroups.com...
> Basically I want to generate a report build on task usage. The 
> report
> will generate tasks for each resource within a date range. The trick
> here is I want to generate a separate tif file for each resource. I
> was able to create a page break for resources but that gives me only
> one tif file. Is there a way to create a report which generates a
> separate tif file per resource? Using macros or page break?
>
> Thanks!

date: Mon, 25 Aug 2008 16:01:10 -0400 author: JulieS

Re: tif file report per resource

On Aug 25, 1:01 pm, "JulieS"  wrote:
> Hello Yohan,
>
> Have you tried filtering the Task Usage view using the "Using Resource
> in date range" filter and then creating the tiff file?
>
> I hope this helps.  Let us know how you get along.
>
> Julie
> Project MVP
>
> Visithttp://project.mvps.org/for the FAQs and additional information
> about Microsoft Project
>
> "Yohan"  wrote in message
>
> news:e8319b89-738d-41a9-95e3-00e6bbd4dab1@i20g2000prf.googlegroups.com...
>
>
>
> > Basically I want to generate a report build on task usage. The
> > report
> > will generate tasks for each resource within a date range. The trick
> > here is I want to generate a separate tif file for each resource. I
> > was able to create a page break for resources but that gives me only
> > one tif file. Is there a way to create a report which generates a
> > separate tif file per resource? Using macros or page break?
>
> > Thanks!- Hide quoted text -
>
> - Show quoted text -

Thanks a lot. That is exactly what I did. but I need to generate a
seprate tiffor each resource. I did use page break per resource. It
works, but it generates only one page.

date: Mon, 25 Aug 2008 13:13:16 -0700 (PDT) author: Yohan

Re: tif file report per resource

On Aug 25, 1:01 pm, "JulieS"  wrote:
>> Hello Yohan,
>> Have you tried filtering the Task Usage view using the "Using 
>> Resource
>> in date range" filter and then creating the tiff file?
<snip>

"Yohan"  wrote in message 
news:f90aeb57-f5ae-4df4-8755-f6a7517e30ff@b38g2000prf.googlegroups.com...

>Thanks a lot. That is exactly what I did. but I need to generate a
>seprate tiffor each resource. I did use page break per resource. It
>works, but it generates only one page.

You're welcome Yohan.  I'm not sure I follow though, if you filtered 
the Task Usage view, you should only be seeing data for one resource 
at a time. You could then generate the *.tiff file.  You'd then remove 
the filter, filter for a different resource, and create a new *.tiff 
file and so on.

As Jim noted, without some VBA to automate the process, it would be 
manual.  You might try recording a macro of the process and then 
playing with the code as an option.  If you want to pursue the VBA 
route, I suggest posting your question to the developer newsgroup. 
(microsoft.public.project.developer).

Julie

date: Mon, 25 Aug 2008 16:25:45 -0400 author: JulieS

Re: tif file report per resource

On Aug 25, 1:25 pm, "JulieS"  wrote:
> On Aug 25, 1:01 pm, "JulieS"  wrote:>> Hello Yohan,
> >> Have you tried filtering the Task Usage view using the "Using
> >> Resource
> >> in date range" filter and then creating the tiff file?
>
> <snip>
>
> "Yohan"  wrote in message
>
> news:f90aeb57-f5ae-4df4-8755-f6a7517e30ff@b38g2000prf.googlegroups.com...
>
> >Thanks a lot. That is exactly what I did. but I need to generate a
> >seprate tiffor each resource. I did use page break per resource. It
> >works, but it generates only one page.
>
> You're welcome Yohan.  I'm not sure I follow though, if you filtered
> the Task Usage view, you should only be seeing data for one resource
> at a time. You could then generate the *.tiff file.  You'd then remove
> the filter, filter for a different resource, and create a new *.tiff
> file and so on.
>
> As Jim noted, without some VBA to automate the process, it would be
> manual.  You might try recording a macro of the process and then
> playing with the code as an option.  If you want to pursue the VBA
> route, I suggest posting your question to the developer newsgroup.
> (microsoft.public.project.developer).
>
> Julie

Thanks Julie, I need to generate individual tif files for each
resource "100 resources". It takes a lot of time to generate these
files individually. I was thinking of a way to automate this process.
I did post it in the developer newsgroup.

date: Mon, 25 Aug 2008 13:45:52 -0700 (PDT) author: Yohan

Re: tif file report per resource

"Yohan"  wrote in message 
news:34178ef9-452b-498d-963b-30259ebafcab@1g2000pre.googlegroups.com...
<snip>
Thanks Julie, I need to generate individual tif files for each
resource "100 resources". It takes a lot of time to generate these
files individually. I was thinking of a way to automate this process.
I did post it in the developer newsgroup.

You're welcome Yohan.  Good luck.

Julie

date: Mon, 25 Aug 2008 19:46:27 -0400 author: JulieS