RB Question

Yahoo Archive
21
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/
22
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.
23
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.
24
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]
25
The only way you can really approach this is using the substring
function. Its success is predicated on whether or not the description
entry is done in a consistent manner. That is, does the 150 ALWAYS
appear at the end of the description with a ' at the end or does "1"
ALWAYS the 5th character in the description. Otherwise, your results
will be inconsistent.

Shirley Graver
Sys Admin
Rubber Associates Inc.

-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Tuesday, May 13, 2003 10: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.






Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/M=253924.3294213.4590844.1261774/D=egroupweb/S=1705
007183:HM/A=1380983/R=2/id=noscript/*http:/companion.yahoo.com/config/fe
atures5>


<http://us.a1.yimg.com/us.yimg.com/a/ya/yahoo_companion/pop_lrec_back.gi
f>


<http://us.adserver.yahoo.com/l?M=253924.3294213.4590844.1261774/D=egrou
pmail/S=:HM/A=1380983/rand=599563109>

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
(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!
<http://docs.yahoo.com/info/terms/> Terms of Service.


[Non-text portions of this message have been removed]
26
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/
27
cOOL Patrick, I forgot about wild cards.

Shirley

-----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/.
<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/





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/M=253924.3294213.4590844.1261774/D=egroupweb/S=1705
007183:HM/A=1380983/R=2/id=noscript/*http:/companion.yahoo.com/config/fe
atures5>


<http://us.a1.yimg.com/us.yimg.com/a/ya/yahoo_companion/pop_lrec_back.gi
f>


<http://us.adserver.yahoo.com/l?M=253924.3294213.4590844.1261774/D=egrou
pmail/S=:HM/A=1380983/rand=630683004>

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
(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!
<http://docs.yahoo.com/info/terms/> Terms of Service.


[Non-text portions of this message have been removed]
28
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/
29
Hello Group,

What's key sequence to display the progress code generated by report
builder?


[Non-text portions of this message have been removed]
30
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]
31
Looked up an old post. Ctrl-Alt-P then F12 to show the SQL code.
-Todd C.

-----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 Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129h4v7dq/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1096655165/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=215016275>


_____

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]
32
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
33
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
>
>
>
>
>
34
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
35
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
36
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
37
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]