Calender in Pay roll report

Yahoo Archive
1

Hhhmmm…interesting…something to think about.

Thanks, Steve!  Manasa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, December 16, 2014 7:38 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Calender in Pay roll report

 

 

In a BAQ it would be the first table you select.  You then link the next table or tables to it with an outer join.

 

What I did was to set up a UD table with all the dates.  I then linked Sales Orders and Invoices to it.  What this gave me was each row of data had either sales order data in it, Invoice data, or nothing at all.  I then created a complicated Crystal Report that listed all the days of the month along with totals for sales orders and Invoices for each day.

 

Steven G.

 

On Monday, December 15, 2014 2:35 PM, "Manasa Reddy mreddy@... [vantage]" <vantage@yahoogroups.com> wrote:

 

 

Steve,

So when you say you use this table as the “top” table….how are you doing that exactly?

I ask because we want to create a time and attendance program to force a point system Kronos uses.  In other words I want to get rid of Kronos by re-developing it somehow in Epicor.

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, December 15, 2014 8:05 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Calender in Pay roll report

 

 

A trick I use is to populate a UD table with dates for the next 10 years.  I then use checkboxes in the UD table to mark workdays, holidays, etc.  I then make the UD table the "top" table for my other tables.  This way, I get a date even if there are no other records with that date linked to it.  Its kind of a brute force method, but it works.

 

Steven G.

 

On Friday, December 12, 2014 4:53 PM, "zuhaib_akhtar@... [vantage]" <vantage@yahoogroups.com> wrote:

 

 

Hello All,

I am using Vantage 803 version and created Time and Attendance report using ODBC crystal report where I grouped by-Clock_ID to display time their times.

The issue I am having is if an employee did not punch in/out for a day, it doesnt display anything(skips the day).

Is there any system calender that I can use to force all working days to be displayed and then row can show a blank in front of any missed clock-in.

 

P.S: I have tried using ProdCal but it does not pull any date into the report.

 

 

 

 

 

2

Hello All,

I am using Vantage 803 version and created Time and Attendance report using ODBC crystal report where I grouped by-Clock_ID to display time their times.

The issue I am having is if an employee did not punch in/out for a day, it doesnt display anything(skips the day).

Is there any system calender that I can use to force all working days to be displayed and then row can show a blank in front of any missed clock-in.


P.S: I have tried using ProdCal but it does not pull any date into the report.




3
A trick I use is to populate a UD table with dates for the next 10 years.  I then use checkboxes in the UD table to mark workdays, holidays, etc.  I then make the UD table the "top" table for my other tables.  This way, I get a date even if there are no other records with that date linked to it.  Its kind of a brute force method, but it works.

Steven G.


On Friday, December 12, 2014 4:53 PM, "zuhaib_akhtar@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-1654965091yiv4849921228ygrp-text">
  
  
  <div></div><div><span>Hello All,</span></div><div><span>I am using Vantage 803 version and created <u>Time and Attendance report</u> using ODBC crystal report where I grouped by-Clock_ID to display time their times.</span></div><div><span>The issue I am having is if an employee did not punch in/out for a day, it doesnt display anything(skips the day).</span></div><div><span>Is there any system calender that I can use to force all working days to be displayed and then row can show a blank in front of any missed clock-in.</span></div><div><span><br clear="none"></span></div><div><span>P.S:&nbsp;</span><span style="word-spacing:normal;">I have tried using ProdCal but it does not pull any date into the report.</span></div><div><span><br clear="none"></span></div><div><span><br clear="none"></span></div><div><span><br clear="none"></span></div>

