Projets Reports Problems

Talk about anything that doesn't fit in the other catagories :) (and of course is about Group-Office)

Moderator: Developers

mbarroso
Posts: 16
Joined: Mon Oct 11, 2010 2:46 pm

Projets Reports Problems

Postby mbarroso » Fri Dec 03, 2010 11:55 am

Hello,
I'm trying to create reports from the projects.
I made some test projects, with sub items, time registration, tasks... When I finish, I tested the reports whith the types that I have by default in GO but I have not all the information that I needed. Any way, I sow in the reports created, no ours ( Units ) on the projects and I'm sure that I insert the Ours in the projects, aproove the ours as I saw in the manual etc...
I try to create new type of report template for pdf as I saw in the Wiki GO, but I have a lot of incognits, because I found a lot of variables that I do not understand what does it means.
I need help to create a report like this:

Name of Main Projetc :
Customer:
Manager of Main Projetc :
GO users involved in this project and the name of their own sub items related to the mai project( there are the managers of the sub items ):
Status of the Main project:
start date:
End date:
Total Days worked in the Main project:
Total Days programmed in the Main project:
Total Ours programmed for the Main Project:
Total Ours worked in the Main project:
Total Ours no-worked in the Main project:
Total Fees Internal:
Total Fees External:
Comments in the Main Project:

In the same report I would like to have also all the information for each sub item as follow:

Name of Main Projetc : / Name of sub items:
Manager of Main Projetc :
Manager of Sub items:
Status of the sub items:
start date of the sub items:
End date of the sub items:
Comments in the sub items:
Total Days programmed in the sub items:
Total Days worked in the sub items:
Total Ours programmed for the sub items:
Total Ours worked in the sub items:
Total Ours no-worked in the sub items:
Total Ours worked for each sub items:
Total Fees Internal of teh sub item:
Total Fees External of teh sub item:


Anybody can help me to create something like that? What I have to do to create a report whow I want? It's there some explanation about the variables to insert in the customer template of the reports?
Here you are an explmple that what I done but I haven't the results that I want:

{html}
<table border="0" cellpadding="2">
<tr>
<td colspan="2">
<span style="color:#7da541;font-size:12px">Informazione del Progetto {name}<br /></span>
</td>
</tr>
<tr>
<td width="170">Cliente:</td>
<td>{customer}</td>
</tr>
<tr>
<td width="170">Project Manager:</td>
<td >{user_name} </td>----> I have no results
</tr>
<tr>
<td width="170">Collaboratore:</td>
<td>{col_39}</td>-------->Custom field
</tr>
<tr>
<td width="170">Attività:</td>
<td>{col_33}</td>-------->Custom field
</tr>

<tr>
<td width="170">Ore:</td>
<td>{units_booked}</td>----> I have no results...
</tr>
<tr>
<td width="170">Stato:</td>
<td>{status_name}</td>
</tr>
<tr>
<td width="170">Inizio:</td>
<td>{start_time|from_unixtime:0}</td>
</tr>
<tr>
<td width="170">Fine:</td>
<td>{due_time|from_unixtime:0}</td>
</tr>
<tr>
<td width="170">
Descrizione:</td>
<td>
{description|to_html}
</td>
</tr>
</table>

<br /><br />
{/html}

{html}
<br /><br />
<span style="color:#7da541;font-size:12px;">Comments</span><br />
{/html}
{htmltable type="comments" border="1" cellpadding="2"}
{row}
<tr>
<td>{user_name} wrote on {ctime|from_unixdate}: <em>{comments|to_html}</em></td>
</tr>
{/row}
{norows}
<tr>
<td colspan="2">No comments were posted</td>
</tr>
{/norows}
{/htmltable}

{html}
<br /><br />
<span style="color:#7da541;font-size:12px;">Timeregistration</span><br />
{/html}

{htmltable type="detailed_hours_per_user" border="1" cellpadding="2" width="535"}
{thead}
<tr style="font-weight:bold;">
<td width="100">Employee:</td>
<td colspan="2" width="435">{user_name}</td>
</tr>
<tr>
<td width="100">Date</td>
<td width="235">Description</td>
<td width="100">Units</td>
<td width="100">Amount</td>
</tr>
{/thead}

{row}
<tr nobr="true">
<td width="100">{date|from_unixtime:0}</td>
<td width="235">{comments}</td>
<td align="right" width="100">{units|number:2}</td>
<td align="right" width="100">{amount|number:2}</td>
</tr>
{/row}

{sum}
<tr nobr="true" style="font-weight:bold">
<td colspan="2" width="335">Total:</td>
<td align="right" width="100">{total_units|number:2}</td>
<td align="right" width="100">{total_amount|number:2}</td>
</tr>
{/sum}

{/htmltable}


{html}
<br /><br />
<span style="color:#7da541;font-size:12px">Timeregistration</span><br />
{/html}

{htmltable type="detailed_hours_per_user" border="1" cellpadding="2" width="535"}
{thead}
<tr style="font-weight:bold;">
<td width="100">Employee:</td>
<td colspan="2" width="435">{user_name}</td>
</tr>
<tr>
<td width="100">Date</td>
<td width="235">Description</td>
<td width="100">Units</td>
<td width="100">Amount</td>
</tr>
{/thead}

{row}
<tr nobr="true">
<td width="100">{date|from_unixtime:0}</td>
<td width="235">{comments}</td>
<td align="right" width="100">{units|number:2}</td>
<td align="right" width="100">{amount|number:2}</td>
</tr>
{/row}

{sum}
<tr nobr="true" style="font-weight:bold">
<td colspan="2" width="335">Total:</td>
<td align="right" width="100">{total_units|number:2}</td>
<td align="right" width="100">{total_amount|number:2}</td>
</tr>
{/sum}

{/htmltable}

Thanks a lot in advance for you help.
Regards
mschering
Site Admin
Site Admin
Posts: 8339
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: Projets Reports Problems

Postby mschering » Wed Dec 08, 2010 3:32 pm

We can create the template for you if you send us an example PDF. Based on that we can make an offer of implementing it.
Best regards,

Merijn Schering
Intermesh
mbarroso
Posts: 16
Joined: Mon Oct 11, 2010 2:46 pm

Re: Projets Reports Problems

Postby mbarroso » Fri Dec 10, 2010 9:40 am

Hello,
Sorry for the delay of my reply.
In attach you can see an example of pdf that I like to create when I do the project report.
Could you help me to obtain something like that?
Thanks a lot for your help.
regards
Attachments
Report Example.pdf
(55.3 KiB) Downloaded 585 times
mbarroso
Posts: 16
Joined: Mon Oct 11, 2010 2:46 pm

Re: Projets Reports Problems

Postby mbarroso » Mon Dec 13, 2010 11:37 am

Anybody can help me???
Thanks a lo t n advance
Regards

Who is online

Users browsing this forum: No registered users and 2 guests