Duplicate Records in Crystal - Order Acknowledgement

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:
>
> cooner, no joy. is there a way to limit repeated records using the
selection expert in crystal?
>
> thanks,
> keith
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"cooner_55421" <cooner_55421@> 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> ,
"Keith" <keithfwalter@> wrote:
> > >
> > > Thanks for the feedback guys. So, yes, i have played with the
subreport links... but there is only one table on the subreport... the
table i "imported": CustCnt
> > >
> > > I added this table via the Report Data Maintenance screen in
Vantage, and added relationships between OrderHed and CustCnt: Company
to Company; CustNum to CustNum. I duplicated this "join" in Crystal when
i brought in this new table.
> > >
> > > The objective is to include on the report, all contacts for the
sold-to customer that have Checkbox01 selected on the customer contact
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.
> > >
> > > So, Why then, when i add this CustCnt table, is it effecting the
detail secion of the report that displays Releases? I cannot find any
logical linkage.
> > >
> > > Surpressing duplicate records on the crystal side sounds like a
promissing work-around, how is that done?
> > >
> > > The only alternatives I can think of are to 1) setup a new
datasource directly to sql via ODBC for the customer-contact table, or
2) creating a whole new data-set for this report using a BAQ-Report
(ug).
> > >
> > > -Keith
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
, Keith Mailloux <keith.mailloux@> wrote:
> > > >
> > > > Do you want to display all of the contact names? If so you can
format the release sections to not print duplicate lines which can be a
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.
> > > >
> > > > Keith
> > > >
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Keith Walter
> > > > Sent: Thursday, August 11, 2011 5:04 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Duplicate Records in Crystal - Order
Acknowledgement
> > > >
> > > >
> > > >
> > > > I modified the Sales Order Acknowledgement report by adding a
subreport to display customer contacts. Since adding, the release
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.
> > > >
> > > > All i did was add a subreport to the report, import a new table,
and set the relationships. I added a the table CustCnt, and linked it to
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.
> > > >
> > > > Has anyone ever seen this? Any ideas on things I can look at to
try to fix?
> > > >
> > > > 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
this
> > > > e-mail and destroy any copies. Any dissemination or use of this
> > > > information by a person other than the intended recipient is
> > > > unauthorized and may be illegal.
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
>





[Non-text portions of this message have been removed]
I modified the Sales Order Acknowledgement report by adding a subreport to display customer contacts.  Since adding, the release 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.Â
Â
All i did was add a subreport to the report, import a new table, and set the relationships. I added a the table CustCnt, and linked it to 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.
Â
Has anyone ever seen this? Any ideas on things I can look at to try to fix?
Â
Thanks

Keith Walter
Vantage Coordinator
Norgren Automation Solutions
keith.walter@...

[Non-text portions of this message have been removed]
How did you 'import a new table'? I'd wager that's where the issue is coming
from.

On Thu, Aug 11, 2011 at 5:26 PM, cooner_55421 <cooner_55421@...>wrote:

> **
>
>
> >and linked it to OrderHed on Company and CustNum
> Just a wild guess.... what about the SubReport links?
> --- right click on the sub-report and select "Change Subreport Links"
>
> --- In vantage@yahoogroups.com, Keith Walter <keithfwalter@...> wrote:
> >
> > I modified the Sales Order Acknowledgement report by adding a subreport
> to display customer contacts.������Since adding, the release 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.���
> > ���
> > All i did was add a subreport to the report, import a new table, and set
> the relationships.��� I added a���the table CustCnt, and linked it to
> 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.
> > ���
> > Has anyone ever seen this?��� Any ideas on things I can look at to try to
> fix?
> > ���
>
> > Thanks
> >
> > Keith Walter
> > Vantage Coordinator
> > Norgren Automation Solutions
> > keith.walter@...
>
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
Do you want to display all of the contact names? If so you can format the release sections to not print duplicate lines which can be a 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.

Keith

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Keith Walter
Sent: Thursday, August 11, 2011 5:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Duplicate Records in Crystal - Order Acknowledgement



I modified the Sales Order Acknowledgement report by adding a subreport to display customer contacts. Since adding, the release 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.

All i did was add a subreport to the report, import a new table, and set the relationships. I added a the table CustCnt, and linked it to 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.

Has anyone ever seen this? Any ideas on things I can look at to try to fix?

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 this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]
Thanks for the feedback guys. So, yes, i have played with the subreport links... but there is only one table on the subreport... the table i "imported": CustCnt

I added this table via the Report Data Maintenance screen in Vantage, and added relationships between OrderHed and CustCnt: Company to Company; CustNum to CustNum. I duplicated this "join" in Crystal when i brought in this new table.

The objective is to include on the report, all contacts for the sold-to customer that have Checkbox01 selected on the customer contact 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.

So, Why then, when i add this CustCnt table, is it effecting the detail secion of the report that displays Releases? I cannot find any logical linkage.

Surpressing duplicate records on the crystal side sounds like a promissing work-around, how is that done?

The only alternatives I can think of are to 1) setup a new datasource directly to sql via ODBC for the customer-contact table, or 2) creating a whole new data-set for this report using a BAQ-Report (ug).

-Keith

