RB Question

Yahoo Archive
1
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
2
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]
3
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@...
4
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
5
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
6
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
>
>
7
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
8
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,
9
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/
10
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
11
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]
12
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/
13
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/
14
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]
15
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.
16
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]
17
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/
18
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
19
Change the band format to freeform and make sure there is a blank line
below it.

Shirley

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Tuesday, April 08, 2003 11: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?cam
p=556&llineid=3083889∝=egroupweb&pos=HM>


<http://us.adserver.yahoo.com/l?M=249982.3083889.4452939.1728375/D=egrou
pmail/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/.
<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]
20
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]