Where Used - Crystal Report Epicor 9.04.506b

I have, but I did a fair amount of work to get to it.

I'm on 8.03.408B MSSQL.

To accomplish what I wanted to do, I wrote a C#/.NET program that
takes a list of top-level manufactured parts with a BOM, and for each
part, explode the BOM and capture some details. I process this data and
store it in UD03. UD03.Key1 contains the top-level partnum. UD03.Key3
contains the sub-component partnum. I call this program BOMCache since
is creates a cache of exploded BOM info. This info doesn't change that
quickly, so refreshing the BOMCache nightly seems reasonable.

I can then use this in table joins to bring in, for a purchased part,
the top-level assemblies that part is used in. I can then do grouping
in Crystal and hide detail sections, etc. depending on how I've
constructed my queries to do some powerful analysis.

This only works in MSSQL since you can use common table expression
(CTE) queries to deal with hierarchical data structures.

I'm happy to share the source code if someone wants it. The whole
thing is configuration driven via a config.xml file.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of advantage@...
Sent: Monday, October 25, 2010 11:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Where Used - Crystal Report Epicor 9.04.506b

Has any one created a Where-Used Report in Crystal?



------------------------------------

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/linksYahoo! Groups Links
Hi Folks,

I have done this 100's of time on other other forms, but when I go to add a test box to the Job Entry form, assign it to Job Head\Short Char01, save and reopen it's just grey. Enabled = True. I then changed it to JobHead\Char01 and same result - is this a bug?

Regards,

Michael

Vantage 8.03.406
Michael,



You're beating your head against the Vantage UI business logic. This
happens on other forms, too, where the UI is locked down not permitting
changes to Jobs that have been Released or Closed, etc. Sales Orders
and Quotes, among others, exhibit the same behavior and I've had to do
alternate "back door" approaches when I need to do this.







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Monday, October 25, 2010 10:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Unable to customise Job Entry form





Hi Folks,

I have done this 100's of time on other other forms, but when I go to
add a test box to the Job Entry form, assign it to Job Head\Short
Char01, save and reopen it's just grey. Enabled = True. I then changed
it to JobHead\Char01 and same result - is this a bug?

Regards,

Michael

Vantage 8.03.406





[Non-text portions of this message have been removed]
Is EpiKeyField set to true?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Monday, October 25, 2010 10:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Unable to customise Job Entry form





Hi Folks,

I have done this 100's of time on other other forms, but when I go to
add a test box to the Job Entry form, assign it to Job Head\Short
Char01, save and reopen it's just grey. Enabled = True. I then changed
it to JobHead\Char01 and same result - is this a bug?

Regards,

Michael

Vantage 8.03.406





[Non-text portions of this message have been removed]
How do I get round it? All I want is a text box linked to shortchar01........

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Michael,
>
>
>
> You're beating your head against the Vantage UI business logic. This
> happens on other forms, too, where the UI is locked down not permitting
> changes to Jobs that have been Released or Closed, etc. Sales Orders
> and Quotes, among others, exhibit the same behavior and I've had to do
> alternate "back door" approaches when I need to do this.
>
>
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of michael.hutcheson@...
> Sent: Monday, October 25, 2010 10:59 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Unable to customise Job Entry form
>
>
>
>
>
> Hi Folks,
>
> I have done this 100's of time on other other forms, but when I go to
> add a test box to the Job Entry form, assign it to Job Head\Short
> Char01, save and reopen it's just grey. Enabled = True. I then changed
> it to JobHead\Char01 and same result - is this a bug?
>
> Regards,
>
> Michael
>
> Vantage 8.03.406
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
This has solved it, thank you. What exactly does the EpiKeyField do?

--- In vantage@yahoogroups.com, "Linda Lowney" <llowney@...> wrote:
>
> Is EpiKeyField set to true?
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of michael.hutcheson@...
> Sent: Monday, October 25, 2010 10:59 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Unable to customise Job Entry form
>
>
>
>
>
> Hi Folks,
>
> I have done this 100's of time on other other forms, but when I go to
> add a test box to the Job Entry form, assign it to Job Head\Short
> Char01, save and reopen it's just grey. Enabled = True. I then changed
> it to JobHead\Char01 and same result - is this a bug?
>
> Regards,
>
> Michael
>
> Vantage 8.03.406
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Ahh... yea, that sometimes will work. It links it to the business logic
of the form. It's been hit or miss in different patch levels of .400
for me.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Monday, October 25, 2010 11:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Unable to customise Job Entry form