--- In vantage@yahoogroups.com, Keith Mailloux <keith.mailloux@...> wrote:
>
> Do you want to display all of the contact names? If so you can format the release sections to not print duplicate lines which can be a 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.
>
> Keith
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Keith Walter
> Sent: Thursday, August 11, 2011 5:04 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Duplicate Records in Crystal - Order Acknowledgement
>
>
>
> I modified the Sales Order Acknowledgement report by adding a subreport to display customer contacts. Since adding, the release 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.
>
> All i did was add a subreport to the report, import a new table, and set the relationships. I added a the table CustCnt, and linked it to 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.
>
> Has anyone ever seen this? Any ideas on things I can look at to try to fix?
>
> 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 this
> e-mail and destroy any copies. Any dissemination or use of this
> information by a person other than the intended recipient is
> unauthorized and may be illegal.
>
> [Non-text portions of this message have been removed]
>
cooner, no joy. is there a way to limit repeated records using the selection expert in crystal?

thanks,
keith

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> 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, "Keith" <keithfwalter@> wrote:
> >
> > Thanks for the feedback guys. So, yes, i have played with the subreport links... but there is only one table on the subreport... the table i "imported": CustCnt
> >
> > I added this table via the Report Data Maintenance screen in Vantage, and added relationships between OrderHed and CustCnt: Company to Company; CustNum to CustNum. I duplicated this "join" in Crystal when i brought in this new table.
> >
> > The objective is to include on the report, all contacts for the sold-to customer that have Checkbox01 selected on the customer contact 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.
> >
> > So, Why then, when i add this CustCnt table, is it effecting the detail secion of the report that displays Releases? I cannot find any logical linkage.
> >
> > Surpressing duplicate records on the crystal side sounds like a promissing work-around, how is that done?
> >
> > The only alternatives I can think of are to 1) setup a new datasource directly to sql via ODBC for the customer-contact table, or 2) creating a whole new data-set for this report using a BAQ-Report (ug).
> >
> > -Keith
> >
> > --- In vantage@yahoogroups.com, Keith Mailloux <keith.mailloux@> wrote:
> > >
> > > Do you want to display all of the contact names? If so you can format the release sections to not print duplicate lines which can be a 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.
> > >
> > > Keith
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Keith Walter
> > > Sent: Thursday, August 11, 2011 5:04 PM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Duplicate Records in Crystal - Order Acknowledgement
> > >
> > >
> > >
> > > I modified the Sales Order Acknowledgement report by adding a subreport to display customer contacts. Since adding, the release 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.
> > >
> > > All i did was add a subreport to the report, import a new table, and set the relationships. I added a the table CustCnt, and linked it to 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.
> > >
> > > Has anyone ever seen this? Any ideas on things I can look at to try to fix?
> > >
> > > 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 this
> > > e-mail and destroy any copies. Any dissemination or use of this
> > > information by a person other than the intended recipient is
> > > unauthorized and may be illegal.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
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, "Keith" <keithfwalter@...> wrote:
>
> cooner, no joy. is there a way to limit repeated records using the selection expert in crystal?
>
> thanks,
> keith
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> 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, "Keith" <keithfwalter@> wrote:
> > >
> > > Thanks for the feedback guys. So, yes, i have played with the subreport links... but there is only one table on the subreport... the table i "imported": CustCnt
> > >
> > > I added this table via the Report Data Maintenance screen in Vantage, and added relationships between OrderHed and CustCnt: Company to Company; CustNum to CustNum. I duplicated this "join" in Crystal when i brought in this new table.
> > >
> > > The objective is to include on the report, all contacts for the sold-to customer that have Checkbox01 selected on the customer contact 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.
> > >
> > > So, Why then, when i add this CustCnt table, is it effecting the detail secion of the report that displays Releases? I cannot find any logical linkage.
> > >
> > > Surpressing duplicate records on the crystal side sounds like a promissing work-around, how is that done?
> > >
> > > The only alternatives I can think of are to 1) setup a new datasource directly to sql via ODBC for the customer-contact table, or 2) creating a whole new data-set for this report using a BAQ-Report (ug).
> > >
> > > -Keith
> > >
> > > --- In vantage@yahoogroups.com, Keith Mailloux <keith.mailloux@> wrote:
> > > >
> > > > Do you want to display all of the contact names? If so you can format the release sections to not print duplicate lines which can be a 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.
> > > >
> > > > Keith
> > > >
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Keith Walter
> > > > Sent: Thursday, August 11, 2011 5:04 PM
> > > > To: vantage@yahoogroups.com
> > > > Subject: [Vantage] Duplicate Records in Crystal - Order Acknowledgement
> > > >
> > > >
> > > >
> > > > I modified the Sales Order Acknowledgement report by adding a subreport to display customer contacts. Since adding, the release 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.
> > > >
> > > > All i did was add a subreport to the report, import a new table, and set the relationships. I added a the table CustCnt, and linked it to 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.
> > > >
> > > > Has anyone ever seen this? Any ideas on things I can look at to try to fix?
> > > >
> > > > 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 this
> > > > e-mail and destroy any copies. Any dissemination or use of this
> > > > information by a person other than the intended recipient is
> > > > unauthorized and may be illegal.
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
>