If you are worried about duplicate data, you can usually sort that out in Crystal by using Report > Select Expert and using a formula.
E.g. if all of your data was in part number order, you could have a formula that says...
{Part.Number} <> previous({Part.Number})
This will only show unique part numbers.
________________________________
From: Mike Numbers <mnumbers@...>
To: vantage@yahoogroups.com
Sent: Tuesday, 21 August 2012, 19:30
Subject: RE: [Vantage] Subreport - linking
Â
No you are not missing something... I am. Didn't realize I had to have
only 1 BAQ, I will try to figure out how I can put all of the tables in the
same BAQ and pull out the data without duplicates.
Mike
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Tuesday, August 21, 2012 2:23 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Subreport - linking
You can't have 2 different BAQ's on the same report... how would you send
the data to it from Epicor... I think I am missing something
*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Tue, Aug 21, 2012 at 2:17 PM, Vic Drecchio
<vic.drecchio@...>wrote:
------------------------------------
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
[Non-text portions of this message have been removed]
E.g. if all of your data was in part number order, you could have a formula that says...
{Part.Number} <> previous({Part.Number})
This will only show unique part numbers.
________________________________
From: Mike Numbers <mnumbers@...>
To: vantage@yahoogroups.com
Sent: Tuesday, 21 August 2012, 19:30
Subject: RE: [Vantage] Subreport - linking
Â
No you are not missing something... I am. Didn't realize I had to have
only 1 BAQ, I will try to figure out how I can put all of the tables in the
same BAQ and pull out the data without duplicates.
Mike
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Tuesday, August 21, 2012 2:23 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Subreport - linking
You can't have 2 different BAQ's on the same report... how would you send
the data to it from Epicor... I think I am missing something
*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Tue, Aug 21, 2012 at 2:17 PM, Vic Drecchio
<vic.drecchio@...>wrote:
> **sub.
>
>
> It sounds like you didn't link the master to the sub correctly.
>
> Right click on the subreport and choose "Change Subreport Links". Make
> sure your Param fields in the master are linked to the Param fields in the
>[Non-text portions of this message have been removed]
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of mike.numbers
> Sent: Tuesday, August 21, 2012 2:01 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Subreport - linking
>
>
> I am creating my first subreport. I have created the master report and
> also a second report that I want to be my subreport. Both reports are
> BAQ to Crystal. I have inserted the 2nd report in the master report. I
> have linked (I think) the 2 reports in the Subreport Link screen. I
> have 3 fields in the master that will link with 3 fields in subreport.
> I have reviewed the lower section of this screen where it shows the
> linking fields from both reports and they look correct to me. The
> problem I have is when I run the master report, I get the Enter
> Parameter Values screen and it lists my 3 fields that I identified in
> the master report. It's like they are not picking up the values.
> Any ideas?
>
> 9.04.507a
> Crystal - 11.5.3.417
> Mike
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2197 / Virus Database: 2437/5213 - Release Date:
> 08/21/12
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2197 / Virus Database: 2437/5213 - Release Date:
> 08/21/12
>
>
> [Non-text portions of this message have been removed]
>
>
>
------------------------------------
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
[Non-text portions of this message have been removed]