1. Just upgraded to SL2011 FP1, 2. Testing customized AP Voucher and Adjustment screen ( 03010) where we added a button to PRINT the AP Edit Report (03810) for this particular batch (the VBA is below), 3. Pressing button to print worked in SL7, FP1. Now in SL2011 FP1 it results in error(s):
Crystal Report Windows Forms Viewer The ) is missing. Details: errorKind Error in File 03810 ....rpt: Error in formula Record Selection: '({vr_03810_cRI_ID} = 4) AND (vr_03810.batnbr =064816)' The ) is missing. Details: errorKind A resolution for this error was found: In SL2011, it is necessaey to enclose the TableName.ColumnName in curly braces. Example: {ARTran.Custid}Source: https://community.dynamics.com/product/sl/f/35/p/74955/137552.aspx
This is the EXACT CODE from SL7 version that had worked:
Private Sub Button1_Click()
BatchNbr = Trim(GetObjectValue("cbatnbr"))
ParmStr = "ROI.EXE " & PRMSEP
ParmStr = ParmStr & "03810/RUN" & PRMSEP
ParmStr = ParmStr & "03810/FORMAT" & PRMSEP
ParmStr = ParmStr & "vr_03810.batnbr =" & BatchNbr & "/WHERE" & PRMSEP
ParmStr = ParmStr & "/PSCRN"
serr1 = Launch(ParmStr, True, True, 0)
End Sub
Hello RedStorm,
Try this below code in your customization.This will solve your Error.
ParmStr = ParmStr & "{vr_03810.batnbr} =" & Sparm(BatchNbr) & "/WHERE" & PRMSEP
Thanks,
Perumalsamy R
Perumalsamy R: You did it! :-) Thank you for providing exactly what I needed. This prints my report just like I needed. Thank you, thank you, thank you! Dave (RedStorm)
Hello Dave ( RedStorm )
you are always welcome.
Thank you,
Regards,