Set Date Field Default Value on BAQ Report Form

Epicor ERP 10
,
1

I have created a BAQ report that has several parameters, one of which is a date field. I have it set up as a criteria prompt in the RDD. I am trying to make the default value the Saturday after today (I have code to calculate the date). I have tried customizing the form to set the date in the Load event but it always reverts to today. I tried adding in a plain date field and using that instead of the EpiTokenDate but that also gets set to today. I have also tried different form events but nothing seems to either be called or work.

What is the best way to get this to default to a different date?

2

I know it has been a while, but I was looking for this today and figure it could help someone else in the future.

The best way I have found is via the EpiDataView in your form Load event. Set Field X to DBNull where X is the sequence number of your field. You can find which one it is by selecting the field in the customization WSYWIG and looking at the title. For example a DateTime Field might be tdtfield5, which would make it Field5 in the EpiDataView. Here is a sample Form Load event.

private void BAQReportForm_Load(object sender, EventArgs args)
{
			EpiDataView rp = (EpiDataView)(oTrans.EpiDataViews["ReportParam"]);
			rp.dataView[rp.Row]["field5"] = DBNull.Value; 
}