I’m working on a report based entirely off of PMTRAN (with PMCOSTCODE linked in to give me access to CostCodeCD). I’m starting with parameters for project, startperiod & endperiod. I’m then trying to filter so that I only select records from PMTRANS where PMTRAN.ProjectID = @project and where PMTRAN.FINPERIODID is between @startperiod and @endperiod.
I can’t seem to get my date parameters into a format that is consistent with PMTRAN.FINERIODID. I’ve tried
- creating the parameters as ‘string’, ‘date’, and ‘integers’.
- creating a variable based on the parameters to put them in yyyymm format.
- creating variables to put all of the dates into yyyymm format.
nothing seems to work.
This is how I’m defining the parameters
view name
=Report.GetFieldSchema('OrganizationBranchReportParameters.FinPeriodID')
default value
=Report.GetDefExt('OrganizationBranchReportParameters.FinPeriodID')
But I’ve also tried
view name
=Report.GetFieldSchema('PMTran.FinPeriodID')
default value
=Report.GetDefExt('OrganizationBranchReportParameters.FinPeriodID')
I’ve looked at a bunch of other reports where period ranges are used and can’t seem to find anything that works with PMTRAN.FINPERIODID
Any suggestions?