Crystal report for Kits

Yahoo Archive
1
Right, but in your BAQ for partmtl…You are linking the part table – correct? If you link partmtl company = part company and partmtl partnum = part partnum, you should be able to pull in part partdescription and part unit price for the partmtl partnum (since it matches the part partnum) – you can spot check if you don’t think this is correct…

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jdaniel1127@...
Sent: Tuesday, May 22, 2012 9:42 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Crystal report for Kits




part.list code is used for pricing ( i.e. in the us we sell it for a different price than europe so the same part number has 2 codes and prices... )

In the partmtl there is a parent part field that gives me the kit part number and the mtlpartnum is the sub part. Problem is getting the part description, listcode and price for the partmtl as they aren't in that table, they are in the part table...

----- Original Message -----

From: "Karen Schoenung" <kschoenung@...<mailto:kschoenung%40fisher-barton.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Tuesday, May 22, 2012 10:15:52 AM
Subject: RE: [Vantage] Re: Crystal report for Kits



So you second BAQ has partmtl.partnum, part.partdescription, part.listcode?(not familiar with this field, maybe not in 803.409c), part.unitprice?

Then somehow you need to link the kit part to the partmtl in Crystal (not sure – we don’t use kits)

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> ] On Behalf Of jdaniel1127@...<mailto:jdaniel1127%40comcast.net>
Sent: Monday, May 21, 2012 4:22 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Re: Crystal report for Kits

In my dashboard I have a BAQ with the Kit part, it's description, list code and price. With a filter of type='K'
The second BAQ in the dashboard pulls partmtl.partnum = part.partnum and haven't been successful linking the description list code or price for the partmtl.partnum...
----- Original Message -----
From: "Karen Schoenung" < kschoenung@...<mailto:kschoenung%40fisher-barton.com> <mailto:kschoenung%40fisher-barton.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Sent: Monday, May 21, 2012 12:23:36 PM
Subject: RE: [Vantage] Re: Crystal report for Kits

In the dashboard, the BAQs can EACH link to the part table...So, your first BAQ has the KIT part and links to the part table, the second BAQ has the partmtl and links to the part table to get the description...
Then in Crystal, you need to make the links between the two BAQs as you require them...

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 b_ordway
Sent: Saturday, May 19, 2012 1:43 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Crystal report for Kits

I would see if you can pull the descriptions from some other table.
Unfortunately I don't think 8.03 allows a second instance of the part table using an alias in a BAQ.
I switch over to an ODBC report sometimes when I run into this.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>, jdaniel1127@... wrote:
>
> I have the part.partnum and part.partdescription in the main crystal report for the kit part and trying to use a sub report for the partmtl to get the sub components in the kit. Is there a better way to do this??
>
> ----- Original Message -----
> From: "b_ordway" <cooner_55421@...<mailto:cooner_55421@...<mailto:cooner_55421@...%3cmailto:cooner_55421@...<mailto:cooner_55421@...%3cmailto:cooner_55421@...%3cmailto:cooner_55421@...%3cmailto:cooner_55421@...>>>>
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> Sent: Saturday, May 19, 2012 9:27:54 AM
> Subject: [Vantage] Re: Crystal report for Kits
>
> Â
>
>
>
>
> I usually link to the Part table if the description and group isn't already in the table I'm working with.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , "jamesd" <jdaniel1127@> wrote:
> >
> > Have a dashboard in Vantage 8.03.408B that displays the Kit part and the material parts with a filter by part, group or type. What I am trying to do is create a Crystal report from this so I can make a part catalog with part pictures. I have the parent kit part, description, group, price and .jpg in the crystal report and am trying to make a sub report for the kit components from the partmtl table. How do I get the description and group for these parts as they aren't in partmtl table?
> >
> > Thanks,
> >
> > James
> >
>
>
>
>
> [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]

