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!!
Top Items split into catagories
Feb 16, 2007
1 Replies
HI Philip, I can really help you in this. Open the Sales - Top Items Report.qrp report and do the following:
- 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"
- 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
- 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:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required