Reporting by Memo Categories

Only the 1,000 that RB can handle. I have it set for Character Format X(1000) and Width 80 and Alignment is WordWrap so that it prints a nice looking block of text and adds new lines automatically as needed. As for how many can be entered....I am not sure but the Data Dictionary lists X(1000) as the field size for Memo.Text so that outght to be it.

-Todd C.

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Friday, March 12, 2004 3:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Reporting by Memo Categories


Any limitations on how many characters can be entered and then printed?

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corp
Aerostructures Division
Email: mreddy@...
Phone: (850) 682-2746 x272


-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, March 12, 2004 3:45 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Reporting by Memo Categories


Yes, I have several reports that filter out memos by CategoryID. In
particular for out Customer table where we have a Category called "Trip"
where sales people enter notes after visiting a customer. The report prints
out all previous Trip notes so that they can be briefed prior to their next
trip. Only trouble with memos and categories is the filtering process is
slower than direct linking.

The particular filder looks like: MemoCat.CategoryID = 'trip'
I am linking Memo to MemoCat but I don't recall exactly why I filtered on
MemoCat.CategoryID and not Memo.CategoryID which should have been faster.
Perhaps written back before I knew better.

-Todd C.

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Friday, March 12, 2004 3:30 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Reporting by Memo Categories


Does anyone know if it is possible to write a report filtered by a Memo
Category in version 6 (or even 5)?

TIA

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corp
Aerostructures Division
Email: mreddy@...
Phone: (850) 682-2746 x272




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



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



_____

Yahoo! Groups Links


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


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


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




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



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





----------------------------------------------------------------------------
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

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



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



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



_____

Yahoo! Groups Links


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


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


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




[Non-text portions of this message have been removed]
Does anyone know if it is possible to write a report filtered by a Memo
Category in version 6 (or even 5)?

TIA

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corp
Aerostructures Division
Email: mreddy@...
Phone: (850) 682-2746 x272




[Non-text portions of this message have been removed]
Yes, I have several reports that filter out memos by CategoryID. In particular for out Customer table where we have a Category called "Trip" where sales people enter notes after visiting a customer. The report prints out all previous Trip notes so that they can be briefed prior to their next trip. Only trouble with memos and categories is the filtering process is slower than direct linking.

The particular filder looks like: MemoCat.CategoryID = 'trip'
I am linking Memo to MemoCat but I don't recall exactly why I filtered on MemoCat.CategoryID and not Memo.CategoryID which should have been faster. Perhaps written back before I knew better.

-Todd C.

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Friday, March 12, 2004 3:30 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Reporting by Memo Categories


Does anyone know if it is possible to write a report filtered by a Memo
Category in version 6 (or even 5)?

TIA

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corp
Aerostructures Division
Email: mreddy@...
Phone: (850) 682-2746 x272




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



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



_____

Yahoo! Groups Links


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


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


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




[Non-text portions of this message have been removed]
Any limitations on how many characters can be entered and then printed?

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corp
Aerostructures Division
Email: mreddy@...
Phone: (850) 682-2746 x272


-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, March 12, 2004 3:45 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Reporting by Memo Categories


Yes, I have several reports that filter out memos by CategoryID. In
particular for out Customer table where we have a Category called "Trip"
where sales people enter notes after visiting a customer. The report prints
out all previous Trip notes so that they can be briefed prior to their next
trip. Only trouble with memos and categories is the filtering process is
slower than direct linking.

The particular filder looks like: MemoCat.CategoryID = 'trip'
I am linking Memo to MemoCat but I don't recall exactly why I filtered on
MemoCat.CategoryID and not Memo.CategoryID which should have been faster.
Perhaps written back before I knew better.

-Todd C.

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Friday, March 12, 2004 3:30 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Reporting by Memo Categories


Does anyone know if it is possible to write a report filtered by a Memo
Category in version 6 (or even 5)?

TIA

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corp
Aerostructures Division
Email: mreddy@...
Phone: (850) 682-2746 x272




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



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



_____

Yahoo! Groups Links


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


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


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




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



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





----------------------------------------------------------------------------
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

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



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