Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports - RDC - AddCurrentRange - NoLowerBound Date

Status
Not open for further replies.

TonySanta

Technical User
Mar 26, 2015
1
US
Hi,
I am programming in vbscript using the Report Designer Component (RDC) object model. In the code snippet below, I would like to know how to code the first date in the 'AddCurrentRange' when there is NoLowerBound. When I have both dates, it works fine. Please note I am using 9 (8 + 1) as my range info for no lower bound and include upper bound. Thanks, Tony.

' Set the parameters for Open Orders report, Export to PDF, and Print
set objCRRpt = objCRApp.openreport( rptfileOpenO )
objCRRpt.ParameterFields.GetItemByName("Date Range").AddCurrentRange ,CDate("02/28/2015"), 9
objCRRpt.ParameterFields.GetItemByName("Include Discounts").SetCurrentValue("Y")
objCRRpt.ParameterFields.GetItemByName("IncludeTE").SetCurrentValue("N")
objCRRpt.ParameterFields.GetItemByName("OrderStatus").SetCurrentValue("All")
objCRRpt.ExportOptions.DiskFileName = exportfileOpenO
objCRRpt.Export FALSE
objCRRpt.PrintOut FALSE,1, ,1,4
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top