[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]
2
Have a dashboard in Vantage 8.03.408B that displays the Kit part and the material parts with a filter by part, group or type. What I am trying to do is create a Crystal report from this so I can make a part catalog with part pictures. I have the parent kit part, description, group, price and .jpg in the crystal report and am trying to make a sub report for the kit components from the partmtl table. How do I get the description and group for these parts as they aren't in partmtl table?

Thanks,

James
3
I usually link to the Part table if the description and group isn't already in the table I'm working with.

--- In vantage@yahoogroups.com, "jamesd" <jdaniel1127@...> wrote:
>
> Have a dashboard in Vantage 8.03.408B that displays the Kit part and the material parts with a filter by part, group or type. What I am trying to do is create a Crystal report from this so I can make a part catalog with part pictures. I have the parent kit part, description, group, price and .jpg in the crystal report and am trying to make a sub report for the kit components from the partmtl table. How do I get the description and group for these parts as they aren't in partmtl table?
>
> Thanks,
>
> James
>
4
I have the part.partnum and part.partdescription in the main crystal report for the kit part and trying to use a sub report for the partmtl to get the sub components in the kit. Is there a better way to do this??

----- Original Message -----
From: "b_ordway" <cooner_55421@...>
To: vantage@yahoogroups.com
Sent: Saturday, May 19, 2012 9:27:54 AM
Subject: [Vantage] Re: Crystal report for Kits

Â




I usually link to the Part table if the description and group isn't already in the table I'm working with.

--- In vantage@yahoogroups.com , "jamesd" <jdaniel1127@...> wrote:
>
> Have a dashboard in Vantage 8.03.408B that displays the Kit part and the material parts with a filter by part, group or type. What I am trying to do is create a Crystal report from this so I can make a part catalog with part pictures. I have the parent kit part, description, group, price and .jpg in the crystal report and am trying to make a sub report for the kit components from the partmtl table. How do I get the description and group for these parts as they aren't in partmtl table?
>
> Thanks,
>
> James
>




[Non-text portions of this message have been removed]
5
I would see if you can pull the descriptions from some other table.
Unfortunately I don't think 8.03 allows a second instance of the part table using an alias in a BAQ.
I switch over to an ODBC report sometimes when I run into this.

--- In vantage@yahoogroups.com, jdaniel1127@... wrote:
>
> I have the part.partnum and part.partdescription in the main crystal report for the kit part and trying to use a sub report for the partmtl to get the sub components in the kit. Is there a better way to do this??
>
> ----- Original Message -----
> From: "b_ordway" <cooner_55421@...>
> To: vantage@yahoogroups.com
> Sent: Saturday, May 19, 2012 9:27:54 AM
> Subject: [Vantage] Re: Crystal report for Kits
>
> ÂÂ
>
>
>
>
> I usually link to the Part table if the description and group isn't already in the table I'm working with.
>
> --- In vantage@yahoogroups.com , "jamesd" <jdaniel1127@> wrote:
> >
> > Have a dashboard in Vantage 8.03.408B that displays the Kit part and the material parts with a filter by part, group or type. What I am trying to do is create a Crystal report from this so I can make a part catalog with part pictures. I have the parent kit part, description, group, price and .jpg in the crystal report and am trying to make a sub report for the kit components from the partmtl table. How do I get the description and group for these parts as they aren't in partmtl table?
> >
> > Thanks,
> >
> > James
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
In the dashboard, the BAQs can EACH link to the part table...So, your first BAQ has the KIT part and links to the part table, the second BAQ has the partmtl and links to the part table to get the description...
Then in Crystal, you need to make the links between the two BAQs as you require them...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of b_ordway
Sent: Saturday, May 19, 2012 1:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal report for Kits



