I have added two parameters for Start Date and End Date, I want to implement it into the following:

{SPECIAL_PRICING.BVSPECPRICESOURCEID} = "V" and
{SPECIAL_PRICING.BVSPECPRICEWHSE} in {?BV99IN01FromWarehouse} to {?BV99IN02ToWarehouse} and
{SPECIAL_PRICING.BVSPECPRICECODE} in {?BV99VN01FromVendor} to {?BV99VN02ToVendor} and
(if {?BV99IN25InStockUOM}
    then {SPECIAL_PRICING.BVSPECPRICEUOM} = {INVENTORY.BVSTKUOM}
else {SPECIAL_PRICING.BVSPECPRICEUOM} >= "") and
(if not({?BV99IN23IncludeHeldItems})
    then {INVENTORY.HOLD} = 0
else
    {INVENTORY.HOLD} < 2)

To do so I did the following:
{SPECIAL_PRICING.BVSPECPRICESOURCEID} = "V" and
{SPECIAL_PRICING.BVSPECPRICEWHSE} in {?BV99IN01FromWarehouse} to {?BV99IN02ToWarehouse} and
{SPECIAL_PRICING.BVSPECPRICECODE} in {?BV99VN01FromVendor} to {?BV99VN02ToVendor} and
{SPECIAL_PRICING.BVSPECPRICECODE} in {?BV99DT09StartDate} to {?BV99DT10EndDate} and
(if {?BV99IN25InStockUOM}
    then {SPECIAL_PRICING.BVSPECPRICEUOM} = {INVENTORY.BVSTKUOM}
else {SPECIAL_PRICING.BVSPECPRICEUOM} >= "") and
(if not({?BV99IN23IncludeHeldItems})
    then {INVENTORY.HOLD} = 0
else
    {INVENTORY.HOLD} < 2)

The result : It will not post my snapshots but it says a string is required here
Both parameters were set up as in other reports, New Added with value type of Date and then created with the default values set.
I am unsure of how to get these parameters working, please help if you can. I should also note this is version 10 but a built-in version using Sage Business Vision.


Edited by TanyaCVV - 20 Sep 2016 at 5:49am

Thanks, I still have not figured it out I am new to parameters. All I want to do is be able to make the report dependent on a specified date criteria instead of pulling everything year to date. The database categorizes everything into last year, this year, next year and then specifies periods within so it is not an easy process to create a monthly view.

So where I am getting confused maybe is where I am even trying to add this in. When I right click on the field in my report for YTD Totals which is where I have been trying to add my parameters and click edit formula I get the following

{INVENTORY.TY_PER_SLS01} + {INVENTORY.TY_PER_SLS02} + {INVENTORY.TY_PER_SLS03} +
{INVENTORY.TY_PER_SLS04} + {INVENTORY.TY_PER_SLS05} + {INVENTORY.TY_PER_SLS06} +
{INVENTORY.TY_PER_SLS07} + {INVENTORY.TY_PER_SLS08} + {INVENTORY.TY_PER_SLS09} +
{INVENTORY.TY_PER_SLS10} + {INVENTORY.TY_PER_SLS11} + {INVENTORY.TY_PER_SLS12} +
{INVENTORY.TY_PER_SLS13}

This tells me that it is pulling from every period for this year. Should I be building the parameters in here to tell it that I want it to only pull the amounts per sales period by the parameter?
If that is the case how would I do that?

I am at a bit of a loss but assuming I need to specify for each period that is my {?BV99DT10EndDate} and {?BV99DT09StartDate} within a certain range then use {INVENTORY.TY_PER_SLS01} ?

Hello,

No there is no date field, I was attempting to build in date parameters but the database is not set up to easily handle that.

Another idea perhaps might be easier and maybe you can help me with it would be to create a new column for Avg Monthly Sales.

Would I be able to type in all of the TY periods or even include the LY (last year periods) and build a formula that says for all of these periods I want to know the average monthly sales of the item in this row.

Would I be able to do that generically without having to specify each part / as well? Sorry, I am new to crystal aside from more basic formulas and general design and look of reports.

Is there some more information I can provide that may help? Because I do not understand either that is why I posted this up :)