[E9] Adding Custom Parameters to Crystal Report

Yahoo Archive
1
I have created multiple report styles for the various filters I need
On 2013-07-11 8:24 AM, "adamnoffie" <ygroups.adamleer@...> wrote:

> **
>
>
> What solution did you use Ephraim?
>
> --- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
> >
> > Thanks for the solution.
> >
> > I used your idea and it works fine
> > On 2013-07-05 8:39 AM, "adamnoffie" <ygroups.adamleer@...> wrote:
> >
> > > **
> > >
> > >
> > > I never figured that out, but would be curious to know how someone else
> > > did it if they did it. For now, I'm just maintaining multiple reports
> and
> > > report styles, which is the pain I hoped to avoid with a custom report
> > > parameter.
> > >
> > > --- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@> wrote:
> > > >
> > > > It seems that on regular report you dont have the UD fields
> > > > I also use it in BAQ report many times but now i try in a regular
> report
> > > > and its not there
> > > >
> > > > can you guide me tru how you would do it with a UD table?
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
2
We have customized a Standard Crystal Epicor Report (Aged Receivables), and would like to pass an extra parameter from the customized report form to the output report xml passed to Crystal.

We've tried binding our new text field to the ReportCurrencyCode field in RptParameters table, and then referencing that in the rpt file, but apparently it is overwritten by Epicor when the report runs - it ends up being "USD" in the report always.

Passing a custom parameter seems like it would be a really common requirement for customizing these reports, but the internet and the Epicor documentation has surprisingly little to say about the subject! Any assistance on this report, or on the subject in general, would be greatly appreciated.

Thanks,
Adam

Epicor 9.05.700C, SQL 64-bit
3
The RPtParameter table has Character01-05 Number01-05 and Check01-05 this
works fine, and I use it daily.



*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, Apr 16, 2013 at 9:42 AM, adamnoffie <ygroups.adamleer@...>wrote:

> **
>
>
> We have customized a Standard Crystal Epicor Report (Aged Receivables),
> and would like to pass an extra parameter from the customized report form
> to the output report xml passed to Crystal.
>
> We've tried binding our new text field to the ReportCurrencyCode field in
> RptParameters table, and then referencing that in the rpt file, but
> apparently it is overwritten by Epicor when the report runs - it ends up
> being "USD" in the report always.
>
> Passing a custom parameter seems like it would be a really common
> requirement for customizing these reports, but the internet and the Epicor
> documentation has surprisingly little to say about the subject! Any
> assistance on this report, or on the subject in general, would be greatly
> appreciated.
>
> Thanks,
> Adam
>
> Epicor 9.05.700C, SQL 64-bit
>
>
>


[Non-text portions of this message have been removed]
4
You can also setup a parameter in Crystal, but then that requires your user to preview the report before printing...

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, April 16, 2013 8:46 AM
To: Vantage
Subject: Re: [Vantage] [E9] Adding Custom Parameters to Crystal Report

The RPtParameter table has Character01-05 Number01-05 and Check01-05 this works fine, and I use it daily.



*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, Apr 16, 2013 at 9:42 AM, adamnoffie <ygroups.adamleer@...>wrote:

> **
>
>
> We have customized a Standard Crystal Epicor Report (Aged
> Receivables), and would like to pass an extra parameter from the
> customized report form to the output report xml passed to Crystal.
>
> We've tried binding our new text field to the ReportCurrencyCode field
> in RptParameters table, and then referencing that in the rpt file, but
> apparently it is overwritten by Epicor when the report runs - it ends
> up being "USD" in the report always.
>
> Passing a custom parameter seems like it would be a really common
> requirement for customizing these reports, but the internet and the
> Epicor documentation has surprisingly little to say about the subject!
> Any assistance on this report, or on the subject in general, would be
> greatly appreciated.
>
> Thanks,
> Adam
>
> Epicor 9.05.700C, SQL 64-bit
>
>
>