I would see if you can pull the descriptions from some other table.
Unfortunately I don't think 8.03 allows a second instance of the part table using an alias in a BAQ.
I switch over to an ODBC report sometimes when I run into this.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, jdaniel1127@... wrote:
>
> I have the part.partnum and part.partdescription in the main crystal report for the kit part and trying to use a sub report for the partmtl to get the sub components in the kit. Is there a better way to do this??
>
> ----- Original Message -----
> From: "b_ordway" <cooner_55421@...<mailto:cooner_55421@...>>
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Sent: Saturday, May 19, 2012 9:27:54 AM
> Subject: [Vantage] Re: Crystal report for Kits
>
> Â
>
>
>
>
> I usually link to the Part table if the description and group isn't already in the table I'm working with.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> , "jamesd" <jdaniel1127@> wrote:
> >
> > Have a dashboard in Vantage 8.03.408B that displays the Kit part and the material parts with a filter by part, group or type. What I am trying to do is create a Crystal report from this so I can make a part catalog with part pictures. I have the parent kit part, description, group, price and .jpg in the crystal report and am trying to make a sub report for the kit components from the partmtl table. How do I get the description and group for these parts as they aren't in partmtl table?
> >
> > Thanks,
> >
> > James
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
7
In my dashboard I have a BAQÂ with the Kit part, it's description, list code and price. With a filter of type='K'
The second BAQ in the dashboard pulls partmtl.partnum = part.partnum and haven't been successful linking the description list code or price for the partmtl.partnum...
----- Original Message -----
From: "Karen Schoenung" <kschoenung@...>
To: vantage@yahoogroups.com
Sent: Monday, May 21, 2012 12:23:36 PM
Subject: RE: [Vantage] Re: Crystal report for Kits

Â




In the dashboard, the BAQs can EACH link to the part table...So, your first BAQ has the KIT part and links to the part table, the second BAQ has the partmtl and links to the part table to get the description...
Then in Crystal, you need to make the links between the two BAQs as you require them...

From: vantage@yahoogroups.com [mailto: vantage@yahoogroups.com ] On Behalf Of b_ordway
Sent: Saturday, May 19, 2012 1:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal report for Kits

I would see if you can pull the descriptions from some other table.
Unfortunately I don't think 8.03 allows a second instance of the part table using an alias in a BAQ.
I switch over to an ODBC report sometimes when I run into this.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>, jdaniel1127@... wrote:
>
> I have the part.partnum and part.partdescription in the main crystal report for the kit part and trying to use a sub report for the partmtl to get the sub components in the kit. Is there a better way to do this??
>
> ----- Original Message -----
> From: "b_ordway" <cooner_55421@...<mailto:cooner_55421@...>>
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Sent: Saturday, May 19, 2012 9:27:54 AM
> Subject: [Vantage] Re: Crystal report for Kits
>
> Â
>
>
>
>
> I usually link to the Part table if the description and group isn't already in the table I'm working with.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "jamesd" <jdaniel1127@> wrote:
> >
> > Have a dashboard in Vantage 8.03.408B that displays the Kit part and the material parts with a filter by part, group or type. What I am trying to do is create a Crystal report from this so I can make a part catalog with part pictures. I have the parent kit part, description, group, price and .jpg in the crystal report and am trying to make a sub report for the kit components from the partmtl table. How do I get the description and group for these parts as they aren't in partmtl table?
> >
> > Thanks,
> >
> > James
> >
>
>
>
>
> [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]
8
We wrote an ODBC report in Crystal that has the Part table in twice with the link to show the sub-material information to ensure production are using the correct materials when manufacturing.



--- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@...> wrote:
>
> I would see if you can pull the descriptions from some other table.
> Unfortunately I don't think 8.03 allows a second instance of the part table using an alias in a BAQ.
> I switch over to an ODBC report sometimes when I run into this.
>
> --- In vantage@yahoogroups.com, jdaniel1127@ wrote:
> >
> > I have the part.partnum and part.partdescription in the main crystal report for the kit part and trying to use a sub report for the partmtl to get the sub components in the kit. Is there a better way to do this??
> >
> > ----- Original Message -----
> > From: "b_ordway" <cooner_55421@>
> > To: vantage@yahoogroups.com
> > Sent: Saturday, May 19, 2012 9:27:54 AM
> > Subject: [Vantage] Re: Crystal report for Kits
> >
> > ÂÂ
> >
> >
> >
> >
> > I usually link to the Part table if the description and group isn't already in the table I'm working with.
> >
> > --- In vantage@yahoogroups.com , "jamesd" <jdaniel1127@> wrote:
> > >
> > > Have a dashboard in Vantage 8.03.408B that displays the Kit part and the material parts with a filter by part, group or type. What I am trying to do is create a Crystal report from this so I can make a part catalog with part pictures. I have the parent kit part, description, group, price and .jpg in the crystal report and am trying to make a sub report for the kit components from the partmtl table. How do I get the description and group for these parts as they aren't in partmtl table?
> > >
> > > Thanks,
> > >
> > > James
> > >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
9
Tracy,



Ok, currently everything we have is xml from Vantage reports. Can you share how you set up odbc and what your report looks like?



Thanks,



James



----- Original Message -----


From: "tracy.tmat" <tracy.smith@...>
To: vantage@yahoogroups.com
Sent: Tuesday, May 22, 2012 3:28:03 AM
Subject: [Vantage] Re: Crystal report for Kits

Â




We wrote an ODBC report in Crystal that has the Part table in twice with the link to show the sub-material information to ensure production are using the correct materials when manufacturing.

--- In vantage@yahoogroups.com , "b_ordway" <cooner_55421@...> wrote:
>
> I would see if you can pull the descriptions from some other table.
> Unfortunately I don't think 8.03 allows a second instance of the part table using an alias in a BAQ.
> I switch over to an ODBC report sometimes when I run into this.
>
> --- In vantage@yahoogroups.com , jdaniel1127@ wrote:
> >
> > I have the part.partnum and part.partdescription in the main crystal report for the kit part and trying to use a sub report for the partmtl to get the sub components in the kit. Is there a better way to do this??
> >
> > ----- Original Message -----
> > From: "b_ordway" <cooner_55421@>
> > To: vantage@yahoogroups.com
> > Sent: Saturday, May 19, 2012 9:27:54 AM
> > Subject: [Vantage] Re: Crystal report for Kits
> >
> > ÂÂ
> >
> >
> >
> >
> > I usually link to the Part table if the description and group isn't already in the table I'm working with.
> >
> > --- In vantage@yahoogroups.com , "jamesd" <jdaniel1127@> wrote:
> > >
> > > Have a dashboard in Vantage 8.03.408B that displays the Kit part and the material parts with a filter by part, group or type. What I am trying to do is create a Crystal report from this so I can make a part catalog with part pictures. I have the parent kit part, description, group, price and .jpg in the crystal report and am trying to make a sub report for the kit components from the partmtl table. How do I get the description and group for these parts as they aren't in partmtl table?
> > >
> > > Thanks,
> > >
> > > James
> > >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>




[Non-text portions of this message have been removed]
10
Haved just uploaded some screenshots for you into the photo section but they are not detailed instructions and not sure how they'll have come through.

As an overview you are connecting into Vantage and selecting the tables you want directly which means you can add the table twice (although it will check you wish to do this).

You'll then have to set any parameters you need to allow users to filter the data accordingly. I'm not an expert at this and the hardest part for me was getting all the ODBC to work correctly!

Let me know if it's any help anyway :)


