Plamen - I'm pretty sure that Epicor broke something in 407 because I
experienced the same issue in 407A.
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
plamen21
Sent: Friday, January 22, 2010 6:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Proper steps to Modify a Crystal report - Add a
custom BAQ
Forgot to mention I am in 8.0.3.407c.
I tried linking via both inner and left outer joins, and in both directions.
Anybody who played with Resource Data Definitions out there?
Thanks,
Plamen
Systems Administrator
Art display Co.
Signs . Awnings .
Architectural Details
www.artdisplayco.com
--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Manasa
Reddy" <manasa@...> wrote:
Behalf
experienced the same issue in 407A.
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
plamen21
Sent: Friday, January 22, 2010 6:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Proper steps to Modify a Crystal report - Add a
custom BAQ
Forgot to mention I am in 8.0.3.407c.
I tried linking via both inner and left outer joins, and in both directions.
Anybody who played with Resource Data Definitions out there?
Thanks,
Plamen
Systems Administrator
Art display Co.
Signs . Awnings .
Architectural Details
www.artdisplayco.com
--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Manasa
Reddy" <manasa@...> wrote:
>[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Try opening up the report and click on the help link...it might have
> some info in there....
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> manasa@... <mailto:manasa@...>
>
> 800.852.2325
>
> 630.806.2000 ofc
>
> 630.806.2001 fax
>
> www.weldcoa.com
>
> ________________________________
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Behalf
> Of Dines, Tim<mailto:vantage%40yahoogroups.com>
> Sent: Thursday, January 21, 2010 3:02 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Re: Proper steps to Modify a Crystal report - Add
> a custom BAQ
>
>
>
>
>
> I agree. The key is missing and possibly some filtering. This all
> works very well in 8.03.408b, but you can only modify system reports if
> you have the SDK.
>
> Is there anywhere to get the definitions for reports like the Time
> Phased Material Requirements report that are not listed in the RDD?
>
> Tim Dines
>
> Information Technology
>
> Steel Parts Manufacturing, Inc.
>
> 801 Berryman Pike
>
> Tipton, IN 46072
>
> Direct: 765-675-5201
>
> Cell: 765-437-1402
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com<mailto:vantage%40yahoogroups.com> ] On
> Behalf<mailto:vantage%40yahoogroups.com>
> Of Manasa Reddy
> Sent: Thursday, January 21, 2010 3:46 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Re: Proper steps to Modify a Crystal report - Add<mailto:vantage%40yahoogroups.com>
> a custom BAQ
>
> All I am going to say is that if you are on an earlier version than
> 8.03, this is not going to work. That is, adding a table to your RDD.
>
> If you are at or beyond that version, then the Foreign key is probably
> your problem...make sure you linked the table correctly.
>
> M. Manasa Reddy
>
> manasa@... <mailto:manasa%40weldcoa.com>
> <mailto:manasa%40weldcoa.com> <mailto:
> manasa@... <mailto:manasa%40weldcoa.com>
> <mailto:manasa%40weldcoa.com> >
>
> 800.852.2325
>
> 630.806.2000 ofc
>
> 630.806.2001 fax
>
> www.weldcoa.com
>
> ________________________________
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> <mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> <mailto:vantage%40yahoogroups.com> ] On<mailto:vantage%40yahoogroups.com>
> Behalf
> Of plamen21
> Sent: Thursday, January 21, 2010 2:39 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> <mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Proper steps to Modify a Crystal report - Add a
> custom BAQ
>
> Ok I Duplicated the Report Data Definition, added the table I need
> [CustCnt] and excluded any of the unnecessary fields from that table.
>
> I am probably missing a step above on the RDD ['foreign key' comes to
> mind not sure why or how].
>
> Then I set my report to use the new RDD in Report Maintenance, preview
> it once to create the XML, so I can Set Datasource Location in Crystal,
> and so I can use the XML to pull the newly added table into the database
> fields.
>
> I think I am missing a step in RDD because even the Company Field is
> blank if I try to Browse Data in Crystal. Also the newly added table
> does not have any Indexed Fields (Red arrow) in Database Expert.
>
> Plamen
>
> Art Display Co.
> Signs * Awnings *
> Architectural Details
>
> 401 Hampton Park Boulevard
> Capitol Heights, MD 20743
> (P) 240-765-1400
> www.artdisplayco.com
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> <mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> "jckinneman" <jckinneman@> wrote:
> >
> >
> >
> >
> >
> >
> > You either need to modify the original report through a Custom Report
> Data Definition or create a new BAQ/Crystal Report. You can't add a
> custom BAQ to an existing crystal report.
> >
> > If you have support there are some examples on-line that explain some
> of the customizations you can do to existing reports. Search for "report
> definition crystal".
> >
> > Jim K.
> > En>compass Solutions Inc.
> > Tel 336.298.1296 (Google Voice)
> > Fax 336.217.7983
> > E-mail jimki@
> > www.encompass-inc.com
> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> <mailto:vantage%40yahoogroups.com>[Non-text portions of this message have been removed]
> <mailto:vantage%40yahoogroups.com> ,
> "plamen21" <plamen21@> wrote:
> > >
> > > Hello,
> > > I am trying to modify an existing Crystal system report to:
> > > Add the results of a custom query (BAQ) that I created.
> > > I have a just a custom BAQ just for the additional data.
> > > I am looking for the proper procedures (and sequence).
> > > Using Vantage 8.03.407C on Progress
> > >
> > >
> > > Plamen
> > >
> > > Systems Administrator
> > > Art Display Co.
> > >
> >
>
> [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]
>