# BAQ Report -> Report Options + BAQ Parameter + Criteria and Calculated Field [SOLVED]

**Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5)
**Created:** 2016-12-22 14:34 UTC
**Views:** 1793
**Replies:** 1
**URL:** https://www.epiusers.help/t/baq-report-report-options-baq-parameter-criteria-and-calculated-field-solved/36709

---

## Post #1 by @DanB

Hey people how are u?, 
here is me again, whit another thing that cant resolve.. this time is not a code issue. 

I have a BAQ Report, that have the open releases white pending Qty from all time to:

 - need to make:  Today + **{User imput how many days}**

its any way to do this?

i'm thinking some like on BAQ make some parameter.. then use this on criteria expression, its possible? i have too to use this on calculated field, for print the TO DATE value on report.

Regards

---

## Post #2 by @DanB

Ok, for all watching for this.. there is the Auto-Response XD

how i solve:

1 - On BAQ i make a Calculated Field 
> CASE 
> 	WHEN DATEDIFF(DAY, GETDATE(), CAST(PORel.DueDate AS datetime)) < 0 THEN 0 
> 	ELSE DATEDIFF(DAY, GETDATE(), CAST(PORel.DueDate AS datetime))
> END

you may note that i convert on 0 if duedate is minor than actual date, this is for get too the pending from before.

2 - ON BAQ Report, Option Field Tab, simply write the field name: **Calculated_DiasDiferencia** in my case, and on condition i put <=.
 (note that calculated fields are not in drodown, but when you write correctly the name, all rest of fields are autocompleted, and the report work correcly)

whit this solution u can allow user to filter like i want. Simple solution and work perfectly.

I dont get a way to make BAQ Report interact whit BAQ Parameter, but here i present u an alternative for do some like that.

---


**Canonical:** https://www.epiusers.help/t/baq-report-report-options-baq-parameter-criteria-and-calculated-field-solved/36709
**Original content:** https://www.epiusers.help/t/baq-report-report-options-baq-parameter-criteria-and-calculated-field-solved/36709