--- In vantage@yahoogroups.com, jdaniel1127@... wrote:
>
>
>
> Tracy,
>
>
>
> Ok, currently everything we have is xml from Vantage reports. Can you share how you set up odbc and what your report looks like?
>
>
>
> Thanks,
>
>
>
> James
>
>
>
> ----- Original Message -----
>
>
> From: "tracy.tmat" <tracy.smith@...>
> To: vantage@yahoogroups.com
> Sent: Tuesday, May 22, 2012 3:28:03 AM
> Subject: [Vantage] Re: Crystal report for Kits
>
> ÂÂ
>
>
>
>
> We wrote an ODBC report in Crystal that has the Part table in twice with the link to show the sub-material information to ensure production are using the correct materials when manufacturing.
>
> --- In vantage@yahoogroups.com , "b_ordway" <cooner_55421@> wrote:
> >
> > I would see if you can pull the descriptions from some other table.
> > Unfortunately I don't think 8.03 allows a second instance of the part table using an alias in a BAQ.
> > I switch over to an ODBC report sometimes when I run into this.
> >
> > --- In vantage@yahoogroups.com , jdaniel1127@ wrote:
> > >
> > > I have the part.partnum and part.partdescription in the main crystal report for the kit part and trying to use a sub report for the partmtl to get the sub components in the kit. Is there a better way to do this??
> > >
> > > ----- Original Message -----
> > > From: "b_ordway" <cooner_55421@>
> > > To: vantage@yahoogroups.com
> > > Sent: Saturday, May 19, 2012 9:27:54 AM
> > > Subject: [Vantage] Re: Crystal report for Kits
> > >
> > > ÂÂÂ
> > >
> > >
> > >
> > >
> > > I usually link to the Part table if the description and group isn't already in the table I'm working with.
> > >
> > > --- In vantage@yahoogroups.com , "jamesd" <jdaniel1127@> wrote:
> > > >
> > > > Have a dashboard in Vantage 8.03.408B that displays the Kit part and the material parts with a filter by part, group or type. What I am trying to do is create a Crystal report from this so I can make a part catalog with part pictures. I have the parent kit part, description, group, price and .jpg in the crystal report and am trying to make a sub report for the kit components from the partmtl table. How do I get the description and group for these parts as they aren't in partmtl table?
> > > >
> > > > Thanks,
> > > >
> > > > James
> > > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
11
So you second BAQ has partmtl.partnum, part.partdescription, part.listcode?(not familiar with this field, maybe not in 803.409c), part.unitprice?

Then somehow you need to link the kit part to the partmtl in Crystal (not sure – we don’t use kits)

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jdaniel1127@...
Sent: Monday, May 21, 2012 4:22 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Crystal report for Kits



In my dashboard I have a BAQ with the Kit part, it's description, list code and price. With a filter of type='K'
The second BAQ in the dashboard pulls partmtl.partnum = part.partnum and haven't been successful linking the description list code or price for the partmtl.partnum...
----- Original Message -----
From: "Karen Schoenung" <kschoenung@...<mailto:kschoenung%40fisher-barton.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Monday, May 21, 2012 12:23:36 PM
Subject: RE: [Vantage] Re: Crystal report for Kits



In the dashboard, the BAQs can EACH link to the part table...So, your first BAQ has the KIT part and links to the part table, the second BAQ has the partmtl and links to the part table to get the description...
Then in Crystal, you need to make the links between the two BAQs as you require them...

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> ] On Behalf Of b_ordway
Sent: Saturday, May 19, 2012 1:43 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Crystal report for Kits

I would see if you can pull the descriptions from some other table.
Unfortunately I don't think 8.03 allows a second instance of the part table using an alias in a BAQ.
I switch over to an ODBC report sometimes when I run into this.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>, jdaniel1127@... wrote:
>
> I have the part.partnum and part.partdescription in the main crystal report for the kit part and trying to use a sub report for the partmtl to get the sub components in the kit. Is there a better way to do this??
>
> ----- Original Message -----
> From: "b_ordway" <cooner_55421@...<mailto:cooner_55421@...<mailto:cooner_55421@...%3cmailto:cooner_55421@...>>>
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> Sent: Saturday, May 19, 2012 9:27:54 AM
> Subject: [Vantage] Re: Crystal report for Kits
>
> Â
>
>
>
>
> I usually link to the Part table if the description and group isn't already in the table I'm working with.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , "jamesd" <jdaniel1127@> wrote:
> >
> > Have a dashboard in Vantage 8.03.408B that displays the Kit part and the material parts with a filter by part, group or type. What I am trying to do is create a Crystal report from this so I can make a part catalog with part pictures. I have the parent kit part, description, group, price and .jpg in the crystal report and am trying to make a sub report for the kit components from the partmtl table. How do I get the description and group for these parts as they aren't in partmtl table?
> >
> > Thanks,
> >
> > James
> >
>
>
>
>
> [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]