[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
5
Jose,

Thanks for the quick reply.

Unfortunately we do not have any UD fields of any kind in the RptParameter table - I looked both in the EpiBinding of the report form customization and the table in the Crystal report itself:
http://static.inky.ws/image/3849/screenshot_2013-04-16_100836.png
http://static.inky.ws/image/3850/screenshot_2013-04-16_101640.png

Maybe the Aged Receivables report doesn't have this, but others do?
Maybe we need the Epicor SDK to do this?

Thanks,
Adam

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> The RPtParameter table has Character01-05 Number01-05 and Check01-05 this
> works fine, and I use it daily.
>
>
>
> *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, Apr 16, 2013 at 9:42 AM, adamnoffie <ygroups.adamleer@...>wrote:
>
> > **
> >
> >
> > We have customized a Standard Crystal Epicor Report (Aged Receivables),
> > and would like to pass an extra parameter from the customized report form
> > to the output report xml passed to Crystal.
> >
> > We've tried binding our new text field to the ReportCurrencyCode field in
> > RptParameters table, and then referencing that in the rpt file, but
> > apparently it is overwritten by Epicor when the report runs - it ends up
> > being "USD" in the report always.
> >
> > Passing a custom parameter seems like it would be a really common
> > requirement for customizing these reports, but the internet and the Epicor
> > documentation has surprisingly little to say about the subject! Any
> > assistance on this report, or on the subject in general, would be greatly
> > appreciated.
> >
> > Thanks,
> > Adam
> >
> > Epicor 9.05.700C, SQL 64-bit
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
6
Thanks Karen. We figured this much out, but were hoping to go the more natural route of putting the parameter entry in the report form.

--- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@...> wrote:
>
> You can also setup a parameter in Crystal, but then that requires your user to preview the report before printing...
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
> Sent: Tuesday, April 16, 2013 8:46 AM
> To: Vantage
> Subject: Re: [Vantage] [E9] Adding Custom Parameters to Crystal Report
>
> The RPtParameter table has Character01-05 Number01-05 and Check01-05 this works fine, and I use it daily.
>
>
>
> *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, Apr 16, 2013 at 9:42 AM, adamnoffie <ygroups.adamleer@...>wrote:
>
> > **
> >
> >
> > We have customized a Standard Crystal Epicor Report (Aged
> > Receivables), and would like to pass an extra parameter from the
> > customized report form to the output report xml passed to Crystal.
> >
> > We've tried binding our new text field to the ReportCurrencyCode field
> > in RptParameters table, and then referencing that in the rpt file, but
> > apparently it is overwritten by Epicor when the report runs - it ends
> > up being "USD" in the report always.
> >
> > Passing a custom parameter seems like it would be a really common
> > requirement for customizing these reports, but the internet and the
> > Epicor documentation has surprisingly little to say about the subject!
> > Any assistance on this report, or on the subject in general, would be
> > greatly appreciated.
> >
> > Thanks,
> > Adam
> >
> > Epicor 9.05.700C, SQL 64-bit
> >
> >
> >
>
>
> [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
>
7
Jose right

Customize your Report Form where the parameters are entered putting a new
field and binding it to ReportParam.[Character01-05, Number01-05, or
Check01-05]. Then this value gets passed to the Crystal Report which you
can use to for filtering or record selection in the report. I also do this
on numerous reports

Scott

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
adamnoffie
Sent: Tuesday, April 16, 2013 10:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [E9] Adding Custom Parameters to Crystal Report


Thanks Karen. We figured this much out, but were hoping to go the more
natural route of putting the parameter entry in the report form.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Karen
Schoenung <kschoenung@...> wrote:
>
> You can also setup a parameter in Crystal, but then that requires your
user to preview the report before printing...
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Jose Gomez
> Sent: Tuesday, April 16, 2013 8:46 AM
> To: Vantage
> Subject: Re: [Vantage] [E9] Adding Custom Parameters to Crystal Report
>
> The RPtParameter table has Character01-05 Number01-05 and Check01-05 this
works fine, and I use it daily.
>
>
>
> *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, Apr 16, 2013 at 9:42 AM, adamnoffie <ygroups.adamleer@...>wrote:
>
> > **
> >
> >
> > We have customized a Standard Crystal Epicor Report (Aged
> > Receivables), and would like to pass an extra parameter from the
> > customized report form to the output report xml passed to Crystal.
> >
> > We've tried binding our new text field to the ReportCurrencyCode field
> > in RptParameters table, and then referencing that in the rpt file, but
> > apparently it is overwritten by Epicor when the report runs - it ends
> > up being "USD" in the report always.
> >
> > Passing a custom parameter seems like it would be a really common
> > requirement for customizing these reports, but the internet and the
> > Epicor documentation has surprisingly little to say about the subject!
> > Any assistance on this report, or on the subject in general, would be
> > greatly appreciated.
> >
> > Thanks,
> > Adam
> >
> > Epicor 9.05.700C, SQL 64-bit
> >
> >
> >
>
>
> [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/.
<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]
8
Scott,

Thanks - however, I'm not seeing where this is possible, at least not on this report. Here was my response to Jose:

Unfortunately we do not have any UD fields of any kind
in the RptParameter table - I looked both in the EpiBinding
of the report form customization and the table in the
Crystal report itself:
http://static.inky.ws/image/3849/screenshot_2013-04-16_100836.png
http://static.inky.ws/image/3850/screenshot_2013-04-16_101640.png

Maybe the Aged Receivables report doesn't have this, but others do?
Maybe we need the Epicor SDK to do this?


--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...> wrote:
>
> Jose right
>
> Customize your Report Form where the parameters are entered putting a new
> field and binding it to ReportParam.[Character01-05, Number01-05, or
> Check01-05]. Then this value gets passed to the Crystal Report which you
> can use to for filtering or record selection in the report. I also do this
> on numerous reports
>
> Scott
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> adamnoffie
> Sent: Tuesday, April 16, 2013 10:22 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: [E9] Adding Custom Parameters to Crystal Report
>
>
> Thanks Karen. We figured this much out, but were hoping to go the more
> natural route of putting the parameter entry in the report form.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Karen
> Schoenung <kschoenung@> wrote:
> >
> > You can also setup a parameter in Crystal, but then that requires your
> user to preview the report before printing...
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of Jose Gomez
> > Sent: Tuesday, April 16, 2013 8:46 AM
> > To: Vantage
> > Subject: Re: [Vantage] [E9] Adding Custom Parameters to Crystal Report
> >
> > The RPtParameter table has Character01-05 Number01-05 and Check01-05 this
> works fine, and I use it daily.
> >
> >
> >
> > *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, Apr 16, 2013 at 9:42 AM, adamnoffie <ygroups.adamleer@>wrote:
> >
> > > **
> > >
> > >
> > > We have customized a Standard Crystal Epicor Report (Aged
> > > Receivables), and would like to pass an extra parameter from the
> > > customized report form to the output report xml passed to Crystal.
> > >
> > > We've tried binding our new text field to the ReportCurrencyCode field
> > > in RptParameters table, and then referencing that in the rpt file, but
> > > apparently it is overwritten by Epicor when the report runs - it ends
> > > up being "USD" in the report always.
> > >
> > > Passing a custom parameter seems like it would be a really common
> > > requirement for customizing these reports, but the internet and the
> > > Epicor documentation has surprisingly little to say about the subject!
> > > Any assistance on this report, or on the subject in general, would be
> > > greatly appreciated.
> > >
> > > Thanks,
> > > Adam
> > >
> > > Epicor 9.05.700C, SQL 64-bit
> > >
> > >
> > >
> >
> >
> > [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/.
> <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]
>
9
Thta's weird most reports have it. You cuold do something really crappy and
add a UD table to the RDD and then shove the values you want in that UD
Table.


*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, Apr 16, 2013 at 12:07 PM, adamnoffie <ygroups.adamleer@...>wrote:

> **
>
>
>
>
> Scott,
>
> Thanks - however, I'm not seeing where this is possible, at least not on
> this report. Here was my response to Jose:
>
>
> Unfortunately we do not have any UD fields of any kind
> in the RptParameter table - I looked both in the EpiBinding
> of the report form customization and the table in the
> Crystal report itself:
> http://static.inky.ws/image/3849/screenshot_2013-04-16_100836.png
> http://static.inky.ws/image/3850/screenshot_2013-04-16_101640.png
>
> Maybe the Aged Receivables report doesn't have this, but others do?
> Maybe we need the Epicor SDK to do this?
>
> --- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...> wrote:
> >
> > Jose right
> >
> > Customize your Report Form where the parameters are entered putting a new
> > field and binding it to ReportParam.[Character01-05, Number01-05, or
> > Check01-05]. Then this value gets passed to the Crystal Report which you
> > can use to for filtering or record selection in the report. I also do
> this
> > on numerous reports
> >
> > Scott
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > adamnoffie
> > Sent: Tuesday, April 16, 2013 10:22 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: [E9] Adding Custom Parameters to Crystal Report
> >
> >
> > Thanks Karen. We figured this much out, but were hoping to go the more
> > natural route of putting the parameter entry in the report form.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> Karen
> > Schoenung <kschoenung@> wrote:
> > >
> > > You can also setup a parameter in Crystal, but then that requires your
> > user to preview the report before printing...
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of Jose Gomez
> > > Sent: Tuesday, April 16, 2013 8:46 AM
> > > To: Vantage
> > > Subject: Re: [Vantage] [E9] Adding Custom Parameters to Crystal Report
> > >
> > > The RPtParameter table has Character01-05 Number01-05 and Check01-05
> this
> > works fine, and I use it daily.
> > >
> > >
> > >
> > > *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, Apr 16, 2013 at 9:42 AM, adamnoffie <ygroups.adamleer@>wrote:
>
> > >
> > > > **
> > > >
> > > >
> > > > We have customized a Standard Crystal Epicor Report (Aged
> > > > Receivables), and would like to pass an extra parameter from the
> > > > customized report form to the output report xml passed to Crystal.
> > > >
> > > > We've tried binding our new text field to the ReportCurrencyCode
> field
> > > > in RptParameters table, and then referencing that in the rpt file,
> but
> > > > apparently it is overwritten by Epicor when the report runs - it
> ends
> > > > up being "USD" in the report always.
> > > >
> > > > Passing a custom parameter seems like it would be a really common
> > > > requirement for customizing these reports, but the internet and the
> > > > Epicor documentation has surprisingly little to say about the
> subject!
> > > > Any assistance on this report, or on the subject in general, would
> be
> > > > greatly appreciated.
> > > >
> > > > Thanks,
> > > > Adam
> > > >
> > > > Epicor 9.05.700C, SQL 64-bit
> > > >
> > > >
> > > >
> > >
> > >
> > > [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/.
> > <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]
> >
>
>
>


[Non-text portions of this message have been removed]
10
UGH! Define "heresy" please see last post lol!



Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

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

From: "Jose Gomez" <jose@...>
To: "Vantage" <vantage@yahoogroups.com>
Sent: Tuesday, April 16, 2013 11:38:11 AM
Subject: Re: [Vantage] Re: [E9] Adding Custom Parameters to Crystal Report

Thta's weird most reports have it. You cuold do something really crappy and
add a UD table to the RDD and then shove the values you want in that UD
Table.


*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, Apr 16, 2013 at 12:07 PM, adamnoffie <ygroups.adamleer@...>wrote:

> **
>
>
>
>
> Scott,
>
> Thanks - however, I'm not seeing where this is possible, at least not on
> this report. Here was my response to Jose:
>
>
> Unfortunately we do not have any UD fields of any kind
> in the RptParameter table - I looked both in the EpiBinding
> of the report form customization and the table in the
> Crystal report itself:
> http://static.inky.ws/image/3849/screenshot_2013-04-16_100836.png
> http://static.inky.ws/image/3850/screenshot_2013-04-16_101640.png
>
> Maybe the Aged Receivables report doesn't have this, but others do?
> Maybe we need the Epicor SDK to do this?
>
> --- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...> wrote:
> >
> > Jose right
> >
> > Customize your Report Form where the parameters are entered putting a new
> > field and binding it to ReportParam.[Character01-05, Number01-05, or
> > Check01-05]. Then this value gets passed to the Crystal Report which you
> > can use to for filtering or record selection in the report. I also do
> this
> > on numerous reports
> >
> > Scott
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > adamnoffie
> > Sent: Tuesday, April 16, 2013 10:22 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: [E9] Adding Custom Parameters to Crystal Report
> >
> >
> > Thanks Karen. We figured this much out, but were hoping to go the more
> > natural route of putting the parameter entry in the report form.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> Karen
> > Schoenung <kschoenung@> wrote:
> > >
> > > You can also setup a parameter in Crystal, but then that requires your
> > user to preview the report before printing...
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of Jose Gomez
> > > Sent: Tuesday, April 16, 2013 8:46 AM
> > > To: Vantage
> > > Subject: Re: [Vantage] [E9] Adding Custom Parameters to Crystal Report
> > >
> > > The RPtParameter table has Character01-05 Number01-05 and Check01-05
> this
> > works fine, and I use it daily.
> > >
> > >
> > >
> > > *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, Apr 16, 2013 at 9:42 AM, adamnoffie <ygroups.adamleer@>wrote:
>
> > >
> > > > **
> > > >
> > > >
> > > > We have customized a Standard Crystal Epicor Report (Aged
> > > > Receivables), and would like to pass an extra parameter from the
> > > > customized report form to the output report xml passed to Crystal.
> > > >
> > > > We've tried binding our new text field to the ReportCurrencyCode
> field
> > > > in RptParameters table, and then referencing that in the rpt file,
> but
> > > > apparently it is overwritten by Epicor when the report runs - it
> ends
> > > > up being "USD" in the report always.
> > > >
> > > > Passing a custom parameter seems like it would be a really common
> > > > requirement for customizing these reports, but the internet and the
> > > > Epicor documentation has surprisingly little to say about the
> subject!
> > > > Any assistance on this report, or on the subject in general, would
> be
> > > > greatly appreciated.
> > > >
> > > > Thanks,
> > > > Adam
> > > >
> > > > Epicor 9.05.700C, SQL 64-bit
> > > >
> > > >
> > > >
> > >
> > >
> > > [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/.
> > <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]
> >
>
>
>


[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]
11
To do that, one would have to write some C# code in the customization to "shove the values" into the UD table, and then add the UD table to the report data definition, correct?

That actually might not be too terrible - if you had a primary key in the UD table of the username/session/reportID or something like that, you could make the solution somewhat generic and use the same UD table for all of your reports (that need it).

Do you have an example of a report you have added a custom parameter to and simply used the RptParameters table?

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Thta's weird most reports have it. You cuold do something really crappy and
> add a UD table to the RDD and then shove the values you want in that UD
> Table.
>
>
> *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, Apr 16, 2013 at 12:07 PM, adamnoffie <ygroups.adamleer@...>wrote:
>
> > **
> >
> >
> >
> >
> > Scott,
> >
> > Thanks - however, I'm not seeing where this is possible, at least not on
> > this report. Here was my response to Jose:
> >
> >
> > Unfortunately we do not have any UD fields of any kind
> > in the RptParameter table - I looked both in the EpiBinding
> > of the report form customization and the table in the
> > Crystal report itself:
> > http://static.inky.ws/image/3849/screenshot_2013-04-16_100836.png
> > http://static.inky.ws/image/3850/screenshot_2013-04-16_101640.png
> >
> > Maybe the Aged Receivables report doesn't have this, but others do?
> > Maybe we need the Epicor SDK to do this?
> >
> > --- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@> wrote:
> > >
> > > Jose right
> > >
> > > Customize your Report Form where the parameters are entered putting a new
> > > field and binding it to ReportParam.[Character01-05, Number01-05, or
> > > Check01-05]. Then this value gets passed to the Crystal Report which you
> > > can use to for filtering or record selection in the report. I also do
> > this
> > > on numerous reports
> > >
> > > Scott
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of
> > > adamnoffie
> > > Sent: Tuesday, April 16, 2013 10:22 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: [E9] Adding Custom Parameters to Crystal Report
> > >
> > >
> > > Thanks Karen. We figured this much out, but were hoping to go the more
> > > natural route of putting the parameter entry in the report form.
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > Karen
> > > Schoenung <kschoenung@> wrote:
> > > >
> > > > You can also setup a parameter in Crystal, but then that requires your
> > > user to preview the report before printing...
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > > Behalf Of Jose Gomez
> > > > Sent: Tuesday, April 16, 2013 8:46 AM
> > > > To: Vantage
> > > > Subject: Re: [Vantage] [E9] Adding Custom Parameters to Crystal Report
> > > >
> > > > The RPtParameter table has Character01-05 Number01-05 and Check01-05
> > this
> > > works fine, and I use it daily.
> > > >
> > > >
> > > >
> > > > *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, Apr 16, 2013 at 9:42 AM, adamnoffie <ygroups.adamleer@>wrote:
> >
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > We have customized a Standard Crystal Epicor Report (Aged
> > > > > Receivables), and would like to pass an extra parameter from the
> > > > > customized report form to the output report xml passed to Crystal.
> > > > >
> > > > > We've tried binding our new text field to the ReportCurrencyCode
> > field
> > > > > in RptParameters table, and then referencing that in the rpt file,
> > but
> > > > > apparently it is overwritten by Epicor when the report runs - it
> > ends
> > > > > up being "USD" in the report always.
> > > > >
> > > > > Passing a custom parameter seems like it would be a really common
> > > > > requirement for customizing these reports, but the internet and the
> > > > > Epicor documentation has surprisingly little to say about the
> > subject!
> > > > > Any assistance on this report, or on the subject in general, would
> > be
> > > > > greatly appreciated.
> > > > >
> > > > > Thanks,
> > > > > Adam
> > > > >
> > > > > Epicor 9.05.700C, SQL 64-bit
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [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/.
> > > <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]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
12
I did one last week it was a BAQ Report. I haven't tried on regular reports
but I assumed the RptParameters table was always the same.


*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 Wed, Apr 17, 2013 at 8:09 AM, adamnoffie <ygroups.adamleer@...>wrote:

> **
>
>
> To do that, one would have to write some C# code in the customization to
> "shove the values" into the UD table, and then add the UD table to the
> report data definition, correct?
>
> That actually might not be too terrible - if you had a primary key in the
> UD table of the username/session/reportID or something like that, you could
> make the solution somewhat generic and use the same UD table for all of
> your reports (that need it).
>
> Do you have an example of a report you have added a custom parameter to
> and simply used the RptParameters table?
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > Thta's weird most reports have it. You cuold do something really crappy
> and
> > add a UD table to the RDD and then shove the values you want in that UD
> > Table.
> >
> >
> > *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, Apr 16, 2013 at 12:07 PM, adamnoffie <ygroups.adamleer@
> ...>wrote:
> >
> > > **
>
> > >
> > >
> > >
> > >
> > > Scott,
> > >
> > > Thanks - however, I'm not seeing where this is possible, at least not
> on
> > > this report. Here was my response to Jose:
> > >
> > >
> > > Unfortunately we do not have any UD fields of any kind
> > > in the RptParameter table - I looked both in the EpiBinding
> > > of the report form customization and the table in the
> > > Crystal report itself:
> > > http://static.inky.ws/image/3849/screenshot_2013-04-16_100836.png
> > > http://static.inky.ws/image/3850/screenshot_2013-04-16_101640.png
> > >
> > > Maybe the Aged Receivables report doesn't have this, but others do?
> > > Maybe we need the Epicor SDK to do this?
> > >
> > > --- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@> wrote:
> > > >
> > > > Jose right
> > > >
> > > > Customize your Report Form where the parameters are entered putting
> a new
> > > > field and binding it to ReportParam.[Character01-05, Number01-05, or
> > > > Check01-05]. Then this value gets passed to the Crystal Report which
> you
> > > > can use to for filtering or record selection in the report. I also do
> > > this
> > > > on numerous reports
> > > >
> > > > Scott
> > > >
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of
> > > > adamnoffie
> > > > Sent: Tuesday, April 16, 2013 10:22 AM
> > > > To: vantage@yahoogroups.com
> > > > Subject: [Vantage] Re: [E9] Adding Custom Parameters to Crystal
> Report
> > > >
> > > >
> > > > Thanks Karen. We figured this much out, but were hoping to go the
> more
> > > > natural route of putting the parameter entry in the report form.
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > > Karen
> > > > Schoenung <kschoenung@> wrote:
> > > > >
> > > > > You can also setup a parameter in Crystal, but then that requires
> your
> > > > user to preview the report before printing...
> > > > >
> > > > > -----Original Message-----
> > > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> ] On
> > > > Behalf Of Jose Gomez
> > > > > Sent: Tuesday, April 16, 2013 8:46 AM
> > > > > To: Vantage
> > > > > Subject: Re: [Vantage] [E9] Adding Custom Parameters to Crystal
> Report
> > > > >
> > > > > The RPtParameter table has Character01-05 Number01-05 and
> Check01-05
> > > this
> > > > works fine, and I use it daily.
> > > > >
> > > > >
> > > > >
> > > > > *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, Apr 16, 2013 at 9:42 AM, adamnoffie <ygroups.adamleer@
> >wrote:
> > >
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > We have customized a Standard Crystal Epicor Report (Aged
> > > > > > Receivables), and would like to pass an extra parameter from the
> > > > > > customized report form to the output report xml passed to
> Crystal.
> > > > > >
> > > > > > We've tried binding our new text field to the ReportCurrencyCode
> > > field
> > > > > > in RptParameters table, and then referencing that in the rpt
> file,
> > > but
> > > > > > apparently it is overwritten by Epicor when the report runs - it
> > > ends
> > > > > > up being "USD" in the report always.
> > > > > >
> > > > > > Passing a custom parameter seems like it would be a really common
> > > > > > requirement for customizing these reports, but the internet and
> the
> > > > > > Epicor documentation has surprisingly little to say about the
> > > subject!
> > > > > > Any assistance on this report, or on the subject in general,
> would
> > > be
> > > > > > greatly appreciated.
> > > > > >
> > > > > > Thanks,
> > > > > > Adam
> > > > > >
> > > > > > Epicor 9.05.700C, SQL 64-bit
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [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/.
> > > > <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]
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
13
It seems that on regular report you dont have the UD fields
I also use it in BAQ report many times but now i try in a regular report
and its not there

can you guide me tru how you would do it with a UD table?



On Wed, Apr 17, 2013 at 8:16 AM, Jose Gomez <jose@...> wrote:

> I did one last week it was a BAQ Report. I haven't tried on regular reports
> but I assumed the RptParameters table was always the same.
>
>
> *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 Wed, Apr 17, 2013 at 8:09 AM, adamnoffie <ygroups.adamleer@...
> >wrote:
>
> > **
> >
> >
> > To do that, one would have to write some C# code in the customization to
> > "shove the values" into the UD table, and then add the UD table to the
> > report data definition, correct?
> >
> > That actually might not be too terrible - if you had a primary key in the
> > UD table of the username/session/reportID or something like that, you
> could
> > make the solution somewhat generic and use the same UD table for all of
> > your reports (that need it).
> >
> > Do you have an example of a report you have added a custom parameter to
> > and simply used the RptParameters table?
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> > >
> > > Thta's weird most reports have it. You cuold do something really crappy
> > and
> > > add a UD table to the RDD and then shove the values you want in that UD
> > > Table.
> > >
> > >
> > > *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, Apr 16, 2013 at 12:07 PM, adamnoffie <ygroups.adamleer@
> > ...>wrote:
> > >
> > > > **
> >
> > > >
> > > >
> > > >
> > > >
> > > > Scott,
> > > >
> > > > Thanks - however, I'm not seeing where this is possible, at least not
> > on
> > > > this report. Here was my response to Jose:
> > > >
> > > >
> > > > Unfortunately we do not have any UD fields of any kind
> > > > in the RptParameter table - I looked both in the EpiBinding
> > > > of the report form customization and the table in the
> > > > Crystal report itself:
> > > > http://static.inky.ws/image/3849/screenshot_2013-04-16_100836.png
> > > > http://static.inky.ws/image/3850/screenshot_2013-04-16_101640.png
> > > >
> > > > Maybe the Aged Receivables report doesn't have this, but others do?
> > > > Maybe we need the Epicor SDK to do this?
> > > >
> > > > --- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@>
> wrote:
> > > > >
> > > > > Jose right
> > > > >
> > > > > Customize your Report Form where the parameters are entered putting
> > a new
> > > > > field and binding it to ReportParam.[Character01-05, Number01-05,
> or
> > > > > Check01-05]. Then this value gets passed to the Crystal Report
> which
> > you
> > > > > can use to for filtering or record selection in the report. I also
> do
> > > > this
> > > > > on numerous reports
> > > > >
> > > > > Scott
> > > > >
> > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > > Behalf Of
> > > > > adamnoffie
> > > > > Sent: Tuesday, April 16, 2013 10:22 AM
> > > > > To: vantage@yahoogroups.com
> > > > > Subject: [Vantage] Re: [E9] Adding Custom Parameters to Crystal
> > Report
> > > > >
> > > > >
> > > > > Thanks Karen. We figured this much out, but were hoping to go the
> > more
> > > > > natural route of putting the parameter entry in the report form.
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> ,
> > > > Karen
> > > > > Schoenung <kschoenung@> wrote:
> > > > > >
> > > > > > You can also setup a parameter in Crystal, but then that requires
> > your
> > > > > user to preview the report before printing...
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > ] On
> > > > > Behalf Of Jose Gomez
> > > > > > Sent: Tuesday, April 16, 2013 8:46 AM
> > > > > > To: Vantage
> > > > > > Subject: Re: [Vantage] [E9] Adding Custom Parameters to Crystal
> > Report
> > > > > >
> > > > > > The RPtParameter table has Character01-05 Number01-05 and
> > Check01-05
> > > > this
> > > > > works fine, and I use it daily.
> > > > > >
> > > > > >
> > > > > >
> > > > > > *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, Apr 16, 2013 at 9:42 AM, adamnoffie <ygroups.adamleer@
> > >wrote:
> > > >
> > > > > >
> > > > > > > **
> > > > > > >
> > > > > > >
> > > > > > > We have customized a Standard Crystal Epicor Report (Aged
> > > > > > > Receivables), and would like to pass an extra parameter from
> the
> > > > > > > customized report form to the output report xml passed to
> > Crystal.
> > > > > > >
> > > > > > > We've tried binding our new text field to the
> ReportCurrencyCode
> > > > field
> > > > > > > in RptParameters table, and then referencing that in the rpt
> > file,
> > > > but
> > > > > > > apparently it is overwritten by Epicor when the report runs -
> it
> > > > ends
> > > > > > > up being "USD" in the report always.
> > > > > > >
> > > > > > > Passing a custom parameter seems like it would be a really
> common
> > > > > > > requirement for customizing these reports, but the internet and
> > the
> > > > > > > Epicor documentation has surprisingly little to say about the
> > > > subject!
> > > > > > > Any assistance on this report, or on the subject in general,
> > would
> > > > be
> > > > > > > greatly appreciated.
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Adam
> > > > > > >
> > > > > > > Epicor 9.05.700C, SQL 64-bit
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > [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/.
> > > > > <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]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [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]
14
I never figured that out, but would be curious to know how someone else did it if they did it. For now, I'm just maintaining multiple reports and report styles, which is the pain I hoped to avoid with a custom report parameter.

--- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
>
> It seems that on regular report you dont have the UD fields
> I also use it in BAQ report many times but now i try in a regular report
> and its not there
>
> can you guide me tru how you would do it with a UD table?
>
15
Thanks for the solution.

I used your idea and it works fine
On 2013-07-05 8:39 AM, "adamnoffie" <ygroups.adamleer@...> wrote:

> **
>
>
> I never figured that out, but would be curious to know how someone else
> did it if they did it. For now, I'm just maintaining multiple reports and
> report styles, which is the pain I hoped to avoid with a custom report
> parameter.
>
> --- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
> >
> > It seems that on regular report you dont have the UD fields
> > I also use it in BAQ report many times but now i try in a regular report
> > and its not there
> >
> > can you guide me tru how you would do it with a UD table?
> >
>
>
>


[Non-text portions of this message have been removed]
16
What solution did you use Ephraim?

--- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
>
> Thanks for the solution.
>
> I used your idea and it works fine
> On 2013-07-05 8:39 AM, "adamnoffie" <ygroups.adamleer@...> wrote:
>
> > **
> >
> >
> > I never figured that out, but would be curious to know how someone else
> > did it if they did it. For now, I'm just maintaining multiple reports and
> > report styles, which is the pain I hoped to avoid with a custom report
> > parameter.
> >
> > --- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@> wrote:
> > >
> > > It seems that on regular report you dont have the UD fields
> > > I also use it in BAQ report many times but now i try in a regular report
> > > and its not there
> > >
> > > can you guide me tru how you would do it with a UD table?
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>