Report builder question

Yahoo Archive
1
Thanks! This should work great!

Jasper

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, August 02, 2007 11:24 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report builder question



This is a rolling 12 month report right?
So perhaps....
Month0 = CurMonth
Month1 = IIF(CurMonth + 1 < 13,CurMonth + 1,CurMonth + 1 - 12)
Month2 = IIF(CurMonth + 2 < 13,CurMonth + 2,CurMonth + 2 - 12)
etc....
Then fill each bucket according to if MonthX = DueMonth

Unless I am missing something.

As for the field name quesiton....beats me. Always wondered about that. I have a monthly bucket report with fields JanSales, FebSales, etc... all created in order at the same time....but NovSales and DecSales are seperated from the list by several other fields created much later. RB is just weird like that sometimes. My hunch is how things get stored in arrays in the PRL file.

-Todd C.

________________________________
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On Behalf Of Jasper Recto
Sent: Thursday, August 02, 2007 9:57 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Report builder question

I am trying to create a report builder report that buckets the sales in each month just like the sales backlog report.

I am using this logic:
If the current month = due month > place amount in this months bucket (1st month)
If the current month + 1 = due month > place this amount in next months bucket (2nd month)
If the current month + 2 = due month > place the amount in the 3rd month
etc....

The problem that I am having is the time frame between December and January because the month goes from 12 back to 1.

So, if I ran my report now, the current month is August (8). January would be 5 months from now.
The January bucket logic would look like this:

If the current month + 5 = due month > place the amount in the 6th month

The problem is the due month for January is now back to (1) so the logic fails.

Does anybody have any ideas how to get around this. Is there a better logical way to approach this?

Thanks,
Jasper

[Non-text portions of this message have been removed]

________________________________
The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.

Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.

For more information please visit www.harveyvogel.com

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
2
I'm writing a basic report for employees that clocked on to indirect labor
code on a daily basis. I am using the labor header and labor detail table
and want to link back to the empbasic table it insert there relevant name on
the report. There seem to be no way of linking the labor header table to the
empbasis table.

I thought I would be able to link the employee No in the labor header to
the employee No in the empbasic table and then insert there name on the
report from the empbasic table but in the empbasic table there is no
employee No.

Any tips would be appreciated...

Thanks
3
Mark,
If I recall correctly, this might be the one exception where the Field
Name for an indexed field does not match between two tables. Go ahead and
link to the EmpID on the empbasic table and I think it will work for you.

Troy Funte
Liberty Electronics

-----Original Message-----
From: Mark Howard [mailto:mhoward@...]
Sent: Sunday, November 02, 2003 11:44 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report builder question



I'm writing a basic report for employees that clocked on to indirect labor
code on a daily basis. I am using the labor header and labor detail table
and want to link back to the empbasic table it insert there relevant name
on
the report. There seem to be no way of linking the labor header table to
the
empbasis table.

I thought I would be able to link the employee No in the labor header to
the employee No in the empbasic table and then insert there name on the
report from the empbasic table but in the empbasic table there is no
employee No.

Any tips would be appreciated...

Thanks


Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
4
Troy,

You recall correctly. This is indeed the case here.

Mike

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Sunday, November 02, 2003 8:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report builder question


Mark,
If I recall correctly, this might be the one exception where the Field
Name for an indexed field does not match between two tables. Go ahead and
link to the EmpID on the empbasic table and I think it will work for you.

Troy Funte
Liberty Electronics

-----Original Message-----
From: Mark Howard [mailto:mhoward@...]
Sent: Sunday, November 02, 2003 11:44 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report builder question



I'm writing a basic report for employees that clocked on to indirect labor
code on a daily basis. I am using the labor header and labor detail table
and want to link back to the empbasic table it insert there relevant name
on
the report. There seem to be no way of linking the labor header table to
the
empbasis table.

I thought I would be able to link the employee No in the labor header to
the employee No in the empbasic table and then insert there name on the
report from the empbasic table but in the empbasic table there is no
employee No.