[Non-text portions of this message have been removed]
12
part.list code is used for pricing ( i.e. in the us we sell it for a different price than europe so the same part number has 2 codes and prices... )



In the partmtl there is a parent part field that gives me the kit part number and the mtlpartnum is the sub part. Problem is getting the part description, listcode and price  for the partmtl as they aren't in that table, they are in the part table...



----- Original Message -----


From: "Karen Schoenung" <kschoenung@...>
To: vantage@yahoogroups.com
Sent: Tuesday, May 22, 2012 10:15:52 AM
Subject: RE: [Vantage] Re: Crystal report for Kits

Â




So you second BAQ has partmtl.partnum, part.partdescription, part.listcode?(not familiar with this field, maybe not in 803.409c), part.unitprice?

Then somehow you need to link the kit part to the partmtl in Crystal (not sure – we don’t use kits)

From: vantage@yahoogroups.com [mailto: vantage@yahoogroups.com ] On Behalf Of jdaniel1127@...
Sent: Monday, May 21, 2012 4:22 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Crystal report for Kits



In my dashboard I have a BAQ with the Kit part, it's description, list code and price. With a filter of type='K'
The second BAQ in the dashboard pulls partmtl.partnum = part.partnum and haven't been successful linking the description list code or price for the partmtl.partnum...
----- Original Message -----
From: "Karen Schoenung" < kschoenung@... <mailto:kschoenung%40fisher-barton.com>>
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Monday, May 21, 2012 12:23:36 PM
Subject: RE: [Vantage] Re: Crystal report for Kits



In the dashboard, the BAQs can EACH link to the part table...So, your first BAQ has the KIT part and links to the part table, the second BAQ has the partmtl and links to the part table to get the description...
Then in Crystal, you need to make the links between the two BAQs as you require them...

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of b_ordway
Sent: Saturday, May 19, 2012 1:43 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Crystal report for Kits

I would see if you can pull the descriptions from some other table.
Unfortunately I don't think 8.03 allows a second instance of the part table using an alias in a BAQ.
I switch over to an ODBC report sometimes when I run into this.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>, jdaniel1127@... wrote:
>
> I have the part.partnum and part.partdescription in the main crystal report for the kit part and trying to use a sub report for the partmtl to get the sub components in the kit. Is there a better way to do this??
>
> ----- Original Message -----
> From: "b_ordway" <cooner_55421@...<mailto:cooner_55421@...<mailto:cooner_55421@...%3cmailto:cooner_55421@...>>>
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> Sent: Saturday, May 19, 2012 9:27:54 AM
> Subject: [Vantage] Re: Crystal report for Kits
>
> Â
>
>
>
>
> I usually link to the Part table if the description and group isn't already in the table I'm working with.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , "jamesd" <jdaniel1127@> wrote:
> >
> > Have a dashboard in Vantage 8.03.408B that displays the Kit part and the material parts with a filter by part, group or type. What I am trying to do is create a Crystal report from this so I can make a part catalog with part pictures. I have the parent kit part, description, group, price and .jpg in the crystal report and am trying to make a sub report for the kit components from the partmtl table. How do I get the description and group for these parts as they aren't in partmtl table?
> >
> > Thanks,
> >
> > James
> >
>
>
>
>
> [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]


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




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