BAQReportParameter.Filter1

You'd need to check for the upper limit before you start checking for the
[2] element of the array

If Upper(Split({BAQReportParameter.Filter1},'<FieldValue>'))>=2 then

Now, you can be assured that looking at the [2] element of your array will
not error out.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
advantage
Sent: Friday, November 20, 2009 3:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQReportParameter.Filter1





ok, so what would would the formula look like?
If
Upper(Split(ToText({BAQReportParameter.Filter1}),'<FieldValue>',-1,0)[2])...
.......................

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Sean McDaniel
Sent: Friday, November 20, 2009 3:19 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQReportParameter.Filter1

You have to be careful because you are essentially choosing item [2], but
item [2] may not exist. You can do a check for this using the upper function
to determine if upper(<array>)>=2 then proceed with your selection criteria.

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
advantage
Sent: Friday, November 20, 2009 1:23 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] BAQReportParameter.Filter1

Does anyone know how to get the Filter information on the Crystal
Report...from a BAQ Report

ie. in the Page Header I want to put a formula that shows end user what they
Grouped by: Product Group: A~B~C.
I thought I figured it out by creating a formula that splits that
BAQReportParamter.Filter1
This field contains a long script....of what the end user filters their
report.
so I used
Split(ToText({BAQReportParameter.Filter1}),'<FieldValue>',-1,0)[2]

and it returned nicely Grouped by: {A~B~C} from within Crystal; but when I
print preview from within Epicor it returns an error

A subscript must between 1 and size of
array...Split(ToText({BAQReportParameter.Filter1}),'<FieldValue>',-1,0)[2]

[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]





[Non-text portions of this message have been removed]
I have a button on my RMA Screen that I just created which calls that RMA
Disposition Form

Private Sub btnEpiCustom1_Click(ByVal Sender As Object, ByVal Args As
System.EventArgs) Handles btnEpiCustom1.Click
'// ** Place Event Handling Code Here **

ProcessCaller.LaunchForm(oTrans,"UDRMADis")
End Sub


That's all well and good. But I will like that form to open with the current
RMA selected. Is this something that can be done? and if so how"?

Sincerely
Jose C Gomez

http://www.josecgomez.com


[Non-text portions of this message have been removed]
I know that various forms have the ability to be opened with a record
present by passing one or more parameters. In your particular form im
not exactly sure if it can accept them, but in the past ive done some
things like the following that have worked.



ProcessCaller.LaunchForm(oTrans,"UDRMADis",[RMANUM])



[RMANUM] will probably be a variable assigned from your epidataview.



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Friday, November 20, 2009 11:08 AM
To: Vantage
Subject: [Vantage] Calling a new Form from a Customization and Executing
On It





I have a button on my RMA Screen that I just created which calls that
RMA
Disposition Form

Private Sub btnEpiCustom1_Click(ByVal Sender As Object, ByVal Args As
System.EventArgs) Handles btnEpiCustom1.Click
'// ** Place Event Handling Code Here **

ProcessCaller.LaunchForm(oTrans,"UDRMADis")
End Sub

That's all well and good. But I will like that form to open with the
current
RMA selected. Is this something that can be done? and if so how"?

Sincerely
Jose C Gomez

http://www.josecgomez.com

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Does anyone know how to get the Filter information on the Crystal
Report...from a BAQ Report

ie. in the Page Header I want to put a formula that shows end user what they
Grouped by: Product Group: A~B~C.
I thought I figured it out by creating a formula that splits that
BAQReportParamter.Filter1
This field contains a long script....of what the end user filters their
report.
so I used
Split(ToText({BAQReportParameter.Filter1}),'<FieldValue>',-1,0)[2]

and it returned nicely Grouped by: {A~B~C} from within Crystal; but when I
print preview from within Epicor it returns an error

A subscript must between 1 and size of
array...Split(ToText({BAQReportParameter.Filter1}),'<FieldValue>',-1,0)[2]




[Non-text portions of this message have been removed]
You have to be careful because you are essentially choosing item [2], but
item [2] may not exist. You can do a check for this using the upper function
to determine if upper(<array>)>=2 then proceed with your selection criteria.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
advantage
Sent: Friday, November 20, 2009 1:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQReportParameter.Filter1





Does anyone know how to get the Filter information on the Crystal
Report...from a BAQ Report

ie. in the Page Header I want to put a formula that shows end user what they
Grouped by: Product Group: A~B~C.
I thought I figured it out by creating a formula that splits that
BAQReportParamter.Filter1
This field contains a long script....of what the end user filters their
report.
so I used
Split(ToText({BAQReportParameter.Filter1}),'<FieldValue>',-1,0)[2]

and it returned nicely Grouped by: {A~B~C} from within Crystal; but when I
print preview from within Epicor it returns an error

A subscript must between 1 and size of
array...Split(ToText({BAQReportParameter.Filter1}),'<FieldValue>',-1,0)[2]



[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
ok, so what would would the formula look like?
If
Upper(Split(ToText({BAQReportParameter.Filter1}),'<FieldValue>',-1,0)[2])...
.......................




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sean McDaniel
Sent: Friday, November 20, 2009 3:19 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQReportParameter.Filter1




You have to be careful because you are essentially choosing item [2], but
item [2] may not exist. You can do a check for this using the upper function
to determine if upper(<array>)>=2 then proceed with your selection criteria.

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
advantage
Sent: Friday, November 20, 2009 1:23 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] BAQReportParameter.Filter1

Does anyone know how to get the Filter information on the Crystal
Report...from a BAQ Report

ie. in the Page Header I want to put a formula that shows end user what they
Grouped by: Product Group: A~B~C.
I thought I figured it out by creating a formula that splits that
BAQReportParamter.Filter1
This field contains a long script....of what the end user filters their
report.
so I used
Split(ToText({BAQReportParameter.Filter1}),'<FieldValue>',-1,0)[2]

and it returned nicely Grouped by: {A~B~C} from within Crystal; but when I
print preview from within Epicor it returns an error

A subscript must between 1 and size of
array...Split(ToText({BAQReportParameter.Filter1}),'<FieldValue>',-1,0)[2]

[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]