This has solved it, thank you. What exactly does the EpiKeyField do?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Linda Lowney" <llowney@...> wrote:
>
> Is EpiKeyField set to true?
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of michael.hutcheson@...
> Sent: Monday, October 25, 2010 10:59 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Unable to customise Job Entry form
>
>
>
>
>
> Hi Folks,
>
> I have done this 100's of time on other other forms, but when I go to
> add a test box to the Job Entry form, assign it to Job Head\Short
> Char01, save and reopen it's just grey. Enabled = True. I then changed
> it to JobHead\Char01 and same result - is this a bug?
>
> Regards,
>
> Michael
>
> Vantage 8.03.406
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





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



I have no idea what it does. I was told to turn it on when I did my
first customization and I've done it ever since. It makes no sense to
me because it obviously is not a "key" field that I'm customizing.



Regards,

Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Monday, October 25, 2010 11:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Unable to customise Job Entry form





This has solved it, thank you. What exactly does the EpiKeyField do?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Linda Lowney" <llowney@...> wrote:
>
> Is EpiKeyField set to true?
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of michael.hutcheson@...
> Sent: Monday, October 25, 2010 10:59 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Unable to customise Job Entry form
>
>
>
>
>
> Hi Folks,
>
> I have done this 100's of time on other other forms, but when I go to
> add a test box to the Job Entry form, assign it to Job Head\Short
> Char01, save and reopen it's just grey. Enabled = True. I then changed
> it to JobHead\Char01 and same result - is this a bug?
>
> Regards,
>
> Michael
>
> Vantage 8.03.406
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
Has any one created a Where-Used Report in Crystal?
You have to love Vantage....

--- In vantage@yahoogroups.com, "Linda Lowney" <llowney@...> wrote:
>
> Hi Michael,
>
>
>
> I have no idea what it does. I was told to turn it on when I did my
> first customization and I've done it ever since. It makes no sense to
> me because it obviously is not a "key" field that I'm customizing.
>
>
>
> Regards,
>
> Linda
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of michael.hutcheson@...
> Sent: Monday, October 25, 2010 11:15 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Unable to customise Job Entry form
>
>
>
>
>
> This has solved it, thank you. What exactly does the EpiKeyField do?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Linda Lowney" <llowney@> wrote:
> >
> > Is EpiKeyField set to true?
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of michael.hutcheson@
> > Sent: Monday, October 25, 2010 10:59 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Unable to customise Job Entry form
> >
> >
> >
> >
> >
> > Hi Folks,
> >
> > I have done this 100's of time on other other forms, but when I go to
> > add a test box to the Job Entry form, assign it to Job Head\Short
> > Char01, save and reopen it's just grey. Enabled = True. I then changed
> > it to JobHead\Char01 and same result - is this a bug?
> >
> > Regards,
> >
> > Michael
> >
> > Vantage 8.03.406
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Setting the EpiKeyField to true makes the field available BEFORE a
record is returned e.g. it is needed as part of the record key to get
the data. If this is false, the field won't become available until you
have selected a record.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Linda Lowney
Sent: Monday, October 25, 2010 12:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Unable to customise Job Entry form





Hi Michael,

I have no idea what it does. I was told to turn it on when I did my
first customization and I've done it ever since. It makes no sense to
me because it obviously is not a "key" field that I'm customizing.

Regards,

Linda

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of michael.hutcheson@...
<mailto:michael.hutcheson%40rocketmail.com>
Sent: Monday, October 25, 2010 11:15 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Unable to customise Job Entry form

This has solved it, thank you. What exactly does the EpiKeyField do?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Linda Lowney" <llowney@...> wrote:
>
> Is EpiKeyField set to true?
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of michael.hutcheson@...
> Sent: Monday, October 25, 2010 10:59 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Unable to customise Job Entry form
>
>
>
>
>
> Hi Folks,
>
> I have done this 100's of time on other other forms, but when I go to
> add a test box to the Job Entry form, assign it to Job Head\Short
> Char01, save and reopen it's just grey. Enabled = True. I then changed
> it to JobHead\Char01 and same result - is this a bug?
>
> Regards,
>
> Michael
>
> Vantage 8.03.406
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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





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