RB/Crystal: listing multiple WCCodes on same line

Yahoo Archive
1
Sarah/Todd/Patrick

Thanks for the ideas... I got it to work properly...


Paul

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Wednesday, November 05, 2003 11:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB/Crystal: listing multiple WCCodes on same line


Depending on how many work centers, jobs etc...
Create a Calculated field for each work center WC1 = IIF(LaborDtl.wccode =
"WC1",HOURS,0)
Put the calculated field under each column for that work center, subtotal,
total accordingly.

Patrick Winter


-----Original Message-----
From: Paul Siebers [mailto:paul.siebers@...]
Sent: Wednesday, November 05, 2003 10:41 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB/Crystal: listing multiple WCCodes on same line


All;

I am stumped on this one: I have a report that lists jobs with total hours
by each individual workcenter (LaborDTL.WCCode). This is done by using a
group footer with totals for each workcenter. This of course, results in a
report listing each workcenter under the previous one (vertically). Mgmt
now wants all workcenters listed horizontally, on the same line, ie. one
line in a spreadsheet showing job# each of the 15 workcenters (show 0 if
nothing was clocked to a center).

Is it possible to do this, and if so, how? Would you use Crystal or RB for
this?

TIA,

Paul

------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->

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 http://docs.yahoo.com/info/terms/



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 http://docs.yahoo.com/info/terms/
2
All;

I am stumped on this one: I have a report that lists jobs with total hours
by each individual workcenter (LaborDTL.WCCode). This is done by using a
group footer with totals for each workcenter. This of course, results in a
report listing each workcenter under the previous one (vertically). Mgmt
now wants all workcenters listed horizontally, on the same line, ie. one
line in a spreadsheet showing job# each of the 15 workcenters (show 0 if
nothing was clocked to a center).

Is it possible to do this, and if so, how? Would you use Crystal or RB for
this?

TIA,

Paul
3
I would use MS access with ODBC and do a crosstab query on the underlying
query info.
4
I'll send an example in RB off-list. Problem is the work to modify such a beast to what you want is almost as bad as writing from scratch. But the technique should be the same.
-Todd C.

-----Original Message-----
From: Paul Siebers [mailto:paul.siebers@...]
Sent: Wednesday, November 05, 2003 10:41 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB/Crystal: listing multiple WCCodes on same line


All;

I am stumped on this one: I have a report that lists jobs with total hours
by each individual workcenter (LaborDTL.WCCode). This is done by using a
group footer with totals for each workcenter. This of course, results in a
report listing each workcenter under the previous one (vertically). Mgmt
now wants all workcenters listed horizontally, on the same line, ie. one
line in a spreadsheet showing job# each of the 15 workcenters (show 0 if
nothing was clocked to a center).

Is it possible to do this, and if so, how? Would you use Crystal or RB for
this?

TIA,

Paul


Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=267637.4116719.5338353.1261774/D=egroupweb/S=1705007183:HM/A=1754452/R=0/SIG=11ti8tui3/*http://www.netflix.com/Default?mqso=60178324&partid=4116719> click here
<http://us.adserver.yahoo.com/l?M=267637.4116719.5338353.1261774/D=egroupmail/S=:HM/A=1754452/rand=560106259>

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
Depending on how many work centers, jobs etc...
Create a Calculated field for each work center WC1 = IIF(LaborDtl.wccode =
"WC1",HOURS,0)
Put the calculated field under each column for that work center, subtotal,
total accordingly.

Patrick Winter


-----Original Message-----
From: Paul Siebers [mailto:paul.siebers@...]
Sent: Wednesday, November 05, 2003 10:41 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB/Crystal: listing multiple WCCodes on same line


All;

I am stumped on this one: I have a report that lists jobs with total hours
by each individual workcenter (LaborDTL.WCCode). This is done by using a
group footer with totals for each workcenter. This of course, results in a
report listing each workcenter under the previous one (vertically). Mgmt
now wants all workcenters listed horizontally, on the same line, ie. one
line in a spreadsheet showing job# each of the 15 workcenters (show 0 if
nothing was clocked to a center).

Is it possible to do this, and if so, how? Would you use Crystal or RB for
this?

TIA,

Paul

------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->

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 http://docs.yahoo.com/info/terms/