HELP! Report Builder assistance needed, please!

Yahoo Archive
1
I have had some cases where Memos can not be linked due to field type mismatch and linking not allowing certain function fields. The only work around was to take them "all" (link on company and table name only) and then filter for the matches. It works but it is very slow because you give up using an index for retrieval.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Tricia Simon
Sent: Wednesday, April 26, 2006 9:46 AM
To: Vantage One-List (E-mail)
Subject: [Vantage] HELP! Report Builder assistance needed, please!!!


Folks,

I'm trying to write a report that will list all jobs Not Engineered, whether
the part is approved and any memos.

I have everything working but the memo. I'm thinking it may have something
to do with Key1, but I'm not sure. I've tried several variations with
substring and string, but can't seem to find the right "formula."
Currently, I'm joining JobHead to PartRev. I've tried joining Memo with
JobHead and also with PartRev. Doesn't seem to make a difference.

Has anyone written a report for Jobs with Memos?????

Any suggestions would sure be appreciated!

TIA

Tricia Simon, Controller
Riten Industries, 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




SPONSORED LINKS
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* 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]
2
Folks,

I'm trying to write a report that will list all jobs Not Engineered, whether
the part is approved and any memos.

I have everything working but the memo. I'm thinking it may have something
to do with Key1, but I'm not sure. I've tried several variations with
substring and string, but can't seem to find the right "formula."
Currently, I'm joining JobHead to PartRev. I've tried joining Memo with
JobHead and also with PartRev. Doesn't seem to make a difference.

Has anyone written a report for Jobs with Memos?????

Any suggestions would sure be appreciated!

TIA

Tricia Simon, Controller
Riten Industries, Inc.