A guess: I got duplicated records once, modifying another report to add
a table. Turns out the XML data had a field called something like
CalcLineNum, and I needed to use that when linking tables in Crystal, in
addition to the normal links.
Brian.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Keith
Sent: Friday, August 12, 2011 1:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Duplicate Records in Crystal - Order
Acknowledgement
I got it fixed... but still do not know what is causing it.
In section expert, i added a formula for "Surpress (No Drill-Down)".
Formula is basically this:
({tbl.field} = previous({tbl.field}).
symptom treated... would still love to treat the cause.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Keith" <keithfwalter@...> wrote:
table i "imported": CustCnt
to Company; CustNum to CustNum. I duplicated this "join" in Crystal when
i brought in this new table.
record. This subreport is then used by APM to auto-email the SOA report
to those contacts selected. I have done this before... nothing fancy...
this is straight out of Epicor Training for customizing reports. Std
functionality.
logical linkage.
2) creating a whole new data-set for this report using a BAQ-Report
(ug).
bit tricky. If you want to display the contact referenced in the
attention (ordered.prcconnum) field that is available in the standard
rdd format I believe. If you can elaborate on what you want to have
happen maybe someone can be more helpful. Good luck.
Behalf Of Keith Walter
section of the report repeats for every contact record... if there are 2
contacts, then each release will duplicate on the report twice; 4
contacts? Release prints 4 times.
OrderHed on Company and CustNum. I also added a check box to the
customer contact form in Vantage to key off of for inclusion, and i
added a "criteria" for this in the report data def.
a table. Turns out the XML data had a field called something like
CalcLineNum, and I needed to use that when linking tables in Crystal, in
addition to the normal links.
Brian.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Keith
Sent: Friday, August 12, 2011 1:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Duplicate Records in Crystal - Order
Acknowledgement
I got it fixed... but still do not know what is causing it.
In section expert, i added a formula for "Surpress (No Drill-Down)".
Formula is basically this:
({tbl.field} = previous({tbl.field}).
symptom treated... would still love to treat the cause.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Keith" <keithfwalter@...> wrote:
>selection expert in crystal?
> cooner, no joy. is there a way to limit repeated records using the
>"cooner_55421" <cooner_55421@> wrote:
> thanks,
> keith
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> >"Keith" <keithfwalter@> wrote:
> > > So, Why then,
> > > Relationships between OrderHed and CustCnt:
> > Company to Company;
> > CustNum to CustNum.
> >
> >
> > Maybe try another relatuionship line?
> > OrderHed.ShipToNum --> CustCnt.ShipToNum
> >
> >
> > Just a guess, the primary index for CustCnt:
> > Company,CustNum.ShipToNum,ConNum
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > >subreport links... but there is only one table on the subreport... the
> > > Thanks for the feedback guys. So, yes, i have played with the
table i "imported": CustCnt
> > >Vantage, and added relationships between OrderHed and CustCnt: Company
> > > I added this table via the Report Data Maintenance screen in
to Company; CustNum to CustNum. I duplicated this "join" in Crystal when
i brought in this new table.
> > >sold-to customer that have Checkbox01 selected on the customer contact
> > > The objective is to include on the report, all contacts for the
record. This subreport is then used by APM to auto-email the SOA report
to those contacts selected. I have done this before... nothing fancy...
this is straight out of Epicor Training for customizing reports. Std
functionality.
> > >detail secion of the report that displays Releases? I cannot find any
> > > So, Why then, when i add this CustCnt table, is it effecting the
logical linkage.
> > >promissing work-around, how is that done?
> > > Surpressing duplicate records on the crystal side sounds like a
> > >datasource directly to sql via ODBC for the customer-contact table, or
> > > The only alternatives I can think of are to 1) setup a new
2) creating a whole new data-set for this report using a BAQ-Report
(ug).
> > >, Keith Mailloux <keith.mailloux@> wrote:
> > > -Keith
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > >format the release sections to not print duplicate lines which can be a
> > > > Do you want to display all of the contact names? If so you can
bit tricky. If you want to display the contact referenced in the
attention (ordered.prcconnum) field that is available in the standard
rdd format I believe. If you can elaborate on what you want to have
happen maybe someone can be more helpful. Good luck.
> > > >[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > > > Keith
> > > >
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Behalf Of Keith Walter
> > > > Sent: Thursday, August 11, 2011 5:04 PMAcknowledgement
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Duplicate Records in Crystal - Order
> > > >subreport to display customer contacts. Since adding, the release
> > > >
> > > >
> > > > I modified the Sales Order Acknowledgement report by adding a
section of the report repeats for every contact record... if there are 2
contacts, then each release will duplicate on the report twice; 4
contacts? Release prints 4 times.
> > > >and set the relationships. I added a the table CustCnt, and linked it to
> > > > All i did was add a subreport to the report, import a new table,
OrderHed on Company and CustNum. I also added a check box to the
customer contact form in Vantage to key off of for inclusion, and i
added a "criteria" for this in the report data def.
> > > >try to fix?
> > > > Has anyone ever seen this? Any ideas on things I can look at to
> > > >this
> > > > Thanks
> > > >
> > > > Keith Walter
> > > > Vantage Coordinator
> > > > Norgren Automation Solutions
> > > > keith.walter@<mailto:keith.walter%40norgrenauto.com>
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > > > ---------------------------------
> > > > This e-mail and any attachments may contain confidential and
> > > > privileged information. If you are not the intended recipient,
> > > > please notify the sender immediately by return e-mail, delete
> > > > e-mail and destroy any copies. Any dissemination or use of this[Non-text portions of this message have been removed]
> > > > information by a person other than the intended recipient is
> > > > unauthorized and may be illegal.
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
>