# RB Question
**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2004-10-01 14:16 UTC
**Views:** 1618
**Replies:** 36
**URL:** https://www.epiusers.help/t/rb-question/724
---
## Post #1 by @system
You will have to use the PartTran table and work your way backword.
-----Original Message-----
From: Cliff Drumeller [mailto:
cliff@...]
Sent: Friday, October 01, 2004 2:11 PM
To: VantageGroup (
vantage@yahoogroups.com)
Subject: [Vantage] RB Question
I'm trying to create a report that compares last months inventory to this
months inventory. I can easily get the inventory using partbin. To get my
onhand quantity of the parts in the warehouses and bins and filter it to
what partclass, etc.
The question is: Can you pull what the quantity of the part was on a prior
date in the bin ? If so what table and joins would you use.
Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217
[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
Hello,
Need some help. Can you put multiple if statements in a calculation in
report builder. Doing a report for 4.0 a quote report and almost done. Just
need this bit of info. If you can could you post an example of the format.
Thanx
[Non-text portions of this message have been removed]
---
## Post #3 by @system
Hello,
I have a "Packers Not Ready to Invoice" report that I'm working on. Our VP
of Sales asked me if I could pretty please put the amount (Extended Cost) in
the report. I've been playing around with it for a couple of hours now with
no success. Does anyone have any suggestions?? It's probably something
very simple that I've overlooked...
Thanks in advance,
Jamie Copsey
--
Jamie Copsey
Information Systems Coordinator
Accurate Metal Fabricators, Inc.
1011 Seal Beach Blvd
Seal Beach, CA 90704
(562) 596-4740 x138
Fax: (562) 596-6799
jcopsey@...To get this, first you will have to join the OrderDtl table into your
report. Then, you should multiply the ship quantity by the unit price and
add in any misc. charges.
Sarah
---
## Post #5 by @system
You will need to include a join back to the orderdtl table. In the shipdtl
table you have the Order, orderline and orderrel fields. Link these back to
the orderdtl and you will now have the line item unit price. Multiply this
by the total of items shipped (job and inventory) and this will give you the
value of that lines shipment.
-----Original Message-----
From: Copsey, Jamie [mailto:
jcopsey@...]
Sent: Tuesday, January 23, 2001 5:18 PM
To: '
vantage@egroups.com'
Subject: [Vantage] RB Question
Hello,
I have a "Packers Not Ready to Invoice" report that I'm working on. Our VP
of Sales asked me if I could pretty please put the amount (Extended Cost) in
the report. I've been playing around with it for a couple of hours now with
no success. Does anyone have any suggestions?? It's probably something
very simple that I've overlooked...
Thanks in advance,
Jamie Copsey
I've tried to join the OrderDtl table, and it starts telling me there are no
records. I don't know if I'll ever get the hang of writing reports ;) What
could I be doing wrong??
Jamie
--
Jamie Copsey
Information Systems Coordinator
Accurate Metal Fabricators, Inc.
1011 Seal Beach Blvd
Seal Beach, CA 90704
(562) 596-4740 x138
Fax: (562) 596-6799
jcopsey@...
> -----Original Message-----
> From: sarah.vareschi@... [SMTP:sarah.vareschi@...]
> Sent: Wednesday, January 24, 2001 5:37 AM
> To: vantage@egroups.com
> Subject: RE: [Vantage] RB Question
>
> To get this, first you will have to join the OrderDtl table into your
> report. Then, you should multiply the ship quantity by the unit price and
> add in any misc. charges.
>
> Sarah
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
>
>
Is there a way to delete a report in a library without having to recreate
the library without the report?
I have a report that I need to remove from a library but had rather not go
to the trouble of redoing it all.
Thanks.
Jim Moore
System Admin.
General Dynamics-OTS
---
## Post #8 by @system
Jim,
when you open report builder, you are offered an option to
open a report library. Select the library where the report resides,
and highlight it and hit the "delete report" button.
You can always "save as" to report work library before you
delete it so you have a copy if you need to resurrect it.
regards,
---
## Post #9 by @system
Wow, I am really asleep this morning. I knew that was there, just still
snoozing I guess.
Thanks, I feel really stupid now!
Jim
-----Original Message-----
From: PLAMAN DICK [mailto:
dick.plaman@...]
Sent: Thursday, November 14, 2002 6:56 AM
To: '
vantage@yahoogroups.com'
Subject: RE: [Vantage] RB Question
Jim,
when you open report builder, you are offered an option to
open a report library. Select the library where the report resides,
and highlight it and hit the "delete report" button.
You can always "save as" to report work library before you
delete it so you have a copy if you need to resurrect it.
regards,
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/How do you get the extended description to show up? I have tried
widening the field on a report. I am searching the archives because I
know this was asked before. Does anyone know?
Juliet
Most folks are as happy as they make up their minds to be. - Abraham
Lincoln
---
## Post #11 by @system
Right-click in the field and click 'Format'. Change the 'Character format'
to the # of characters you want the field to display. Then, right-click on
the field and choose 'alignment'. Set this to word-wrap.
[Non-text portions of this message have been removed]
---
## Post #12 by @system
Double click on the field on the report.
Press the FORMAT button.
Increase both the "Character Format:" number such as X(30) to X(40) and the
WIDTH field to 40.
Now the field should display up to 40 characters.
Patrick Winter
-----Original Message-----
From: Juliet Martin [mailto:
jmartin@...]
Sent: Tuesday, April 08, 2003 9:50 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] RB Question
How do you get the extended description to show up? I have tried widening
the field on a report. I am searching the archives because I know this was
asked before. Does anyone know?
Juliet
Most folks are as happy as they make up their minds to be. - Abraham
Lincoln
------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
128 Bit SSL Encryption!
http://us.click.yahoo.com/W7NydA/hdqFAA/VygGAA/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/Didn't work. I am looking for the extended description of a part. When
you are in part tracker and hit the memo button next to the part. Is
this in a different field than JobMtl Description?
Juliet
-----Original Message-----
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Tuesday, April 08, 2003 9:54 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
Right-click in the field and click 'Format'. Change the 'Character
format'
to the # of characters you want the field to display. Then, right-click
on
the field and choose 'alignment'. Set this to word-wrap.
[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
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/Should be the same and it should work. Try making the changes, saving the
report and closing. Then, re-open the report and run it again, sometimes it
needs to be refreshed.
[Non-text portions of this message have been removed]
---
## Post #15 by @system
That worked. Thanks. Something must have been screwy. I didn't even
change anything and it came up! Thanks everyone! I thought I was going
nuts.
Juliet
-----Original Message-----
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Tuesday, April 08, 2003 10:00 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
Should be the same and it should work. Try making the changes, saving
the
report and closing. Then, re-open the report and run it again,
sometimes it
needs to be refreshed.
Just out of curiosity. Did you open the report and run it once, then add the memo text in Vantage, then come back to RB and run it again and not see the text? The rules RB uses for when to go "back to the well" and re-collect the data are sometimes strange. Closing and opening the report will force a new read of the DB. Sometimes I add a bogus filter then delete it and it "senses" it needs to re-collect the data. Other times I do nothing but bold a field and it wants to re-read. That's why I'm curious, just trying to assemble more clues to what drives this.
Thanks,
-Todd C.
-----Original Message-----
From: Juliet Martin [mailto:
jmartin@...]
Sent: Tuesday, April 08, 2003 10:01 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
That worked. Thanks. Something must have been screwy. I didn't even
change anything and it came up! Thanks everyone! I thought I was going
nuts.
Juliet
-----Original Message-----
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Tuesday, April 08, 2003 10:00 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
Should be the same and it should work. Try making the changes, saving
the
report and closing. Then, re-open the report and run it again,
sometimes it
needs to be refreshed.
Yahoo! Groups Sponsor
<
http://us.ard.yahoo.com/M=249982.3083889.4452939.1728375/D=egroupweb/S=1705007183:HM/A=1524963/R=0/*http://hits.411web.com/cgi-bin/autoredir?camp=556&llineid=3083889&prop=egroupweb&pos=HM>
<
http://us.adserver.yahoo.com/l?M=249982.3083889.4452939.1728375/D=egroupmail/S=:HM/A=1524963/rand=243188549>
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]
No - I didn't do that. I have also noted the same thing as you. You
can make big changes and your report comes up immediately then other
times you can change the font and it re-reads the file. No idea. I
just haven't been in report builder lately and should have remembered
that it does this.
Juliet
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Tuesday, April 08, 2003 10:05 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
Just out of curiosity. Did you open the report and run it once, then
add the memo text in Vantage, then come back to RB and run it again and
not see the text? The rules RB uses for when to go "back to the well"
and re-collect the data are sometimes strange. Closing and opening the
report will force a new read of the DB. Sometimes I add a bogus filter
then delete it and it "senses" it needs to re-collect the data. Other
times I do nothing but bold a field and it wants to re-read. That's why
I'm curious, just trying to assemble more clues to what drives this.
Thanks,
-Todd C.
-----Original Message-----
From: Juliet Martin [mailto:
jmartin@...]
Sent: Tuesday, April 08, 2003 10:01 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
That worked. Thanks. Something must have been screwy. I didn't even
change anything and it came up! Thanks everyone! I thought I was going
nuts.
Juliet
-----Original Message-----
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Tuesday, April 08, 2003 10:00 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
Should be the same and it should work. Try making the changes, saving
the
report and closing. Then, re-open the report and run it again,
sometimes it
needs to be refreshed.
Yahoo! Groups Sponsor
<
http://us.ard.yahoo.com/M=249982.3083889.4452939.1728375/D=egroupweb/S=
1705007183:HM/A=1524963/R=0/*
http://hits.411web.com/cgi-bin/autoredir?ca
mp=556&llineid=3083889&prop=egroupweb&pos=HM>
<
http://us.adserver.yahoo.com/l?M=249982.3083889.4452939.1728375/D=egrou
pmail/S=:HM/A=1524963/rand=243188549>
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]
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/OK. I am nuts. I can get more of the description but not the entire
thing on some of the longer fields. I have the following setup:
Format: x(10000) - I am desperate
Width: 60
Word Wrap - Left.
Help! I am in a hurry. I am supposed to have this report done by now
and they want to see the FULL description.
Juliet
-----Original Message-----
From: Juliet Martin
Sent: Tuesday, April 08, 2003 10:01 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
That worked. Thanks. Something must have been screwy. I didn't even
change anything and it came up! Thanks everyone! I thought I was going
nuts.
Juliet
1. I assume the Format is really 1,000 not 10,000. The database format is only 1,000 so any extra may not do any good.
2. How was the text entered in the description field? If it was entered with "Enter" (CR) at th end of lines rather than allowing to wrap naturally it can cause problems getting it all to print. If I recall the characters between the CR on a line (as it prints) and the end of that line's width get counted as text for the format's size. So if you have a really long description (nearing the 1000 character max) you can lose some text. Does the text that does print have odd characters in it (like shaded squares or rectangle boxes). This is an indicaiton they entered "hard" returns. You might want to use a formula to strip out all CR ( CHR(13) ) and replace with a space. Tab characters are also good to replace ( CHR(9) ). Then use your calculated field (with all the word wrapping etc..) to print.
-Todd C.
-----Original Message-----
From: Juliet Martin [mailto:
jmartin@...]
Sent: Tuesday, April 08, 2003 10:36 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
OK. I am nuts. I can get more of the description but not the entire
thing on some of the longer fields. I have the following setup:
Format: x(10000) - I am desperate
Width: 60
Word Wrap - Left.
Help! I am in a hurry. I am supposed to have this report done by now
and they want to see the FULL description.
Juliet
-----Original Message-----
From: Juliet Martin
Sent: Tuesday, April 08, 2003 10:01 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
That worked. Thanks. Something must have been screwy. I didn't even
change anything and it came up! Thanks everyone! I thought I was going
nuts.
Juliet
Yahoo! Groups Sponsor
<
http://us.ard.yahoo.com/M=249982.3083889.4452939.1728375/D=egroupweb/S=1705007183:HM/A=1524963/R=0/*http://hits.411web.com/cgi-bin/autoredir?camp=556&llineid=3083889&prop=egroupweb&pos=HM>
<
http://us.adserver.yahoo.com/l?M=249982.3083889.4452939.1728375/D=egroupmail/S=:HM/A=1524963/rand=277735234>
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]
Are any fonts set really small, like under 6 or 7. I have see display
problems when the font size was set to 5 or 6.
Patrick Winter
-----Original Message-----
From: Juliet Martin [mailto:
jmartin@...]
Sent: Tuesday, April 08, 2003 10:36 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
OK. I am nuts. I can get more of the description but not the entire thing
on some of the longer fields. I have the following setup:
Format: x(10000) - I am desperate
Width: 60
Word Wrap - Left.
Help! I am in a hurry. I am supposed to have this report done by now and
they want to see the FULL description.
Juliet
-----Original Message-----
From: Juliet Martin
Sent: Tuesday, April 08, 2003 10:01 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
That worked. Thanks. Something must have been screwy. I didn't even
change anything and it came up! Thanks everyone! I thought I was going
nuts.
Juliet
------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
128 Bit SSL Encryption!
http://us.click.yahoo.com/xaxhjB/hdqFAA/VygGAA/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/I had a calculation being performed on JobMtl.Description. I ran it
without being in a calculation. It came out fine. I read your e-mail
and noticed the odd characters you described. It seems that is indeed
my problem. A big thank you to everyone. I am grateful that all of
you. Your help is greatly appreciated.
Juliet
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Tuesday, April 08, 2003 10:52 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
1. I assume the Format is really 1,000 not 10,000. The database format
is only 1,000 so any extra may not do any good.
2. How was the text entered in the description field? If it was entered
with "Enter" (CR) at th end of lines rather than allowing to wrap
naturally it can cause problems getting it all to print. If I recall
the characters between the CR on a line (as it prints) and the end of
that line's width get counted as text for the format's size. So if you
have a really long description (nearing the 1000 character max) you can
lose some text. Does the text that does print have odd characters in it
(like shaded squares or rectangle boxes). This is an indicaiton they
entered "hard" returns. You might want to use a formula to strip out
all CR ( CHR(13) ) and replace with a space. Tab characters are also
good to replace ( CHR(9) ). Then use your calculated field (with all
the word wrapping etc..) to print.
-Todd C.
I have to pull a report based on a portion of the part description. I have
part descriptions such as -15"x150' Punched Black or 15"x750' Punched Black.
A sales guy wants a report that shows how much 150' material he sold last
year. The only way I can think of doing that would be to somehow filter on
parts that the description contains 150'. Problem is I have no clue how to
make that happen. Anyone care to help?
Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.
---
## Post #24 by @system
I'm not sure how to do this with report builder, but if you use MS access,
you can use the filter: Like "*150*" and that will give you the results you
want.
[Non-text portions of this message have been removed]
---
## Post #25 by @system
---
## Post #26 by @system
Try adding a filter line "Part.PartDescription MATCHES '*150*'
Patrick Winter
-----Original Message-----
From: Todd Hofert [mailto:
thofert@...]
Sent: Tuesday, May 13, 2003 9:38 AM
To: Vantage List (E-mail)
Subject: [Vantage] RB Question
I have to pull a report based on a portion of the part description. I have
part descriptions such as -15"x150' Punched Black or 15"x750' Punched Black.
A sales guy wants a report that shows how much 150' material he sold last
year. The only way I can think of doing that would be to somehow filter on
parts that the description contains 150'. Problem is I have no clue how to
make that happen. Anyone care to help?
Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.
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/Patrick/Sarah,
You are the man/woman. This is perfect. I can find many uses for this.
Thanks
The suggestion for substring is useful as well however wouldn't work in this
situation because the 150 does not always appear in the same place in all of
my descriptions.
Thanks to all
Todd
-----Original Message-----
From:
pjw@... [mailto:
pjw@...]
Sent: Tuesday, May 13, 2003 11:00 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
Try adding a filter line "Part.PartDescription MATCHES '*150*'
Patrick Winter
-----Original Message-----
From: Todd Hofert [mailto:
thofert@...]
Sent: Tuesday, May 13, 2003 9:38 AM
To: Vantage List (E-mail)
Subject: [Vantage] RB Question
I have to pull a report based on a portion of the part description. I have
part descriptions such as -15"x150' Punched Black or 15"x750' Punched Black.
A sales guy wants a report that shows how much 150' material he sold last
year. The only way I can think of doing that would be to somehow filter on
parts that the description contains 150'. Problem is I have no clue how to
make that happen. Anyone care to help?
Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.
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/Hello Group,
What's key sequence to display the progress code generated by report
builder?
[Non-text portions of this message have been removed]
---
## Post #30 by @system
At 02:16 PM 9/30/2004, you wrote:
>What's key sequence to display the progress code generated by report builder?
Don't have RB handy to try; but try either ctrl-F11 or alt-F11. IIRC it's
one of those. It should actually be SQL you're seeing.
-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338
[Non-text portions of this message have been removed]
That's not working, I remember it was something like ctrl-F11 then "p" but I
can't seem to get it to show the SQL.
Patrick
-----Original Message-----
From: Wayne Cox [mailto:
wmc20@...]
Sent: Thursday, September 30, 2004 1:25 PM
To:
vantage@yahoogroups.com
Subject: Re: [Vantage] RB Question
At 02:16 PM 9/30/2004, you wrote:
>What's key sequence to display the progress code generated by report
builder?
Don't have RB handy to try; but try either ctrl-F11 or alt-F11. IIRC it's
one of those. It should actually be SQL you're seeing.
-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338
[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
Try CTRL ALT p, then F12.
David Kaufman
CNC Metals
A Global Body Co.
> -----Original Message-----
> From: pjw@... [SMTP:pjw@...]
> Sent: Thursday, September 30, 2004 2:57 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] RB Question
>
> That's not working, I remember it was something like ctrl-F11 then "p" but I
> can't seem to get it to show the SQL.
>
>
> Patrick
>
> -----Original Message-----
> From: Wayne Cox [mailto:wmc20@...]
> Sent: Thursday, September 30, 2004 1:25 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] RB Question
>
> At 02:16 PM 9/30/2004, you wrote:
> >What's key sequence to display the progress code generated by report
> builder?
>
> Don't have RB handy to try; but try either ctrl-F11 or alt-F11. IIRC it's
> one of those. It should actually be SQL you're seeing.
>
>
>
> -Wayne Cox
> Twenty Three -- Information Technology Consulting
> 828-685-2338
>
>
>
> [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
>
>
>
>
>
>
>
> 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
>
>
>
>
>
David,
Thanks, no wonder I couldn't get it to work CTRL ALT p runs my print screen
program.
Patrick Winter
-----Original Message-----
From: David Kaufman [mailto:
DKaufman@...]
Sent: Thursday, September 30, 2004 2:06 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
Try CTRL ALT p, then F12.
David Kaufman
CNC Metals
A Global Body Co.
> -----Original Message-----
> From: pjw@... [SMTP:pjw@...]
> Sent: Thursday, September 30, 2004 2:57 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] RB Question
>
> That's not working, I remember it was something like ctrl-F11 then "p"
> but I can't seem to get it to show the SQL.
>
>
> Patrick
>
> -----Original Message-----
> From: Wayne Cox [mailto:wmc20@...]
> Sent: Thursday, September 30, 2004 1:25 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] RB Question
>
> At 02:16 PM 9/30/2004, you wrote:
> >What's key sequence to display the progress code generated by report
> builder?
>
> Don't have RB handy to try; but try either ctrl-F11 or alt-F11. IIRC
> it's one of those. It should actually be SQL you're seeing.
>
>
>
> -Wayne Cox
> Twenty Three -- Information Technology Consulting
> 828-685-2338
>
>
>
> [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
>
>
>
>
>
>
>
> 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
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/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
Yahoo! Groups Links
Does this work only for user written report build reports?
If not, when do you press the key combination?
I tried doing it before and after I printed the stock status report but I just keep getting the Program call list.
This tool would be of great help.
Thanks
Jeremy
-----Original Message-----
From:
pjw@... [mailto:
pjw@...]
Sent: Thursday, September 30, 2004 3:17 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
David,
Thanks, no wonder I couldn't get it to work CTRL ALT p runs my print screen
program.
Patrick Winter
-----Original Message-----
From: David Kaufman [mailto:
DKaufman@...]
Sent: Thursday, September 30, 2004 2:06 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
Try CTRL ALT p, then F12.
David Kaufman
CNC Metals
A Global Body Co.
> -----Original Message-----
> From: pjw@... [SMTP:pjw@...]
> Sent: Thursday, September 30, 2004 2:57 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] RB Question
>
> That's not working, I remember it was something like ctrl-F11 then "p"
> but I can't seem to get it to show the SQL.
>
>
> Patrick
>
> -----Original Message-----
> From: Wayne Cox [mailto:wmc20@...]
> Sent: Thursday, September 30, 2004 1:25 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] RB Question
>
> At 02:16 PM 9/30/2004, you wrote:
> >What's key sequence to display the progress code generated by report
> builder?
>
> Don't have RB handy to try; but try either ctrl-F11 or alt-F11. IIRC
> it's one of those. It should actually be SQL you're seeing.
>
>
>
> -Wayne Cox
> Twenty Three -- Information Technology Consulting
> 828-685-2338
>
>
>
> [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
>
>
>
>
>
>
>
> 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
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/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
Yahoo! Groups Links
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
Load the report in report builder like your going to edit it, then do the
key combo.
Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.20.322, Progress 9.1D, Windows 2003 Server, Crystal 8.5.3.975
-----Original Message-----
From: Jeremy Leonard [mailto:
jeremy.leonard@...]
Sent: Thursday, September 30, 2004 2:44 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
Does this work only for user written report build reports?
If not, when do you press the key combination?
I tried doing it before and after I printed the stock status report but I
just keep getting the Program call list.
This tool would be of great help.
Thanks
Jeremy
-----Original Message-----
From:
pjw@... [mailto:
pjw@...]
Sent: Thursday, September 30, 2004 3:17 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
David,
Thanks, no wonder I couldn't get it to work CTRL ALT p runs my print screen
program.
Patrick Winter
-----Original Message-----
From: David Kaufman [mailto:
DKaufman@...]
Sent: Thursday, September 30, 2004 2:06 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Question
Try CTRL ALT p, then F12.
David Kaufman
CNC Metals
A Global Body Co.
> -----Original Message-----
> From: pjw@... [SMTP:pjw@...]
> Sent: Thursday, September 30, 2004 2:57 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] RB Question
>
> That's not working, I remember it was something like ctrl-F11 then "p"
> but I can't seem to get it to show the SQL.
>
>
> Patrick
>
> -----Original Message-----
> From: Wayne Cox [mailto:wmc20@...]
> Sent: Thursday, September 30, 2004 1:25 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] RB Question
>
> At 02:16 PM 9/30/2004, you wrote:
> >What's key sequence to display the progress code generated by report
> builder?
>
> Don't have RB handy to try; but try either ctrl-F11 or alt-F11. IIRC
> it's one of those. It should actually be SQL you're seeing.
>
>
>
> -Wayne Cox
> Twenty Three -- Information Technology Consulting
> 828-685-2338
>
>
>
> [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
>
>
>
>
>
>
>
> 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
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/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
Yahoo! Groups Links
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
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
I'm trying to create a report that compares last months inventory to this
months inventory. I can easily get the inventory using partbin. To get my
onhand quantity of the parts in the warehouses and bins and filter it to
what partclass, etc.
The question is: Can you pull what the quantity of the part was on a prior
date in the bin ? If so what table and joins would you use.
Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217
[Non-text portions of this message have been removed]
---
**Canonical:** https://www.epiusers.help/t/rb-question/724
**Original content:** https://www.epiusers.help/t/rb-question/724