Easy way to get list of blocked from sale items

Posted by Skyler Lister A on June 25, 2007, 12:50 pm

Please log in for more thread options

Hi, I was looking for a way to generate a list of all items in the store with
the block sale check box active. If there is a way to get this inside RMS or
through a SQL query that would be great.

Thanks, Skyler

Posted by convoluted on June 25, 2007, 5:14 pm

Please log in for more thread options

Hi Skyler - try

SELECT * FROM ITEM WHERE BLOCKSALESTYPE = 1;

Hope this helps.....

"Skyler Lister Aley" wrote:

> Hi, I was looking for a way to generate a list of all items in the store with

> the block sale check box active. If there is a way to get this inside RMS or

> through a SQL query that would be great.

> Thanks, Skyler

Posted by Akber Alwani on June 26, 2007, 12:40 am

Please log in for more thread options

hi I just add with the convoluated. is that in most reports where you have
sales. you need to add the following code to accomplished (open the .grp file
i.e. Sales - Detailed Sales Report.qrp)
Add the following lines any where in your report and save the report.

Begin Column
FieldName = "Item.BLOCKSALESTYPE"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Block Sales"
VBDataType = vbBoolean
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1057
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignCenterCenter
End Column

Run the Sales Detailed report and select Block Sales column click Yes /No
per your requirement and add as criteria for the report. it will works.

"Skyler Lister Aley" wrote:

> Hi, I was looking for a way to generate a list of all items in the store with

> the block sale check box active. If there is a way to get this inside RMS or

> through a SQL query that would be great.

> Thanks, Skyler

Posted by Skyler Lister A on June 27, 2007, 5:22 pm

Please log in for more thread options

Thanks! We will try both solutions

-Skyler

"Akber Alwani" wrote:

> hi I just add with the convoluated. is that in most reports where you have

> sales. you need to add the following code to accomplished (open the .grp file

> i.e. Sales - Detailed Sales Report.qrp)

> Add the following lines any where in your report and save the report.

> Begin Column

> FieldName = "Item.BLOCKSALESTYPE"

> DrillDownFieldName = ""

> DrillDownReportName = ""

> Title = "Block Sales"

> VBDataType = vbBoolean

> Formula = ""

> ColHidden = False

> ColNotDisplayable = False

> FilterDisabled = False

> ColWidth = 1057

> GroupMethod = groupmethodNone

> ColFormat = ""

> ColAlignment = flexAlignCenterCenter

> End Column

> Run the Sales Detailed report and select Block Sales column click Yes /No

> per your requirement and add as criteria for the report. it will works.

> "Skyler Lister Aley" wrote:

> > Hi, I was looking for a way to generate a list of all items in the store

with

> > the block sale check box active. If there is a way to get this inside RMS or

> > through a SQL query that would be great.

> >

> > Thanks, Skyler