Any tips would be appreciated...

Thanks


Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM>
<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=422413325>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
5
Thanks guys........ looked at bit odd, knew they had to be a link betwwn the
2 tables


----Original Message-----
From: Mike Lowe [mailto:MLowe@...]
Sent: Monday, November 03, 2003 2:58 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report builder question


Troy,

You recall correctly. This is indeed the case here.

Mike

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Sunday, November 02, 2003 8:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report builder question


Mark,
If I recall correctly, this might be the one exception where the Field
Name for an indexed field does not match between two tables. Go ahead and
link to the EmpID on the empbasic table and I think it will work for you.

Troy Funte
Liberty Electronics

-----Original Message-----
From: Mark Howard [mailto:mhoward@...]
Sent: Sunday, November 02, 2003 11:44 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report builder question



I'm writing a basic report for employees that clocked on to indirect labor
code on a daily basis. I am using the labor header and labor detail table
and want to link back to the empbasic table it insert there relevant name
on
the report. There seem to be no way of linking the labor header table to
the
empbasis table.

I thought I would be able to link the employee No in the labor header to
the employee No in the empbasic table and then insert there name on the
report from the empbasic table but in the empbasic table there is no
employee No.

Any tips would be appreciated...

Thanks


Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=17050071
83:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?
camp=556
<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=17050071
83:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?
camp=556&lineid=3614674&prop=egroupweb&pos=HM>
&lineid=3614674&prop=egroupweb&pos=HM>

<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmai
l/S=:HM/A=1524963/rand=422413325
<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmai
l/S=:HM/A=1524963/rand=422413325> >

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > .




[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=267637.4116730.5333196.1261774/D=egroupweb/S=17050071
83:HM/A=1754451/R=0/SIG=11tm86fb5/*http://www.netflix.com/Default?mqso=60178
323&partid=4116730> click here

<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmai
l/S=:HM/A=1754451/rand=473804838>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
6
I'm trying to make a report using the laborDtl table. I'm trying to list the labor entry on a specific work center by week.

Basically, from the beginning of the year, I want to see the activity at a specific work center on a weekly basis? How would I be able to group the results within weekly periods?

Thanks,
Jasper


[Non-text portions of this message have been removed]
7
This might get you started. Create a calculation based on the first
day of the first week of the year, yielding the week labor was
performed..

TheWeek = truncate((labordtl.payrolldate - 01/04/2004) / 7,0)

Sort and group on TheWeek first.

Lonnie

--- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@l...> wrote:
> I'm trying to make a report using the laborDtl table. I'm trying
to list the labor entry on a specific work center by week.
>
> Basically, from the beginning of the year, I want to see the
activity at a specific work center on a weekly basis? How would I be
able to group the results within weekly periods?
>
> Thanks,
> Jasper
>
>
> [Non-text portions of this message have been removed]
8
I've done some sort of like this (but not close enough to be useful to share). The approach I have used it to determine some starting date for the first week and then subtract it from a givne transaction date, divide by 7 and take the integer portion + 1 as the week number the transaciton occure in. This is then used as a group level so weeks are the up/down axis. Then work centers are accumulated in seperate "buckets" for each value (static list unfortunately) and printed at the group foot for each week across the page. Means a lot of calculated and agregated fields but as long as the number of work centers is reasonable and does not change often it works OK.
-Todd C.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, April 15, 2004 2:47 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Report builder question


I'm trying to make a report using the laborDtl table. I'm trying to list the labor entry on a specific work center by week.

Basically, from the beginning of the year, I want to see the activity at a specific work center on a weekly basis? How would I be able to group the results within weekly periods?

Thanks,
Jasper


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
9
Thanks!

Works great!
Jasper

-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Thursday, April 15, 2004 4:09 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report builder question


This might get you started. Create a calculation based on the first
day of the first week of the year, yielding the week labor was
performed..

TheWeek = truncate((labordtl.payrolldate - 01/04/2004) / 7,0)

Sort and group on TheWeek first.

Lonnie

--- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@l...> wrote:
> I'm trying to make a report using the laborDtl table. I'm trying
to list the labor entry on a specific work center by week.
>
> Basically, from the beginning of the year, I want to see the
activity at a specific work center on a weekly basis? How would I be
able to group the results within weekly periods?
>
> Thanks,
> Jasper
>
>
> [Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
10
FYI,

In Crystal this is really easy. If you choose to group by a date, it
will give you the option of setting which date range to group by with
no special formulas needed. Options include day, week, 2 weeks, half
month, month, quarter, half year, and year.

Brian Stenglein


--- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@l...> wrote:
> Thanks!
>
> Works great!
> Jasper
>
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Thursday, April 15, 2004 4:09 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Report builder question
>
>
> This might get you started. Create a calculation based on the
first
> day of the first week of the year, yielding the week labor was
> performed..
>
> TheWeek = truncate((labordtl.payrolldate - 01/04/2004) / 7,0)
>
> Sort and group on TheWeek first.
>
> Lonnie
>
> --- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@l...> wrote:
> > I'm trying to make a report using the laborDtl table. I'm trying
> to list the labor entry on a specific work center by week.
> >
> > Basically, from the beginning of the year, I want to see the
> activity at a specific work center on a weekly basis? How would I
be
> able to group the results within weekly periods?
> >
> > Thanks,
> > Jasper
> >
> >
> > [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
11
I am trying to create a report builder report that buckets the sales in each month just like the sales backlog report.

I am using this logic:
If the current month = due month > place amount in this months bucket (1st month)
If the current month + 1 = due month > place this amount in next months bucket (2nd month)
If the current month + 2 = due month > place the amount in the 3rd month
etc....

The problem that I am having is the time frame between December and January because the month goes from 12 back to 1.

So, if I ran my report now, the current month is August (8). January would be 5 months from now.
The January bucket logic would look like this:

If the current month + 5 = due month > place the amount in the 6th month

The problem is the due month for January is now back to (1) so the logic fails.

Does anybody have any ideas how to get around this. Is there a better logical way to approach this?

Thanks,
Jasper


[Non-text portions of this message have been removed]
12
This is a rolling 12 month report right?
So perhaps....
Month0 = CurMonth
Month1 = IIF(CurMonth + 1 < 13,CurMonth + 1,CurMonth + 1 - 12)
Month2 = IIF(CurMonth + 2 < 13,CurMonth + 2,CurMonth + 2 - 12)
etc....
Then fill each bucket according to if MonthX = DueMonth

Unless I am missing something.

As for the field name quesiton....beats me. Always wondered about that. I have a monthly bucket report with fields JanSales, FebSales, etc... all created in order at the same time....but NovSales and DecSales are seperated from the list by several other fields created much later. RB is just weird like that sometimes. My hunch is how things get stored in arrays in the PRL file.

-Todd C.


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jasper Recto
Sent: Thursday, August 02, 2007 9:57 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Report builder question


I am trying to create a report builder report that buckets the sales in each month just like the sales backlog report.

I am using this logic:
If the current month = due month > place amount in this months bucket (1st month)
If the current month + 1 = due month > place this amount in next months bucket (2nd month)
If the current month + 2 = due month > place the amount in the 3rd month
etc....

The problem that I am having is the time frame between December and January because the month goes from 12 back to 1.

So, if I ran my report now, the current month is August (8). January would be 5 months from now.
The January bucket logic would look like this:

If the current month + 5 = due month > place the amount in the 6th month

The problem is the due month for January is now back to (1) so the logic fails.

Does anybody have any ideas how to get around this. Is there a better logical way to approach this?

Thanks,
Jasper

[Non-text portions of this message have been removed]



________________________________
The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.

Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.

For more information please visit www.harveyvogel.com


[Non-text portions of this message have been removed]