Crystal reports report from within Customization

Yahoo Archive
1
Hello Group

I found this post and hope someone has figured out how to do this.
I would like to launch a custom (odbc) rpt from a button and would
like to pass it parameters.

TIA
Mark Dupuis


--- In vantage@yahoogroups.com, "steve.thoms" <steve.thoms@...>
wrote:
>
> Were you (or has anyone been) able to figure out how to launch a
> custom report using LaunchFormOptions?
>
> I've customized the Custom Report form and pre-populated the form
with
> the right path to the report (confirmed since the same path works
> using another method). But it would appear that the Custom Report
> process doesn't use the text in the Report text box as the actual
> input. Maybe there's an option somewhere to set the actual value
for
> the report path?
>
> Or has someone figured out a different (simpler?) way to launch a
> custom Crystal Report from a button?
>
> -Steve
>
> --- In vantage@yahoogroups.com, Fons van der Beek
> <fons.vanderbeek@> wrote:
> >
> > Tnx, i''ll keep you informed............
> >
> > Michael McWilliams schreef:
> > > For custom report I believe you use.
> > > ProcessCaller.LaunchForm(oTrans, "Epicor.Mfg.UI.CustomReport",
lfo)
> > >
> > > Then customize the form that launches for an on load event and
set
> > > the path of the report using the script editor. You then have
to
> > > use subproccess calling maint. to set this custom version of
the
> > > form to load from you calling form.
> > > I am not sure how the launch form options work for a custom
report
> > > so the user would have to input their parameters. You may even
be
> > > able to bypass using the subproccess calling if you can figure
out
> > > the launch form options. If you do let me know because epicor
was
> > > clueless when I asked for any type of info on this.
> > > --- In vantage@yahoogroups.com, "Michael McWilliams"
> > > <mmcwilliams22@> wrote:
> > >
> > >> Here is an example for the standard report. I know I have
the
> > >>
> > > other
> > >
> > >> one also I just have to look for it.
> > >>
> > >>
> > >> Private Sub btnEpiCustom1_Click(ByVal sender As
System.Object,
> > >>
> > > ByVal
> > >
> > >> e As System.EventArgs) Handles bntEpiCustom1.Click
> > >>
> > >> Dim QuoteHead As EpiDataView = Ctype(oTrans.EpiDataViews
> > >> ("QuoteHead"),EpiDataView)
> > >>
> > >> Dim strQuoteNum As String = QuoteHead.dataView(QuoteHead.Row)
> > >> ("QuoteNum")
> > >>
> > >> Dim lfo as LaunchFormOptions = new LaunchFormOptions()
> > >> lfo.IsModal = true
> > >> lfo.ValueIn = strQuoteNum
> > >> ProcessCaller.LaunchForm(oTrans, "Epicor.Mfg.UIRpt.QuotForm",
lfo)
> > >> End Sub
> > >>
> > >>
> > >> --- In vantage@yahoogroups.com, Fons van der Beek
> > >> <fons.vanderbeek@> wrote:
> > >>
> > >>> Actualy both
> > >>> I have some customized reports from Vantage and i have some
> > >>>
> > >> reports
> > >>
> > >>> based on OBDC with various user input.
> > >>>
> > >>>
> > >>>
> > >>>
> > >>> Michael McWilliams schreef:
> > >>>
> > >>>> Do you want to launch a Vantage crystal report or a report
you
> > >>>>
> > >> created
> > >>
> > >>>> yourself?
> > >>>>
> > >>>> --- In vantage@yahoogroups.com, "fonsvanderbeek"
> > >>>>
> > >> <fons.vanderbeek@>
> > >>
> > >>>> wrote:
> > >>>>
> > >>>>
> > >>>>> Hi,
> > >>>>> Does anybody have a code example for calling a crystal
> > >>>>>
> > > report
> > >
> > >> from
> > >>
> > >>>>> within the Customization?
> > >>>>>
> > >>>>> e.g.
> > >>>>> To display a report by clicking a Commandbutton?
> > >>>>>
> > >>>>> Tnx
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>
> > >>>>
> > >>>> 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/links
> > >>
> > >>>> Yahoo! Groups Links
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>
> > >>> [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/links
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> >
>
2
Hi,
Does anybody have a code example for calling a crystal report from
within the Customization?

e.g.
To display a report by clicking a Commandbutton?

Tnx
3
Do you want to launch a Vantage crystal report or a report you created
yourself?

--- In vantage@yahoogroups.com, "fonsvanderbeek" <fons.vanderbeek@...>
wrote:
>
> Hi,
> Does anybody have a code example for calling a crystal report from
> within the Customization?
>
> e.g.
> To display a report by clicking a Commandbutton?
>
> Tnx
>
4
Actualy both
I have some customized reports from Vantage and i have some reports
based on OBDC with various user input.




Michael McWilliams schreef:
> Do you want to launch a Vantage crystal report or a report you created
> yourself?
>
> --- In vantage@yahoogroups.com, "fonsvanderbeek" <fons.vanderbeek@...>
> wrote:
>
>> Hi,
>> Does anybody have a code example for calling a crystal report from
>> within the Customization?
>>
>> e.g.
>> To display a report by clicking a Commandbutton?
>>
>> Tnx
>>
>>
>
>
>
>
> 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/links
> Yahoo! Groups Links
>
>
>
>



[Non-text portions of this message have been removed]
5
Here is an example for the standard report. I know I have the other
one also I just have to look for it.


Private Sub btnEpiCustom1_Click(ByVal sender As System.Object, ByVal
e As System.EventArgs) Handles bntEpiCustom1.Click

Dim QuoteHead As EpiDataView = Ctype(oTrans.EpiDataViews
("QuoteHead"),EpiDataView)

Dim strQuoteNum As String = QuoteHead.dataView(QuoteHead.Row)
("QuoteNum")

Dim lfo as LaunchFormOptions = new LaunchFormOptions()
lfo.IsModal = true
lfo.ValueIn = strQuoteNum
ProcessCaller.LaunchForm(oTrans, "Epicor.Mfg.UIRpt.QuotForm", lfo)
End Sub


--- In vantage@yahoogroups.com, Fons van der Beek
<fons.vanderbeek@...> wrote:
>
> Actualy both
> I have some customized reports from Vantage and i have some
reports
> based on OBDC with various user input.
>
>
>
>
> Michael McWilliams schreef:
> > Do you want to launch a Vantage crystal report or a report you
created
> > yourself?
> >
> > --- In vantage@yahoogroups.com, "fonsvanderbeek"
<fons.vanderbeek@>
> > wrote:
> >
> >> Hi,
> >> Does anybody have a code example for calling a crystal report
from
> >> within the Customization?
> >>
> >> e.g.
> >> To display a report by clicking a Commandbutton?
> >>
> >> Tnx
> >>
> >>
> >
> >
> >
> >
> > 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/links
> > Yahoo! Groups Links
> >
> >
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>
6
For custom report I believe you use.
ProcessCaller.LaunchForm(oTrans, "Epicor.Mfg.UI.CustomReport", lfo)

Then customize the form that launches for an on load event and set
the path of the report using the script editor. You then have to
use subproccess calling maint. to set this custom version of the
form to load from you calling form.
I am not sure how the launch form options work for a custom report
so the user would have to input their parameters. You may even be
able to bypass using the subproccess calling if you can figure out
the launch form options. If you do let me know because epicor was
clueless when I asked for any type of info on this.
--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:
>
> Here is an example for the standard report. I know I have the
other
> one also I just have to look for it.
>
>
> Private Sub btnEpiCustom1_Click(ByVal sender As System.Object,
ByVal
> e As System.EventArgs) Handles bntEpiCustom1.Click
>
> Dim QuoteHead As EpiDataView = Ctype(oTrans.EpiDataViews
> ("QuoteHead"),EpiDataView)
>
> Dim strQuoteNum As String = QuoteHead.dataView(QuoteHead.Row)
> ("QuoteNum")
>
> Dim lfo as LaunchFormOptions = new LaunchFormOptions()
> lfo.IsModal = true
> lfo.ValueIn = strQuoteNum
> ProcessCaller.LaunchForm(oTrans, "Epicor.Mfg.UIRpt.QuotForm", lfo)
> End Sub
>
>
> --- In vantage@yahoogroups.com, Fons van der Beek
> <fons.vanderbeek@> wrote:
> >
> > Actualy both
> > I have some customized reports from Vantage and i have some
> reports
> > based on OBDC with various user input.
> >
> >
> >
> >
> > Michael McWilliams schreef:
> > > Do you want to launch a Vantage crystal report or a report you
> created
> > > yourself?
> > >
> > > --- In vantage@yahoogroups.com, "fonsvanderbeek"
> <fons.vanderbeek@>
> > > wrote:
> > >
> > >> Hi,
> > >> Does anybody have a code example for calling a crystal
report
> from
> > >> within the Customization?
> > >>
> > >> e.g.
> > >> To display a report by clicking a Commandbutton?
> > >>
> > >> Tnx
> > >>
> > >>
> > >
> > >
> > >
> > >
> > > 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/links
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
7
Tnx, i''ll keep you informed............

Michael McWilliams schreef:
> For custom report I believe you use.
> ProcessCaller.LaunchForm(oTrans, "Epicor.Mfg.UI.CustomReport", lfo)
>
> Then customize the form that launches for an on load event and set
> the path of the report using the script editor. You then have to
> use subproccess calling maint. to set this custom version of the
> form to load from you calling form.
> I am not sure how the launch form options work for a custom report
> so the user would have to input their parameters. You may even be
> able to bypass using the subproccess calling if you can figure out
> the launch form options. If you do let me know because epicor was
> clueless when I asked for any type of info on this.
> --- In vantage@yahoogroups.com, "Michael McWilliams"
> <mmcwilliams22@...> wrote:
>
>> Here is an example for the standard report. I know I have the
>>
> other
>
>> one also I just have to look for it.
>>
>>
>> Private Sub btnEpiCustom1_Click(ByVal sender As System.Object,
>>
> ByVal
>
>> e As System.EventArgs) Handles bntEpiCustom1.Click
>>
>> Dim QuoteHead As EpiDataView = Ctype(oTrans.EpiDataViews
>> ("QuoteHead"),EpiDataView)
>>
>> Dim strQuoteNum As String = QuoteHead.dataView(QuoteHead.Row)
>> ("QuoteNum")
>>
>> Dim lfo as LaunchFormOptions = new LaunchFormOptions()
>> lfo.IsModal = true
>> lfo.ValueIn = strQuoteNum
>> ProcessCaller.LaunchForm(oTrans, "Epicor.Mfg.UIRpt.QuotForm", lfo)
>> End Sub
>>
>>
>> --- In vantage@yahoogroups.com, Fons van der Beek
>> <fons.vanderbeek@> wrote:
>>
>>> Actualy both
>>> I have some customized reports from Vantage and i have some
>>>
>> reports
>>
>>> based on OBDC with various user input.
>>>
>>>
>>>
>>>
>>> Michael McWilliams schreef:
>>>
>>>> Do you want to launch a Vantage crystal report or a report you
>>>>
>> created
>>
>>>> yourself?
>>>>
>>>> --- In vantage@yahoogroups.com, "fonsvanderbeek"
>>>>
>> <fons.vanderbeek@>
>>
>>>> wrote:
>>>>
>>>>
>>>>> Hi,
>>>>> Does anybody have a code example for calling a crystal
>>>>>
> report
>
>> from
>>
>>>>> within the Customization?
>>>>>
>>>>> e.g.
>>>>> To display a report by clicking a Commandbutton?
>>>>>
>>>>> Tnx
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> 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/links
>>
>>>> Yahoo! Groups Links
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>> [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/links
> Yahoo! Groups Links
>
>
>
>
8
Were you (or has anyone been) able to figure out how to launch a
custom report using LaunchFormOptions?

I've customized the Custom Report form and pre-populated the form with
the right path to the report (confirmed since the same path works
using another method). But it would appear that the Custom Report
process doesn't use the text in the Report text box as the actual
input. Maybe there's an option somewhere to set the actual value for
the report path?

Or has someone figured out a different (simpler?) way to launch a
custom Crystal Report from a button?

-Steve

--- In vantage@yahoogroups.com, Fons van der Beek
<fons.vanderbeek@...> wrote:
>
> Tnx, i''ll keep you informed............
>
> Michael McWilliams schreef:
> > For custom report I believe you use.
> > ProcessCaller.LaunchForm(oTrans, "Epicor.Mfg.UI.CustomReport", lfo)
> >
> > Then customize the form that launches for an on load event and set
> > the path of the report using the script editor. You then have to
> > use subproccess calling maint. to set this custom version of the
> > form to load from you calling form.
> > I am not sure how the launch form options work for a custom report
> > so the user would have to input their parameters. You may even be
> > able to bypass using the subproccess calling if you can figure out
> > the launch form options. If you do let me know because epicor was
> > clueless when I asked for any type of info on this.
> > --- In vantage@yahoogroups.com, "Michael McWilliams"
> > <mmcwilliams22@> wrote:
> >
> >> Here is an example for the standard report. I know I have the
> >>
> > other
> >
> >> one also I just have to look for it.
> >>
> >>
> >> Private Sub btnEpiCustom1_Click(ByVal sender As System.Object,
> >>
> > ByVal
> >
> >> e As System.EventArgs) Handles bntEpiCustom1.Click
> >>
> >> Dim QuoteHead As EpiDataView = Ctype(oTrans.EpiDataViews
> >> ("QuoteHead"),EpiDataView)
> >>
> >> Dim strQuoteNum As String = QuoteHead.dataView(QuoteHead.Row)
> >> ("QuoteNum")
> >>
> >> Dim lfo as LaunchFormOptions = new LaunchFormOptions()
> >> lfo.IsModal = true
> >> lfo.ValueIn = strQuoteNum
> >> ProcessCaller.LaunchForm(oTrans, "Epicor.Mfg.UIRpt.QuotForm", lfo)
> >> End Sub
> >>
> >>
> >> --- In vantage@yahoogroups.com, Fons van der Beek
> >> <fons.vanderbeek@> wrote:
> >>
> >>> Actualy both
> >>> I have some customized reports from Vantage and i have some
> >>>
> >> reports
> >>
> >>> based on OBDC with various user input.
> >>>
> >>>
> >>>
> >>>
> >>> Michael McWilliams schreef:
> >>>
> >>>> Do you want to launch a Vantage crystal report or a report you
> >>>>
> >> created
> >>
> >>>> yourself?
> >>>>
> >>>> --- In vantage@yahoogroups.com, "fonsvanderbeek"
> >>>>
> >> <fons.vanderbeek@>
> >>
> >>>> wrote:
> >>>>
> >>>>
> >>>>> Hi,
> >>>>> Does anybody have a code example for calling a crystal
> >>>>>
> > report
> >
> >> from
> >>
> >>>>> within the Customization?
> >>>>>
> >>>>> e.g.
> >>>>> To display a report by clicking a Commandbutton?
> >>>>>
> >>>>> Tnx
> >>>>>
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>> 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/links
> >>
> >>>> Yahoo! Groups Links
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>
> >>> [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/links
> > Yahoo! Groups Links
> >
> >
> >
> >
>