</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228 -- #ygrps-yiv-1654965091yiv4849921228ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-mkp #ygrps-yiv-1654965091yiv4849921228hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-mkp #ygrps-yiv-1654965091yiv4849921228ads {
margin-bottom:10px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-mkp .ygrps-yiv-1654965091yiv4849921228ad {
padding:0 0;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-mkp .ygrps-yiv-1654965091yiv4849921228ad p {
margin:0;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-mkp .ygrps-yiv-1654965091yiv4849921228ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-sponsor #ygrps-yiv-1654965091yiv4849921228ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-sponsor #ygrps-yiv-1654965091yiv4849921228ygrp-lc #ygrps-yiv-1654965091yiv4849921228hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-sponsor #ygrps-yiv-1654965091yiv4849921228ygrp-lc .ygrps-yiv-1654965091yiv4849921228ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228activity span {
font-weight:700;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228activity span span {
color:#ff7900;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228activity span .ygrps-yiv-1654965091yiv4849921228underline {
text-decoration:underline;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 .ygrps-yiv-1654965091yiv4849921228attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 .ygrps-yiv-1654965091yiv4849921228attach div a {
text-decoration:none;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 .ygrps-yiv-1654965091yiv4849921228attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 .ygrps-yiv-1654965091yiv4849921228attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 .ygrps-yiv-1654965091yiv4849921228attach label a {
text-decoration:none;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 .ygrps-yiv-1654965091yiv4849921228bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 .ygrps-yiv-1654965091yiv4849921228bold a {
text-decoration:none;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 dd.ygrps-yiv-1654965091yiv4849921228last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 dd.ygrps-yiv-1654965091yiv4849921228last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 dd.ygrps-yiv-1654965091yiv4849921228last p span.ygrps-yiv-1654965091yiv4849921228yshortcuts {
margin-right:0;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 div.ygrps-yiv-1654965091yiv4849921228attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 div.ygrps-yiv-1654965091yiv4849921228attach-table {
width:400px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 div.ygrps-yiv-1654965091yiv4849921228file-title a, #ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 div.ygrps-yiv-1654965091yiv4849921228file-title a:active, #ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 div.ygrps-yiv-1654965091yiv4849921228file-title a:hover, #ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 div.ygrps-yiv-1654965091yiv4849921228file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 div.ygrps-yiv-1654965091yiv4849921228photo-title a, #ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 div.ygrps-yiv-1654965091yiv4849921228photo-title a:active, #ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 div.ygrps-yiv-1654965091yiv4849921228photo-title a:hover, #ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 div.ygrps-yiv-1654965091yiv4849921228photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 div#ygrps-yiv-1654965091yiv4849921228ygrp-mlmsg #ygrps-yiv-1654965091yiv4849921228ygrp-msg p a span.ygrps-yiv-1654965091yiv4849921228yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 .ygrps-yiv-1654965091yiv4849921228green {
color:#628c2a;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 .ygrps-yiv-1654965091yiv4849921228MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 o {
font-size:0;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228photos div {
float:left;width:72px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228reco-category {
font-size:77%;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228reco-desc {
font-size:77%;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 .ygrps-yiv-1654965091yiv4849921228replbq {
margin:4px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-mlmsg select, #ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 input, #ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-mlmsg pre, #ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 code {
font:115% monospace;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-mlmsg #ygrps-yiv-1654965091yiv4849921228logo {
padding-bottom:10px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-msg p#ygrps-yiv-1654965091yiv4849921228attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-reco #ygrps-yiv-1654965091yiv4849921228reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-sponsor #ygrps-yiv-1654965091yiv4849921228ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-sponsor #ygrps-yiv-1654965091yiv4849921228ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-sponsor #ygrps-yiv-1654965091yiv4849921228ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1654965091 #ygrps-yiv-1654965091yiv4849921228 #ygrps-yiv-1654965091yiv4849921228ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1654965091



4

Steve,

So when you say you use this table as the “top” table….how are you doing that exactly?

I ask because we want to create a time and attendance program to force a point system Kronos uses.  In other words I want to get rid of Kronos by re-developing it somehow in Epicor.

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, December 15, 2014 8:05 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Calender in Pay roll report

 

 

A trick I use is to populate a UD table with dates for the next 10 years.  I then use checkboxes in the UD table to mark workdays, holidays, etc.  I then make the UD table the "top" table for my other tables.  This way, I get a date even if there are no other records with that date linked to it.  Its kind of a brute force method, but it works.

 

Steven G.

 

On Friday, December 12, 2014 4:53 PM, "zuhaib_akhtar@... [vantage]" <vantage@yahoogroups.com> wrote:

 

 

Hello All,

I am using Vantage 803 version and created Time and Attendance report using ODBC crystal report where I grouped by-Clock_ID to display time their times.

The issue I am having is if an employee did not punch in/out for a day, it doesnt display anything(skips the day).

Is there any system calender that I can use to force all working days to be displayed and then row can show a blank in front of any missed clock-in.

 

P.S: I have tried using ProdCal but it does not pull any date into the report.

 

 

 

 

5
That will work for me.Thanks for the reply, Steve.

Not sure if we can create UD tables in Version 8.03, if yes, can you please point me to the direction for setting up a UD table.
Thanks again
ZR
6
I figured out the way to do...very good solution.
Thanks again Steve.

7
In a BAQ it would be the first table you select.  You then link the next table or tables to it with an outer join.

What I did was to set up a UD table with all the dates.  I then linked Sales Orders and Invoices to it.  What this gave me was each row of data had either sales order data in it, Invoice data, or nothing at all.  I then created a complicated Crystal Report that listed all the days of the month along with totals for sales orders and Invoices for each day.

Steven G.


On Monday, December 15, 2014 2:35 PM, "Manasa Reddy mreddy@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-886181570yiv6241458795ygrp-text">
  
  
  <div>
Steve,
So when you say you use this table as the “top” table….how are you doing that exactly?
I ask because we want to create a time and attendance program to force a point system Kronos uses.  In other words I want to get rid of Kronos by re-developing it somehow in Epicor.
Manasa
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, December 15, 2014 8:05 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Calender in Pay roll report
 
 
A trick I use is to populate a UD table with dates for the next 10 years.  I then use checkboxes in the UD table to mark workdays, holidays, etc.  I then make the UD table the "top" table for my other tables.  This way, I get a date even if there are no other records with that date linked to it.  Its kind of a brute force method, but it works.
 
Steven G.
 
On Friday, December 12, 2014 4:53 PM, "zuhaib_akhtar@... [vantage]" <vantage@yahoogroups.com> wrote:
 
 
Hello All,
I am using Vantage 803 version and created Time and Attendance report using ODBC crystal report where I grouped by-Clock_ID to display time their times.
The issue I am having is if an employee did not punch in/out for a day, it doesnt display anything(skips the day).
Is there any system calender that I can use to force all working days to be displayed and then row can show a blank in front of any missed clock-in.
 
P.S: I have tried using ProdCal but it does not pull any date into the report.
 
 
 
 
</div>
 


<div class="ygrps-yiv-886181570yiv6241458795yqt4188807058" id="ygrps-yiv-886181570yiv6241458795yqt13368"><div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795 -- #ygrps-yiv-886181570yiv6241458795ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-mkp #ygrps-yiv-886181570yiv6241458795hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-mkp #ygrps-yiv-886181570yiv6241458795ads {
margin-bottom:10px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-mkp .ygrps-yiv-886181570yiv6241458795ad {
padding:0 0;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-mkp .ygrps-yiv-886181570yiv6241458795ad p {
margin:0;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-mkp .ygrps-yiv-886181570yiv6241458795ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-sponsor #ygrps-yiv-886181570yiv6241458795ygrp-lc {
font-family:Arial;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-sponsor #ygrps-yiv-886181570yiv6241458795ygrp-lc #ygrps-yiv-886181570yiv6241458795hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-sponsor #ygrps-yiv-886181570yiv6241458795ygrp-lc .ygrps-yiv-886181570yiv6241458795ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795activity span {
font-weight:700;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795activity span span {
color:#ff7900;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795activity span .ygrps-yiv-886181570yiv6241458795underline {
text-decoration:underline;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 .ygrps-yiv-886181570yiv6241458795attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 .ygrps-yiv-886181570yiv6241458795attach div a {
text-decoration:none;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 .ygrps-yiv-886181570yiv6241458795attach img {
border:none;padding-right:5px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 .ygrps-yiv-886181570yiv6241458795attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 .ygrps-yiv-886181570yiv6241458795attach label a {
text-decoration:none;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 .ygrps-yiv-886181570yiv6241458795bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 .ygrps-yiv-886181570yiv6241458795bold a {
text-decoration:none;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 dd.ygrps-yiv-886181570yiv6241458795last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 dd.ygrps-yiv-886181570yiv6241458795last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 dd.ygrps-yiv-886181570yiv6241458795last p span.ygrps-yiv-886181570yiv6241458795yshortcuts {
margin-right:0;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 div.ygrps-yiv-886181570yiv6241458795attach-table div div a {
text-decoration:none;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 div.ygrps-yiv-886181570yiv6241458795attach-table {
width:400px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 div.ygrps-yiv-886181570yiv6241458795file-title a, #ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 div.ygrps-yiv-886181570yiv6241458795file-title a:active, #ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 div.ygrps-yiv-886181570yiv6241458795file-title a:hover, #ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 div.ygrps-yiv-886181570yiv6241458795file-title a:visited {
text-decoration:none;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 div.ygrps-yiv-886181570yiv6241458795photo-title a, #ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 div.ygrps-yiv-886181570yiv6241458795photo-title a:active, #ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 div.ygrps-yiv-886181570yiv6241458795photo-title a:hover, #ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 div.ygrps-yiv-886181570yiv6241458795photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 div#ygrps-yiv-886181570yiv6241458795ygrp-mlmsg #ygrps-yiv-886181570yiv6241458795ygrp-msg p a span.ygrps-yiv-886181570yiv6241458795yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 .ygrps-yiv-886181570yiv6241458795green {
color:#628c2a;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 .ygrps-yiv-886181570yiv6241458795MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 o {
font-size:0;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795photos div {
float:left;width:72px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795reco-category {
font-size:77%;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795reco-desc {
font-size:77%;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 .ygrps-yiv-886181570yiv6241458795replbq {
margin:4px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-mlmsg select, #ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 input, #ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-mlmsg pre, #ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 code {
font:115% monospace;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-mlmsg #ygrps-yiv-886181570yiv6241458795logo {
padding-bottom:10px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-msg p#ygrps-yiv-886181570yiv6241458795attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-reco #ygrps-yiv-886181570yiv6241458795reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-sponsor #ygrps-yiv-886181570yiv6241458795ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-sponsor #ygrps-yiv-886181570yiv6241458795ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-sponsor #ygrps-yiv-886181570yiv6241458795ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-text {
font-family:Georgia;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-text tt {
font-size:120%;}

#ygrps-yiv-886181570 #ygrps-yiv-886181570yiv6241458795 #ygrps-yiv-886181570yiv6241458795ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-886181570