Announcements
I get an error message in a Crystal Report Windows Forms Viewer window saying... The ) is missing... when using a custom button with the Launch command to call ROI in Dynamics 2011. I have gone to the "books" and followed the examples given but have no success. This command used to work in Dynamics SL 7 before upgrading to Dynamics 2011. Can someone give me a tip on what is wrong?
Below is the code behind my custom button...
Sub cmdReport_Click()
Dim CustId As String * 10
Dim ParmStr$
CustId = GetObjectValue("ccustid")
ParmStr = "ROI.EXE " + PRMSEP + "08652/RUN" + PRMSEP + "08652/FORMAT" + PRMSEP + "ARTran.Custid = " + SParm(CustId) + "/WHERE" + PRMSEP + "/PSCRN"
serr2 = Launch(ParmStr, True, True, 0)
'Call ApplSetParmValue(PRMSECTION_VBRDT, "", "08652/RUN")
'Call ApplSetParmValue(PRMSECTION_VBRDT, "", "08652/FORMAT")
'Call ApplSetParmValue(PRMSECTION_VBRDT, "", "ARTran.Custid = " + SParm(CustId) + "/WHERE")
'Call ApplSetParmValue(PRMSECTION_VBRDT, "", "/PSCRN")
'serr2 = Launch("ROI.EXE ", True, True, 0)
End Sub
*This post is locked for comments
Thank you very much, Barry!! Your answer worked for us!
Just in case someone needs to see the working code, I pasted the two examples below...
Sub cmdReport_Click()
Dim CustId As String * 10
Dim ParmStr$
CustId = GetObjectValue("ccustid")
'ParmStr = "ROI.EXE " + PRMSEP + "08652/RUN" + PRMSEP + "08652/FORMAT" + PRMSEP + "{ARTran.Custid} = " + SParm(CustId) + "/WHERE" + PRMSEP + "/PSCRN"
'serr2 = Launch(ParmStr, True, True, 0)
Call ApplSetParmValue(PRMSECTION_VBRDT, "", "08652/RUN")
Call ApplSetParmValue(PRMSECTION_VBRDT, "", "08652/FORMAT")
Call ApplSetParmValue(PRMSECTION_VBRDT, "", "{ARTran.Custid} = " + SParm(CustId) + "/WHERE")
Call ApplSetParmValue(PRMSECTION_VBRDT, "", "/PSCRN")
serr2 = Launch("ROI.EXE ", True, True, 0)
End Sub
In SL2011, it is necessaey to enclose the TableName.ColumnName in curly braces
Barry
Test
André Arnaud de Cal...
294,217
Super User 2025 Season 1
Martin Dráb
232,978
Most Valuable Professional
nmaenpaa
101,158
Moderator