1. Home
  2. Point-Of-Sale Software
  3. Top Items split into catagories

Top Items split into catagories

I need to see the top items under catagory headings - i've played with reports and tired to customise them, but no joy. I'd like this report for an HQ environment, but SO would be good enough. Would anyone give me pointers? Thanks!!

Reply to
Philip Gass
Loading thread data ...

HI Philip, I can really help you in this. Open the Sales - Top Items Report.qrp report and do the following:

  1. Modify the Query and Group by clause first see below the code: TablesQueried = "FROM TransactionEntry WITH(NOLOCK) INNER JOIN [Transaction] WITH(NOLOCK) ON TransactionEntry.TransactionNumber [Transaction].TransactionNumber LEFT JOIN

Item WITH (NOLOCK) On TransactionEntry.ItemID = Item.ID LEFT JOIN Category WITH(NOLOCK) ON Item.CategoryID = Category.ID " SelCriteria = "" GroupBy = "Category.Name,Item.ItemLookupCode"

  1. Add the Category Column Next. do this your first column

Begin Column FieldName = "Category.Name" DrillDownFieldName = "Category.Name" DrillDownReportName = "" Title = "Category" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1515 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

  1. Save the report and run the report. You can after this select the Category as your first grouping level and now you have done.

Rate please

"Philip Gass" wrote:

Reply to
Akber Alwani

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.