Top Items

Akber,

I liked the idea of seeing the top items in specific departments so I tried
this and I am getting some errors. Here is what I have:
Thanks for your help.
Kevin

//--- Report Summary --- //

Begin ReportSummary
   ReportType = reporttypeSales
   ReportTitle = "Top Items Report"
   PageOrientation = pageorientationPortrait
   OutLineMode = True
   Groups = 0
   GroupDescription = ""
   DisplayLogo = True
   LogoFileName = "MyLogo.bmp"
   ProcedureCall = ""
   TablesQueried = <BEGIN>

      FROM        TransactionEntry WITH(NOLOCK)
      INNER JOIN  [Transaction] WITH(NOLOCK)
                  ON TransactionEntry.TransactionNumber =
[Transaction].TransactionNumber
                     AND TransactionEntry.StoreID = [Transaction].StoreID
      LEFT JOIN   Item WITH (NOLOCK)
                  ON TransactionEntry.ItemID = Item.ID
      LEFT JOIN   Category WITH(NOLOCK) ON Item.CategoryID=Category.ID
      LEFT JOIN   Department WITH(NOLOCK) ON
                  Item.DepartmentID=Department.ID"
<END>
   SelCriteria = ""
   GroupBy = "Department.Name,Category.Name,Item.ItemLookupCode"
   SortOrder = "Sales DESC"
End ReportSummary


//--- Title Rows ---//

Begin TitleRow
   Text = "<Store Name>"
   Font = "Arial"
   FontBold = True
   FontSize = 16
   Color = "Blue"
End TitleRow

Begin TitleRow
   Text = "<Report Title>"
   Font = "Arial"
   FontBold = True
   FontSize = 12
   Color = "Black"
End TitleRow

Begin TitleRow
   Text = "Generated On <Report Date>"
   Font = "Arial"
   FontBold = True
   FontSize = 10
   Color = "Black"
End TitleRow


//--- Filters ---//

Begin Filter
   FieldName = "[Transaction].Time"
   FilterOp = reportfilteropBetween
   FilterLoLim = "<YearStart>"
   FilterHilim = "<Today>"
End Filter


//--- Columns ---//

Begin Column
   FieldName = "ItemLookupCode"
   DrillDownFieldName = "Item.ItemLookupCode"
   DrillDownReportName = ""
   Title = "Item Lookup Code"
   VBDataType = vbString
   Formula = "MAX(Item.ItemLookupCode)"
   ColHidden = False
   ColNotDisplayable = False
   FilterDisabled = False
   ColWidth = 1800
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Begin Column
   FieldName = "ItemDescription"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   Title = "Description"
   VBDataType = vbString
   Formula = "MAX(Item.Description)"
   ColHidden = False
   ColNotDisplayable = False
   FilterDisabled = False
   ColWidth = 2835
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Begin Column
   FieldName = "Store.ID"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   Title = "Store ID"
   VBDataType = vbLong
   Formula = ""
   ColHidden = True
   ColNotDisplayable = True
   FilterDisabled = False
   ColWidth = 870
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Begin Column
   FieldName = "Store.StoreCode"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   Title = "Store Code"
   VBDataType = vbString
   Formula = ""
   ColHidden = True
   ColNotDisplayable = True
   FilterDisabled = False
   ColWidth = 1095
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Begin Column
   FieldName = "Store.Region"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   Title = "Store Region"
   VBDataType = vbString
   Formula = ""
   ColHidden = True
   ColNotDisplayable = True
   FilterDisabled = False
   ColWidth = 1335
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Begin Column
   FieldName = "Store.City"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   Title = "Store City"
   VBDataType = vbString
   Formula = ""
   ColHidden = True
   ColNotDisplayable = True
   FilterDisabled = False
   ColWidth = 1020
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Begin Column
   FieldName = "Store.State"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   Title = "Store State"
   VBDataType = vbString
   Formula = ""
   ColHidden = True
   ColNotDisplayable = True
   FilterDisabled = False
   ColWidth = 1155
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Begin Column
   FieldName = "Store.Zip"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   Title = "Store Zip"
   VBDataType = vbString
   Formula = ""
   ColHidden = True
   ColNotDisplayable = True
   FilterDisabled = False
   ColWidth = 945
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Begin Column
   FieldName = "Store.Country"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   Title = "Store Country"
   VBDataType = vbString
   Formula = ""
   ColHidden = True
   ColNotDisplayable = True
   FilterDisabled = False
   ColWidth = 1560
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Begin Column
   FieldName = "[Transaction].Time"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   Title = "Date Sold"
   VBDataType = vbDate
   Formula = ""
   ColHidden = True
   ColNotDisplayable = True
   FilterDisabled = False
   ColWidth = 1035
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Begin Column
   FieldName = "QtySold"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   Title = "Qty Sold"
   VBDataType = vbDouble
   Formula = "SUM(TransactionEntry.Quantity)"
   ColHidden = False
   ColNotDisplayable = False
   FilterDisabled = False
   ColWidth = 1710
   GroupMethod = groupmethodSum
   ColFormat = "#.##"
End Column

Begin Column
   FieldName = "Sales"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   Title = "Sales"
   VBDataType = vbCurrency
   Formula = "SUM(TransactionEntry.Price * TransactionEntry.Quantity)"
   ColHidden = False
   ColNotDisplayable = False
   FilterDisabled = False
   ColWidth = 1830
   GroupMethod = groupmethodSum
   ColFormat = ""
End Column

Begin Column
   FieldName = "Profit"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   Title = "Profit"
   VBDataType = vbCurrency
   Formula = "SUM((TransactionEntry.Price - TransactionEntry.Cost) *
TransactionEntry.Quantity)"
   ColHidden = False
   ColNotDisplayable = False
   FilterDisabled = False
   ColWidth = 1815
   GroupMethod = groupmethodSum
   ColFormat = ""
End 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

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






"gregfrgusa" <gregfrgusa@discussions.microsoft.com> wrote in message
news:ACF57133-6937-42E3-B29F-B8F845849257@microsoft.com...
> Thanks, Akber!
>
> "Akber Alwani" wrote:
>
>> Hi, you can do the following to achive this:
>> 1. Open the Sales -Top Items Report.grp in notepad. the file is located
>> at
>> \Program Files\Microsoft Retail Management System\Store
>> Operations\Reports
>> 2. Update/Replace the Begin Reportsummary with following 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 LEFT JOIN Department
>> WITH(NOLOCK) ON
>> Item.DepartmentID=Department.ID"
>>    SelCriteria = ""
>>    GroupBy = "Department.Name,Category.Name,Item.ItemLookupCode"
>> 3. Add the column underneath of Category.Name column with following code:
>> Begin Column
>>    FieldName = "Department.Name"
>>    DrillDownFieldName = "Department.Name"
>>    DrillDownReportName = ""
>>    Title = "Department"
>>    VBDataType = vbString
>>    Formula = ""
>>    ColHidden = False
>>    ColNotDisplayable = False
>>    FilterDisabled = False
>>    ColWidth = 1515
>>    GroupMethod = groupmethodNone
>>    ColFormat = ""
>>    ColAlignment = flexAlignLeftCenter
>> End Column
>>
>> Now Save the file and run the report. You are accomplished what you want.
>>
>> Please rate and give your comments about me.
>>
>> "gregfrgusa" wrote:
>>
>> > Hello,
>> >
>> > I am trying to run a report where the report line is a the item level,
>> > with
>> > qty sold, total sales, etc.
>> >
>> > The Top items report is good, but you cannot filter by departement.
>> > (eg
>> > Report the top selling items in Dept A).
>> >
>> > The Detailed sales report is OK also, and the group by item description
>> > is
>> > what I am looking for, but you cannot sort by the grouped level, so I
>> > cannot
>> > get the best seller to the top of the report.
>> >
>> > Thanks,
>> > Greg
>> > FRGUSA



0
3/5/2007 7:57:40 PM
pos 14173 articles. 0 followers. Follow

3 Replies
732 Views

Similar Articles

[PageSpeed] 34

Hi Keven,
I checked and the below mentioned code is working if you need anything else 
let me know please. rate also
//--- Report Summary --- //

Begin ReportSummary
   ReportType = reporttypeSales
   ReportTitle = "Top Items Report"
   PageOrientation = pageorientationPortrait
   WordWrap = False
   ShowDateTimePicker = False
   OutLineMode = True
   Groups = 0
   GroupDescription = ""
   DisplayLogo = True
   LogoFileName = "MyLogo.bmp"
   ProcedureCall = ""
   PreQuery1 = ""
   PreQuery2 = ""
   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 
LEFT JOIN Department WITH(NOLOCK) ON 

Item.DepartmentID=Department.ID"
   SelCriteria = ""
   GroupBy = 
"[Transaction].Time,Department.Name,Category.Name,Item.ItemLookupCode"
   SortOrder = "Sales DESC"
End ReportSummary


//--- Title Rows ---//

Begin TitleRow
   Text = "<Store Name>"
   Font = "Arial"
   FontBold = True
   FontSize = 16
   Color = "Blue"
End TitleRow

Begin TitleRow
   Text = "<Report Title>"
   Font = "Arial"
   FontBold = True
   FontSize = 12
   Color = "Black"
End TitleRow

Begin TitleRow
   Text = "Generated On <Report Date>"
   Font = "Arial"
   FontBold = True
   FontSize = 10
   Color = "Black"
End TitleRow


//--- Filters ---//

Begin Filter
   FieldName = "[Transaction].Time"
   FilterOp = reportfilteropBetween
   FilterLoLim = "<YearStart>"
   FilterHilim = "<Today>"
End Filter


//--- Columns ---//

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


Begin Column
   FieldName = "ItemLookupCode"
   DrillDownFieldName = "Item.ItemLookupCode"
   DrillDownReportName = ""
   StoreIDFieldName = ""
   Title = "Item Lookup Code"
   VBDataType = vbString
   Formula = "MAX(Item.ItemLookupCode)"
   ColHidden = False
   ColNotDisplayable = False
   FilterDisabled = False
   ColWidth = 2055
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Begin Column
   FieldName = "ItemDescription"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   StoreIDFieldName = ""
   Title = "Description"
   VBDataType = vbString
   Formula = "MAX(Item.Description)"
   ColHidden = False
   ColNotDisplayable = False
   FilterDisabled = False
   ColWidth = 2835
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Begin Column
   FieldName = "[Transaction].Time"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   StoreIDFieldName = ""
   Title = "Date Sold"
   VBDataType = vbDate
   Formula = ""
   ColHidden = False
   ColNotDisplayable = False
   FilterDisabled = False
   ColWidth = 1035
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Begin Column
   FieldName = "QtySold"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   StoreIDFieldName = ""
   Title = "Qty Sold"
   VBDataType = vbDouble
   Formula = "SUM(TransactionEntry.Quantity)"
   ColHidden = False
   ColNotDisplayable = False
   FilterDisabled = False
   ColWidth = 1710
   GroupMethod = groupmethodSum
   ColFormat = "#.##"
End Column

Begin Column
   FieldName = "Sales"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   StoreIDFieldName = ""
   Title = "Sales"
   VBDataType = vbCurrency
   Formula = "SUM(TransactionEntry.Price * TransactionEntry.Quantity)"
   ColHidden = False
   ColNotDisplayable = False
   FilterDisabled = False
   ColWidth = 1830
   GroupMethod = groupmethodSum
   ColFormat = ""
End Column

Begin Column
   FieldName = "Profit"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   StoreIDFieldName = ""
   Title = "Profit"
   VBDataType = vbCurrency
   Formula = "SUM((TransactionEntry.Price - TransactionEntry.Cost) * 
TransactionEntry.Quantity)"
   ColHidden = False
   ColNotDisplayable = False
   FilterDisabled = False
   ColWidth = 1815
   GroupMethod = groupmethodSum
   ColFormat = ""
End Column



"Kevin" wrote:

> Akber,
> 
> I liked the idea of seeing the top items in specific departments so I tried
> this and I am getting some errors. Here is what I have:
> Thanks for your help.
> Kevin
> 
> //--- Report Summary --- //
> 
> Begin ReportSummary
>    ReportType = reporttypeSales
>    ReportTitle = "Top Items Report"
>    PageOrientation = pageorientationPortrait
>    OutLineMode = True
>    Groups = 0
>    GroupDescription = ""
>    DisplayLogo = True
>    LogoFileName = "MyLogo.bmp"
>    ProcedureCall = ""
>    TablesQueried = <BEGIN>
> 
>       FROM        TransactionEntry WITH(NOLOCK)
>       INNER JOIN  [Transaction] WITH(NOLOCK)
>                   ON TransactionEntry.TransactionNumber =
> [Transaction].TransactionNumber
>                      AND TransactionEntry.StoreID = [Transaction].StoreID
>       LEFT JOIN   Item WITH (NOLOCK)
>                   ON TransactionEntry.ItemID = Item.ID
>       LEFT JOIN   Category WITH(NOLOCK) ON Item.CategoryID=Category.ID
>       LEFT JOIN   Department WITH(NOLOCK) ON
>                   Item.DepartmentID=Department.ID"
> <END>
>    SelCriteria = ""
>    GroupBy = "Department.Name,Category.Name,Item.ItemLookupCode"
>    SortOrder = "Sales DESC"
> End ReportSummary
> 
> 
> //--- Title Rows ---//
> 
> Begin TitleRow
>    Text = "<Store Name>"
>    Font = "Arial"
>    FontBold = True
>    FontSize = 16
>    Color = "Blue"
> End TitleRow
> 
> Begin TitleRow
>    Text = "<Report Title>"
>    Font = "Arial"
>    FontBold = True
>    FontSize = 12
>    Color = "Black"
> End TitleRow
> 
> Begin TitleRow
>    Text = "Generated On <Report Date>"
>    Font = "Arial"
>    FontBold = True
>    FontSize = 10
>    Color = "Black"
> End TitleRow
> 
> 
> //--- Filters ---//
> 
> Begin Filter
>    FieldName = "[Transaction].Time"
>    FilterOp = reportfilteropBetween
>    FilterLoLim = "<YearStart>"
>    FilterHilim = "<Today>"
> End Filter
> 
> 
> //--- Columns ---//
> 
> Begin Column
>    FieldName = "ItemLookupCode"
>    DrillDownFieldName = "Item.ItemLookupCode"
>    DrillDownReportName = ""
>    Title = "Item Lookup Code"
>    VBDataType = vbString
>    Formula = "MAX(Item.ItemLookupCode)"
>    ColHidden = False
>    ColNotDisplayable = False
>    FilterDisabled = False
>    ColWidth = 1800
>    GroupMethod = groupmethodNone
>    ColFormat = ""
> End Column
> 
> Begin Column
>    FieldName = "ItemDescription"
>    DrillDownFieldName = ""
>    DrillDownReportName = ""
>    Title = "Description"
>    VBDataType = vbString
>    Formula = "MAX(Item.Description)"
>    ColHidden = False
>    ColNotDisplayable = False
>    FilterDisabled = False
>    ColWidth = 2835
>    GroupMethod = groupmethodNone
>    ColFormat = ""
> End Column
> 
> Begin Column
>    FieldName = "Store.ID"
>    DrillDownFieldName = ""
>    DrillDownReportName = ""
>    Title = "Store ID"
>    VBDataType = vbLong
>    Formula = ""
>    ColHidden = True
>    ColNotDisplayable = True
>    FilterDisabled = False
>    ColWidth = 870
>    GroupMethod = groupmethodNone
>    ColFormat = ""
> End Column
> 
> Begin Column
>    FieldName = "Store.StoreCode"
>    DrillDownFieldName = ""
>    DrillDownReportName = ""
>    Title = "Store Code"
>    VBDataType = vbString
>    Formula = ""
>    ColHidden = True
>    ColNotDisplayable = True
>    FilterDisabled = False
>    ColWidth = 1095
>    GroupMethod = groupmethodNone
>    ColFormat = ""
> End Column
> 
> Begin Column
>    FieldName = "Store.Region"
>    DrillDownFieldName = ""
>    DrillDownReportName = ""
>    Title = "Store Region"
>    VBDataType = vbString
>    Formula = ""
>    ColHidden = True
>    ColNotDisplayable = True
>    FilterDisabled = False
>    ColWidth = 1335
>    GroupMethod = groupmethodNone
>    ColFormat = ""
> End Column
> 
> Begin Column
>    FieldName = "Store.City"
>    DrillDownFieldName = ""
>    DrillDownReportName = ""
>    Title = "Store City"
>    VBDataType = vbString
>    Formula = ""
>    ColHidden = True
>    ColNotDisplayable = True
>    FilterDisabled = False
>    ColWidth = 1020
>    GroupMethod = groupmethodNone
>    ColFormat = ""
> End Column
> 
> Begin Column
>    FieldName = "Store.State"
>    DrillDownFieldName = ""
>    DrillDownReportName = ""
>    Title = "Store State"
>    VBDataType = vbString
>    Formula = ""
>    ColHidden = True
>    ColNotDisplayable = True
>    FilterDisabled = False
>    ColWidth = 1155
>    GroupMethod = groupmethodNone
>    ColFormat = ""
> End Column
> 
> Begin Column
>    FieldName = "Store.Zip"
>    DrillDownFieldName = ""
>    DrillDownReportName = ""
>    Title = "Store Zip"
>    VBDataType = vbString
>    Formula = ""
>    ColHidden = True
>    ColNotDisplayable = True
>    FilterDisabled = False
>    ColWidth = 945
>    GroupMethod = groupmethodNone
>    ColFormat = ""
> End Column
> 
> Begin Column
>    FieldName = "Store.Country"
>    DrillDownFieldName = ""
>    DrillDownReportName = ""
>    Title = "Store Country"
>    VBDataType = vbString
>    Formula = ""
>    ColHidden = True
>    ColNotDisplayable = True
>    FilterDisabled = False
>    ColWidth = 1560
>    GroupMethod = groupmethodNone
>    ColFormat = ""
> End Column
> 
> Begin Column
>    FieldName = "[Transaction].Time"
>    DrillDownFieldName = ""
>    DrillDownReportName = ""
>    Title = "Date Sold"
>    VBDataType = vbDate
>    Formula = ""
>    ColHidden = True
>    ColNotDisplayable = True
>    FilterDisabled = False
>    ColWidth = 1035
>    GroupMethod = groupmethodNone
>    ColFormat = ""
> End Column
> 
> Begin Column
>    FieldName = "QtySold"
>    DrillDownFieldName = ""
>    DrillDownReportName = ""
>    Title = "Qty Sold"
>    VBDataType = vbDouble
>    Formula = "SUM(TransactionEntry.Quantity)"
>    ColHidden = False
>    ColNotDisplayable = False
>    FilterDisabled = False
>    ColWidth = 1710
>    GroupMethod = groupmethodSum
>    ColFormat = "#.##"
> End Column
> 
> Begin Column
>    FieldName = "Sales"
>    DrillDownFieldName = ""
>    DrillDownReportName = ""
>    Title = "Sales"
>    VBDataType = vbCurrency
>    Formula = "SUM(TransactionEntry.Price * TransactionEntry.Quantity)"
>    ColHidden = False
>    ColNotDisplayable = False
>    FilterDisabled = False
>    ColWidth = 1830
>    GroupMethod = groupmethodSum
>    ColFormat = ""
> End Column
> 
> Begin Column
>    FieldName = "Profit"
>    DrillDownFieldName = ""
>    DrillDownReportName = ""
>    Title = "Profit"
>    VBDataType = vbCurrency
>    Formula = "SUM((TransactionEntry.Price - TransactionEntry.Cost) *
> TransactionEntry.Quantity)"
>    ColHidden = False
>    ColNotDisplayable = False
>    FilterDisabled = False
>    ColWidth = 1815
>    GroupMethod = groupmethodSum
>    ColFormat = ""
> End 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
> 
> Begin Column
>    FieldName = "Department.Name"
>    DrillDownFieldName = "Department.Name"
>    DrillDownReportName = ""
>    Title = "Department"
>    VBDataType = vbString
>    Formula = ""
>    ColHidden = False
>    ColNotDisplayable = False
>    FilterDisabled = False
>    ColWidth = 1515
0
AkberAlwani (916)
3/6/2007 9:40:09 AM
Akber,

I keep getting an error read on line #18

Kevin

"Akber Alwani" <AkberAlwani@discussions.microsoft.com> wrote in message 
news:19515C14-E317-48E2-839F-F2AE3D6A2A97@microsoft.com...
> Hi Keven,
> I checked and the below mentioned code is working if you need anything 
> else
> let me know please. rate also
> //--- Report Summary --- //
>
> Begin ReportSummary
>   ReportType = reporttypeSales
>   ReportTitle = "Top Items Report"
>   PageOrientation = pageorientationPortrait
>   WordWrap = False
>   ShowDateTimePicker = False
>   OutLineMode = True
>   Groups = 0
>   GroupDescription = ""
>   DisplayLogo = True
>   LogoFileName = "MyLogo.bmp"
>   ProcedureCall = ""
>   PreQuery1 = ""
>   PreQuery2 = ""
>   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
> LEFT JOIN Department WITH(NOLOCK) ON
>
> Item.DepartmentID=Department.ID"
>   SelCriteria = ""
>   GroupBy =
> "[Transaction].Time,Department.Name,Category.Name,Item.ItemLookupCode"
>   SortOrder = "Sales DESC"
> End ReportSummary
>
>
> //--- Title Rows ---//
>
> Begin TitleRow
>   Text = "<Store Name>"
>   Font = "Arial"
>   FontBold = True
>   FontSize = 16
>   Color = "Blue"
> End TitleRow
>
> Begin TitleRow
>   Text = "<Report Title>"
>   Font = "Arial"
>   FontBold = True
>   FontSize = 12
>   Color = "Black"
> End TitleRow
>
> Begin TitleRow
>   Text = "Generated On <Report Date>"
>   Font = "Arial"
>   FontBold = True
>   FontSize = 10
>   Color = "Black"
> End TitleRow
>
>
> //--- Filters ---//
>
> Begin Filter
>   FieldName = "[Transaction].Time"
>   FilterOp = reportfilteropBetween
>   FilterLoLim = "<YearStart>"
>   FilterHilim = "<Today>"
> End Filter
>
>
> //--- Columns ---//
>
> Begin Column
>    FieldName = "Department.Name"
>    DrillDownFieldName = "Department.Name"
>    DrillDownReportName = ""
>    Title = "Department"
>    VBDataType = vbString
>    Formula = ""
>    ColHidden = False
>    ColNotDisplayable = False
>    FilterDisabled = False
>    ColWidth = 1515
>    GroupMethod = groupmethodNone
>    ColFormat = ""
>    ColAlignment = flexAlignLeftCenter
> End Column
>
>
> Begin Column
>   FieldName = "ItemLookupCode"
>   DrillDownFieldName = "Item.ItemLookupCode"
>   DrillDownReportName = ""
>   StoreIDFieldName = ""
>   Title = "Item Lookup Code"
>   VBDataType = vbString
>   Formula = "MAX(Item.ItemLookupCode)"
>   ColHidden = False
>   ColNotDisplayable = False
>   FilterDisabled = False
>   ColWidth = 2055
>   GroupMethod = groupmethodNone
>   ColFormat = ""
> End Column
>
> Begin Column
>   FieldName = "ItemDescription"
>   DrillDownFieldName = ""
>   DrillDownReportName = ""
>   StoreIDFieldName = ""
>   Title = "Description"
>   VBDataType = vbString
>   Formula = "MAX(Item.Description)"
>   ColHidden = False
>   ColNotDisplayable = False
>   FilterDisabled = False
>   ColWidth = 2835
>   GroupMethod = groupmethodNone
>   ColFormat = ""
> End Column
>
> Begin Column
>   FieldName = "[Transaction].Time"
>   DrillDownFieldName = ""
>   DrillDownReportName = ""
>   StoreIDFieldName = ""
>   Title = "Date Sold"
>   VBDataType = vbDate
>   Formula = ""
>   ColHidden = False
>   ColNotDisplayable = False
>   FilterDisabled = False
>   ColWidth = 1035
>   GroupMethod = groupmethodNone
>   ColFormat = ""
> End Column
>
> Begin Column
>   FieldName = "QtySold"
>   DrillDownFieldName = ""
>   DrillDownReportName = ""
>   StoreIDFieldName = ""
>   Title = "Qty Sold"
>   VBDataType = vbDouble
>   Formula = "SUM(TransactionEntry.Quantity)"
>   ColHidden = False
>   ColNotDisplayable = False
>   FilterDisabled = False
>   ColWidth = 1710
>   GroupMethod = groupmethodSum
>   ColFormat = "#.##"
> End Column
>
> Begin Column
>   FieldName = "Sales"
>   DrillDownFieldName = ""
>   DrillDownReportName = ""
>   StoreIDFieldName = ""
>   Title = "Sales"
>   VBDataType = vbCurrency
>   Formula = "SUM(TransactionEntry.Price * TransactionEntry.Quantity)"
>   ColHidden = False
>   ColNotDisplayable = False
>   FilterDisabled = False
>   ColWidth = 1830
>   GroupMethod = groupmethodSum
>   ColFormat = ""
> End Column
>
> Begin Column
>   FieldName = "Profit"
>   DrillDownFieldName = ""
>   DrillDownReportName = ""
>   StoreIDFieldName = ""
>   Title = "Profit"
>   VBDataType = vbCurrency
>   Formula = "SUM((TransactionEntry.Price - TransactionEntry.Cost) *
> TransactionEntry.Quantity)"
>   ColHidden = False
>   ColNotDisplayable = False
>   FilterDisabled = False
>   ColWidth = 1815
>   GroupMethod = groupmethodSum
>   ColFormat = ""
> End Column
>
>
>
> "Kevin" wrote:
>
>> Akber,
>>
>> I liked the idea of seeing the top items in specific departments so I 
>> tried
>> this and I am getting some errors. Here is what I have:
>> Thanks for your help.
>> Kevin
>>
>> //--- Report Summary --- //
>>
>> Begin ReportSummary
>>    ReportType = reporttypeSales
>>    ReportTitle = "Top Items Report"
>>    PageOrientation = pageorientationPortrait
>>    OutLineMode = True
>>    Groups = 0
>>    GroupDescription = ""
>>    DisplayLogo = True
>>    LogoFileName = "MyLogo.bmp"
>>    ProcedureCall = ""
>>    TablesQueried = <BEGIN>
>>
>>       FROM        TransactionEntry WITH(NOLOCK)
>>       INNER JOIN  [Transaction] WITH(NOLOCK)
>>                   ON TransactionEntry.TransactionNumber =
>> [Transaction].TransactionNumber
>>                      AND TransactionEntry.StoreID = [Transaction].StoreID
>>       LEFT JOIN   Item WITH (NOLOCK)
>>                   ON TransactionEntry.ItemID = Item.ID
>>       LEFT JOIN   Category WITH(NOLOCK) ON Item.CategoryID=Category.ID
>>       LEFT JOIN   Department WITH(NOLOCK) ON
>>                   Item.DepartmentID=Department.ID"
>> <END>
>>    SelCriteria = ""
>>    GroupBy = "Department.Name,Category.Name,Item.ItemLookupCode"
>>    SortOrder = "Sales DESC"
>> End ReportSummary
>>
>>
>> //--- Title Rows ---//
>>
>> Begin TitleRow
>>    Text = "<Store Name>"
>>    Font = "Arial"
>>    FontBold = True
>>    FontSize = 16
>>    Color = "Blue"
>> End TitleRow
>>
>> Begin TitleRow
>>    Text = "<Report Title>"
>>    Font = "Arial"
>>    FontBold = True
>>    FontSize = 12
>>    Color = "Black"
>> End TitleRow
>>
>> Begin TitleRow
>>    Text = "Generated On <Report Date>"
>>    Font = "Arial"
>>    FontBold = True
>>    FontSize = 10
>>    Color = "Black"
>> End TitleRow
>>
>>
>> //--- Filters ---//
>>
>> Begin Filter
>>    FieldName = "[Transaction].Time"
>>    FilterOp = reportfilteropBetween
>>    FilterLoLim = "<YearStart>"
>>    FilterHilim = "<Today>"
>> End Filter
>>
>>
>> //--- Columns ---//
>>
>> Begin Column
>>    FieldName = "ItemLookupCode"
>>    DrillDownFieldName = "Item.ItemLookupCode"
>>    DrillDownReportName = ""
>>    Title = "Item Lookup Code"
>>    VBDataType = vbString
>>    Formula = "MAX(Item.ItemLookupCode)"
>>    ColHidden = False
>>    ColNotDisplayable = False
>>    FilterDisabled = False
>>    ColWidth = 1800
>>    GroupMethod = groupmethodNone
>>    ColFormat = ""
>> End Column
>>
>> Begin Column
>>    FieldName = "ItemDescription"
>>    DrillDownFieldName = ""
>>    DrillDownReportName = ""
>>    Title = "Description"
>>    VBDataType = vbString
>>    Formula = "MAX(Item.Description)"
>>    ColHidden = False
>>    ColNotDisplayable = False
>>    FilterDisabled = False
>>    ColWidth = 2835
>>    GroupMethod = groupmethodNone
>>    ColFormat = ""
>> End Column
>>
>> Begin Column
>>    FieldName = "Store.ID"
>>    DrillDownFieldName = ""
>>    DrillDownReportName = ""
>>    Title = "Store ID"
>>    VBDataType = vbLong
>>    Formula = ""
>>    ColHidden = True
>>    ColNotDisplayable = True
>>    FilterDisabled = False
>>    ColWidth = 870
>>    GroupMethod = groupmethodNone
>>    ColFormat = ""
>> End Column
>>
>> Begin Column
>>    FieldName = "Store.StoreCode"
>>    DrillDownFieldName = ""
>>    DrillDownReportName = ""
>>    Title = "Store Code"
>>    VBDataType = vbString
>>    Formula = ""
>>    ColHidden = True
>>    ColNotDisplayable = True
>>    FilterDisabled = False
>>    ColWidth = 1095
>>    GroupMethod = groupmethodNone
>>    ColFormat = ""
>> End Column
>>
>> Begin Column
>>    FieldName = "Store.Region"
>>    DrillDownFieldName = ""
>>    DrillDownReportName = ""
>>    Title = "Store Region"
>>    VBDataType = vbString
>>    Formula = ""
>>    ColHidden = True
>>    ColNotDisplayable = True
>>    FilterDisabled = False
>>    ColWidth = 1335
>>    GroupMethod = groupmethodNone
>>    ColFormat = ""
>> End Column
>>
>> Begin Column
>>    FieldName = "Store.City"
>>    DrillDownFieldName = ""
>>    DrillDownReportName = ""
>>    Title = "Store City"
>>    VBDataType = vbString
>>    Formula = ""
>>    ColHidden = True
>>    ColNotDisplayable = True
>>    FilterDisabled = False
>>    ColWidth = 1020
>>    GroupMethod = groupmethodNone
>>    ColFormat = ""
>> End Column
>>
>> Begin Column
>>    FieldName = "Store.State"
>>    DrillDownFieldName = ""
>>    DrillDownReportName = ""
>>    Title = "Store State"
>>    VBDataType = vbString
>>    Formula = ""
>>    ColHidden = True
>>    ColNotDisplayable = True
>>    FilterDisabled = False
>>    ColWidth = 1155
>>    GroupMethod = groupmethodNone
>>    ColFormat = ""
>> End Column
>>
>> Begin Column
>>    FieldName = "Store.Zip"
>>    DrillDownFieldName = ""
>>    DrillDownReportName = ""
>>    Title = "Store Zip"
>>    VBDataType = vbString
>>    Formula = ""
>>    ColHidden = True
>>    ColNotDisplayable = True
>>    FilterDisabled = False
>>    ColWidth = 945
>>    GroupMethod = groupmethodNone
>>    ColFormat = ""
>> End Column
>>
>> Begin Column
>>    FieldName = "Store.Country"
>>    DrillDownFieldName = ""
>>    DrillDownReportName = ""
>>    Title = "Store Country"
>>    VBDataType = vbString
>>    Formula = ""
>>    ColHidden = True
>>    ColNotDisplayable = True
>>    FilterDisabled = False
>>    ColWidth = 1560
>>    GroupMethod = groupmethodNone
>>    ColFormat = ""
>> End Column
>>
>> Begin Column
>>    FieldName = "[Transaction].Time"
>>    DrillDownFieldName = ""
>>    DrillDownReportName = ""
>>    Title = "Date Sold"
>>    VBDataType = vbDate
>>    Formula = ""
>>    ColHidden = True
>>    ColNotDisplayable = True
>>    FilterDisabled = False
>>    ColWidth = 1035
>>    GroupMethod = groupmethodNone
>>    ColFormat = ""
>> End Column
>>
>> Begin Column
>>    FieldName = "QtySold"
>>    DrillDownFieldName = ""
>>    DrillDownReportName = ""
>>    Title = "Qty Sold"
>>    VBDataType = vbDouble
>>    Formula = "SUM(TransactionEntry.Quantity)"
>>    ColHidden = False
>>    ColNotDisplayable = False
>>    FilterDisabled = False
>>    ColWidth = 1710
>>    GroupMethod = groupmethodSum
>>    ColFormat = "#.##"
>> End Column
>>
>> Begin Column
>>    FieldName = "Sales"
>>    DrillDownFieldName = ""
>>    DrillDownReportName = ""
>>    Title = "Sales"
>>    VBDataType = vbCurrency
>>    Formula = "SUM(TransactionEntry.Price * TransactionEntry.Quantity)"
>>    ColHidden = False
>>    ColNotDisplayable = False
>>    FilterDisabled = False
>>    ColWidth = 1830
>>    GroupMethod = groupmethodSum
>>    ColFormat = ""
>> End Column
>>
>> Begin Column
>>    FieldName = "Profit"
>>    DrillDownFieldName = ""
>>    DrillDownReportName = ""
>>    Title = "Profit"
>>    VBDataType = vbCurrency
>>    Formula = "SUM((TransactionEntry.Price - TransactionEntry.Cost) *
>> TransactionEntry.Quantity)"
>>    ColHidden = False
>>    ColNotDisplayable = False
>>    FilterDisabled = False
>>    ColWidth = 1815
>>    GroupMethod = groupmethodSum
>>    ColFormat = ""
>> End 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
>>
>> Begin Column
>>    FieldName = "Department.Name"
>>    DrillDownFieldName = "Department.Name"
>>    DrillDownReportName = ""
>>    Title = "Department"
>>    VBDataType = vbString
>>    Formula = ""
>>    ColHidden = False
>>    ColNotDisplayable = False
>>    FilterDisabled = False
>>    ColWidth = 1515 


0
3/6/2007 5:49:45 PM
Kevin, I have requested you to send me your email address if you feel 
comfortable or just send me email at alwani89@hotmail.com I have report 
running over here. so I just email you mine one.

"Kevin" wrote:

> Akber,
> 
> I keep getting an error read on line #18
> 
> Kevin
> 
> "Akber Alwani" <AkberAlwani@discussions.microsoft.com> wrote in message 
> news:19515C14-E317-48E2-839F-F2AE3D6A2A97@microsoft.com...
> > Hi Keven,
> > I checked and the below mentioned code is working if you need anything 
> > else
> > let me know please. rate also
> > //--- Report Summary --- //
> >
> > Begin ReportSummary
> >   ReportType = reporttypeSales
> >   ReportTitle = "Top Items Report"
> >   PageOrientation = pageorientationPortrait
> >   WordWrap = False
> >   ShowDateTimePicker = False
> >   OutLineMode = True
> >   Groups = 0
> >   GroupDescription = ""
> >   DisplayLogo = True
> >   LogoFileName = "MyLogo.bmp"
> >   ProcedureCall = ""
> >   PreQuery1 = ""
> >   PreQuery2 = ""
> >   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
> > LEFT JOIN Department WITH(NOLOCK) ON
> >
> > Item.DepartmentID=Department.ID"
> >   SelCriteria = ""
> >   GroupBy =
> > "[Transaction].Time,Department.Name,Category.Name,Item.ItemLookupCode"
> >   SortOrder = "Sales DESC"
> > End ReportSummary
> >
> >
> > //--- Title Rows ---//
> >
> > Begin TitleRow
> >   Text = "<Store Name>"
> >   Font = "Arial"
> >   FontBold = True
> >   FontSize = 16
> >   Color = "Blue"
> > End TitleRow
> >
> > Begin TitleRow
> >   Text = "<Report Title>"
> >   Font = "Arial"
> >   FontBold = True
> >   FontSize = 12
> >   Color = "Black"
> > End TitleRow
> >
> > Begin TitleRow
> >   Text = "Generated On <Report Date>"
> >   Font = "Arial"
> >   FontBold = True
> >   FontSize = 10
> >   Color = "Black"
> > End TitleRow
> >
> >
> > //--- Filters ---//
> >
> > Begin Filter
> >   FieldName = "[Transaction].Time"
> >   FilterOp = reportfilteropBetween
> >   FilterLoLim = "<YearStart>"
> >   FilterHilim = "<Today>"
> > End Filter
> >
> >
> > //--- Columns ---//
> >
> > Begin Column
> >    FieldName = "Department.Name"
> >    DrillDownFieldName = "Department.Name"
> >    DrillDownReportName = ""
> >    Title = "Department"
> >    VBDataType = vbString
> >    Formula = ""
> >    ColHidden = False
> >    ColNotDisplayable = False
> >    FilterDisabled = False
> >    ColWidth = 1515
> >    GroupMethod = groupmethodNone
> >    ColFormat = ""
> >    ColAlignment = flexAlignLeftCenter
> > End Column
> >
> >
> > Begin Column
> >   FieldName = "ItemLookupCode"
> >   DrillDownFieldName = "Item.ItemLookupCode"
> >   DrillDownReportName = ""
> >   StoreIDFieldName = ""
> >   Title = "Item Lookup Code"
> >   VBDataType = vbString
> >   Formula = "MAX(Item.ItemLookupCode)"
> >   ColHidden = False
> >   ColNotDisplayable = False
> >   FilterDisabled = False
> >   ColWidth = 2055
> >   GroupMethod = groupmethodNone
> >   ColFormat = ""
> > End Column
> >
> > Begin Column
> >   FieldName = "ItemDescription"
> >   DrillDownFieldName = ""
> >   DrillDownReportName = ""
> >   StoreIDFieldName = ""
> >   Title = "Description"
> >   VBDataType = vbString
> >   Formula = "MAX(Item.Description)"
> >   ColHidden = False
> >   ColNotDisplayable = False
> >   FilterDisabled = False
> >   ColWidth = 2835
> >   GroupMethod = groupmethodNone
> >   ColFormat = ""
> > End Column
> >
> > Begin Column
> >   FieldName = "[Transaction].Time"
> >   DrillDownFieldName = ""
> >   DrillDownReportName = ""
> >   StoreIDFieldName = ""
> >   Title = "Date Sold"
> >   VBDataType = vbDate
> >   Formula = ""
> >   ColHidden = False
> >   ColNotDisplayable = False
> >   FilterDisabled = False
> >   ColWidth = 1035
> >   GroupMethod = groupmethodNone
> >   ColFormat = ""
> > End Column
> >
> > Begin Column
> >   FieldName = "QtySold"
> >   DrillDownFieldName = ""
> >   DrillDownReportName = ""
> >   StoreIDFieldName = ""
> >   Title = "Qty Sold"
> >   VBDataType = vbDouble
> >   Formula = "SUM(TransactionEntry.Quantity)"
> >   ColHidden = False
> >   ColNotDisplayable = False
> >   FilterDisabled = False
> >   ColWidth = 1710
> >   GroupMethod = groupmethodSum
> >   ColFormat = "#.##"
> > End Column
> >
> > Begin Column
> >   FieldName = "Sales"
> >   DrillDownFieldName = ""
> >   DrillDownReportName = ""
> >   StoreIDFieldName = ""
> >   Title = "Sales"
> >   VBDataType = vbCurrency
> >   Formula = "SUM(TransactionEntry.Price * TransactionEntry.Quantity)"
> >   ColHidden = False
> >   ColNotDisplayable = False
> >   FilterDisabled = False
> >   ColWidth = 1830
> >   GroupMethod = groupmethodSum
> >   ColFormat = ""
> > End Column
> >
> > Begin Column
> >   FieldName = "Profit"
> >   DrillDownFieldName = ""
> >   DrillDownReportName = ""
> >   StoreIDFieldName = ""
> >   Title = "Profit"
> >   VBDataType = vbCurrency
> >   Formula = "SUM((TransactionEntry.Price - TransactionEntry.Cost) *
> > TransactionEntry.Quantity)"
> >   ColHidden = False
> >   ColNotDisplayable = False
> >   FilterDisabled = False
> >   ColWidth = 1815
> >   GroupMethod = groupmethodSum
> >   ColFormat = ""
> > End Column
> >
> >
> >
> > "Kevin" wrote:
> >
> >> Akber,
> >>
> >> I liked the idea of seeing the top items in specific departments so I 
> >> tried
> >> this and I am getting some errors. Here is what I have:
> >> Thanks for your help.
> >> Kevin
> >>
> >> //--- Report Summary --- //
> >>
> >> Begin ReportSummary
> >>    ReportType = reporttypeSales
> >>    ReportTitle = "Top Items Report"
> >>    PageOrientation = pageorientationPortrait
> >>    OutLineMode = True
> >>    Groups = 0
> >>    GroupDescription = ""
> >>    DisplayLogo = True
> >>    LogoFileName = "MyLogo.bmp"
> >>    ProcedureCall = ""
> >>    TablesQueried = <BEGIN>
> >>
> >>       FROM        TransactionEntry WITH(NOLOCK)
> >>       INNER JOIN  [Transaction] WITH(NOLOCK)
> >>                   ON TransactionEntry.TransactionNumber =
> >> [Transaction].TransactionNumber
> >>                      AND TransactionEntry.StoreID = [Transaction].StoreID
> >>       LEFT JOIN   Item WITH (NOLOCK)
> >>                   ON TransactionEntry.ItemID = Item.ID
> >>       LEFT JOIN   Category WITH(NOLOCK) ON Item.CategoryID=Category.ID
> >>       LEFT JOIN   Department WITH(NOLOCK) ON
> >>                   Item.DepartmentID=Department.ID"
> >> <END>
> >>    SelCriteria = ""
> >>    GroupBy = "Department.Name,Category.Name,Item.ItemLookupCode"
> >>    SortOrder = "Sales DESC"
> >> End ReportSummary
> >>
> >>
> >> //--- Title Rows ---//
> >>
> >> Begin TitleRow
> >>    Text = "<Store Name>"
> >>    Font = "Arial"
> >>    FontBold = True
> >>    FontSize = 16
> >>    Color = "Blue"
> >> End TitleRow
> >>
> >> Begin TitleRow
> >>    Text = "<Report Title>"
> >>    Font = "Arial"
> >>    FontBold = True
> >>    FontSize = 12
> >>    Color = "Black"
> >> End TitleRow
> >>
> >> Begin TitleRow
> >>    Text = "Generated On <Report Date>"
> >>    Font = "Arial"
> >>    FontBold = True
> >>    FontSize = 10
> >>    Color = "Black"
> >> End TitleRow
> >>
> >>
> >> //--- Filters ---//
> >>
> >> Begin Filter
> >>    FieldName = "[Transaction].Time"
> >>    FilterOp = reportfilteropBetween
> >>    FilterLoLim = "<YearStart>"
> >>    FilterHilim = "<Today>"
> >> End Filter
> >>
> >>
> >> //--- Columns ---//
> >>
> >> Begin Column
> >>    FieldName = "ItemLookupCode"
> >>    DrillDownFieldName = "Item.ItemLookupCode"
> >>    DrillDownReportName = ""
> >>    Title = "Item Lookup Code"
> >>    VBDataType = vbString
> >>    Formula = "MAX(Item.ItemLookupCode)"
> >>    ColHidden = False
> >>    ColNotDisplayable = False
> >>    FilterDisabled = False
> >>    ColWidth = 1800
> >>    GroupMethod = groupmethodNone
> >>    ColFormat = ""
> >> End Column
> >>
> >> Begin Column
> >>    FieldName = "ItemDescription"
> >>    DrillDownFieldName = ""
> >>    DrillDownReportName = ""
> >>    Title = "Description"
0
AkberAlwani (916)
3/7/2007 4:33:08 AM
Reply:

Similar Artilces:

"Cannot start outlook. Could not open the item" appears on start.
When I try to open outlook I get the messeage "Cannot open microsoft outlook. Could not find the item." I have tried uninstalling and reinstalling. I've never had this problem before and don't know what to do. Can someone help? Janetto <Janetto@discussions.microsoft.com> wrote: > When I try to open outlook I get the messeage "Cannot open microsoft > outlook. Could not find the item." I have tried uninstalling and > reinstalling. I've never had this problem before and don't know what > to do. Can someone help? Have you created a...

serialized items and quantity key
We upgraded to RMS from Quicksell 2000. We are selling all serialized items, mostly monthly bus passes. In Quicksell we used to be able to enter a quantity of passes at one time, for instance, passes 150-58, and the database would accept that. So far we have not figured out a way to use any kind of a quantity key in RMS. This is a critical capability for us due to orders of up to 200 passes at one time from one custumer. Any suggestions?? Open the Item Properties page for a Serialized Item. Go to the Serial Tab Click the Add button In the section at the bottom, Enter the number of ...

Edit List Item in Access 2007
I have been adding the new values into item list for the past few days, but when I continue to do so today, all the values are keyed into the list but not able to save in the list after clicking 'OK'. Any reason for this sudden change? Appreciate your kind response... Thanks & regards, Lawrence Just an idea When you say > I have been adding the new values into item list for the past few days this sounds like you should not be using a list - are you adding zillions on items??. You could change it to a form/datasheet view and add controls to select items. O...

WHY select the first item didn't receive OnPaint in LISTCTRL!
hello everyone, I write a custom listctrl inherit from the CListCtrl( MFC ). I don't use CUSTOMDRAW and OWNDRAW, and rewrite the OnPaint fucntion. The OnPaint function like this: void CListCtrlST::OnPaint() { CPaintDC dc(this); // device context for painting ///////////////////////////////////////////////// CRect rtList; GetClientRect( &rtList ); CDC* pDC = &dc; CMemDC memDC( pDC, &rtList ); // double buffer..... memDC.SetBkMode( TRANSPARENT ); // don't use the system paint, because it's too slow... // if you resize the listctrl...

Corrupted "deleted Item" folder in microsoft outlook 2000
Hi all, I have this spam mail in my deleted item folder which i am not able to delete it away. When i tried to delete it, open it, move it to other folder etc ... outlook 2000 will have an error and will close down and i have to restart it. I tried lots of methods suggested by some nice people in here but stil it doesnt work. Is there any way or how can i have a whole new "deleted item" folder without losing my other folders and emails as well ?? Pls help.... thanksss Yes, per personal experience. Make a new PST, even customize the name of it for yourself. Make it the def...

RE: How do I get my new dialog box to invoke when I press New Menu Item
Hi All, 1. Machine and OS specifications I have Windows XP running Office XP Standard Edition. These software packages are installed on my dell Inspiron laptop. I have 128 MB RAM with a 40 GB HardDrive. 2. Problem In excel, when I pressed the New menu item, a dialog box would appear displaying all of the known templates. Now, only a new worksheet appears. I would like for the dialog to appear again. Can someone tell me how to get the dialog box back displaying all of my templates? d, The default New button has always generated a new workbook, no dialog box. There's ano...

attachments to calendar item scheduled by someone else
How does one add information/attachments to a calendar item scheduled by someone else so that the information/attachments are not lost when the meeting is updated by the organizer? Thanks, Barb ...

Freezing panes and the top of the screen
I'm writing a VBA Macro that will move the first row of the selected range to row 4 and scroll the other rows and could use a tip ... Now, I have a worksheet where the first three rows are frozen ... I'd to attach two buttons that should work like named anchor tags work in HTML ... When I click on the first button the row numbers should look like 1 2 3 100 And when I click on the other button the row numbers should look like 1 2 3 165 The numbers 100 and 165 correspond to the first row of a named rang - but a solution referencing row numbers works great. Any suggestions? Tha...

1 item need to be tax inclusive
I have a customer that wants to sell CDs for $13.00 even, including the tax. However because the taxation is setup for be tax exclusive and the tax percentage being 9.75% we cannot get the CD to come up exactly $13.00. We either get $13.01 or $12.99. Any hints? what if you set the price to $11.84 and the tax to 9.797% "Phil V" wrote: > I have a customer that wants to sell CDs for $13.00 even, including the tax. > However because the taxation is setup for be tax exclusive and the tax > percentage being 9.75% we cannot get the CD to come up exactly $13.00. ...

Line items in an Invoice, disappear
Hi, Using SOP, some times the line items in an Invoice, which has been transfered from on order, just disappear. I tried doing the check links, but the line items do not come back, except that the totals for the invoices are set back to zero. any suggestions? please advice Sajid Saeed ...

English and Chinese in the Item Description
Requirement: The client is planning to deploy GP, howver the following is the requirement: When they set up inventory items we need to be able to use one of the Item Description fields to list the Chinese description of the item. My goal was to have both English and Chinese in the Item Description and Short Name fields and then modify any reports to list both the Description and Short Name fields. I tested by using English in the description field and attempting to type traditional Chinese fonts in the Short Description field. GP does not display the Chinese fonts in the Short Name fi...

When I send emails, they aren't appearing in the sent items folde.
Kerrie <Kerrie@discussions.microsoft.com> wrote: Have you enabled the option to save sent messages in the Sent Items folder? -- Brian Tillman Have you checked the view in your Sent Items folder? Make sure it's not set to Unread Messages. Patricia Cardoza Outlook MVP Author - Special Edition Using Microsoft Office Outlook 2003 Lead Author - Access 2003 VBA Programmer's Reference Author - Absolute Beginner's Guide to Microsoft OneNote 2003 http://blogs.officezealot.com/cardoza > > > ...

Item
Item needs to have more customer fields. Some countries require both an Inc and Ex Cost of each item. Ib Ivan, What are Inc and Ex costs and are you asking for more custom fields or do you really mean customer fields? -- * "Ivan Brebner" <ibrebner@premiumretail.com.au> wrote in message news:Oo9hLB4%23FHA.2524@TK2MSFTNGP10.phx.gbl... Item needs to have more customer fields. Some countries require both an Inc and Ex Cost of each item. Ib In places like Australia retailers prefer to see the cost of an item including tax as well as Excluding. So that quoting ite...

Automatically delete old items off the server?
Is there any way we can delete old items from the server itself? Sure, we can use policies on Outlook, but many of our users are just using OWA and we want their old email to get deleted after 120 days. Any way this can be done? TIA! / Per Use Recipient Policy with Mailbox Manager settings. Recommend using this in "generate report only" mode till you're confident the policy has picked up the right users, is doing/will do what you want it to do, and users are informed about this (so they have time to backup/archive their stuff). -- Bharat Suneja MVP - Exchange www.zen...

Accurate Gross Margin Tracking on Variable Cost Items
GP 8.0 We custom order products. We use a fixed SKU for the product because it is custom ordered in different sizes and colors. Each order has a different cost. How can we set it up so that we have accurate gross margin information on the sale? Basically we would like to type in the cost on the sales order so we know exactly what the GM is. We enter the cost in the purchase order (which we generate via SOP to POP), but it appears that the cost isn't reflected until the next Sales Order so our GM tracking on a per order basis is completely off. Thanks, Jason ...

Problem Report-Inventory Item Transaction Drillback
We just updated to V9, from 7.5 with project PO's. We can not drill back from Inventory Item Transaction to the Receiving transactions (POP type) I can only drill back to inventory transactions I have posted this about 2 or 3 weeks ago with no response, where is the Microsoft Business Solutions Support? -- Doug ...

Updating the item.picturename column
Hi all ~ I'm trying to update the picturename column: UPDATE ITEM SET ITEM.PictureName=IMAGES$.PICTURE --ITEM.ExtendedDescription=SHEET1$.Ext_Discription FROM DBO.IMAGES$,ITEM WHERE ITEM.ITEMLOOKUPCODE=IMAGES$.UPC I recevied the folowing error: Server: Msg 8114, Level 16, State 5, Line 1 Error converting data type nvarchar to float. But both columns, ITEM.PictureName=IMAGES$.PICTURE, are nvarchar data types. Any ideas? hi Jerry, if you think that you are tyring to update the picture i.e. BMP or JPG then it is not correct you need to update the path of the picture or file name of t...

quantity on hand needs to be included in item movement report
i use item movement as for buying info- qty on hand seems not included in the allowed fields. this would be very helpfull ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=14...

"**One or more line items contain warnings or error"
Hi! I have a VAR who has a concern regarding the "generic"-ness of this error:"**One or more line items contain warnings or error" on any Edit List in the Distributions Series. If there is a way to make this more specific, it would be great. It's rather weird why the system is not capable of erroring out in detail when there are fields that contain error values. My VAR’s concern is that why doesn’t GP give a very detailed error message considering that it already has a repository of errors? We have the table that contains the error code and somewhere in the...

Cant open item (routed mail)
-- We have experienced issues with 6 users on our exchange 2003 system (clients are 2002 sp2) where they cannot open some items from their inbox. Outlook returns a "Can't open this item" error message. This error affects 6 of 100 users on the exchange and ONLY emails where: A) Email is forwarded (doesn’t affect new emails) AND B) email has routed from another domain to our domain using the deliver to alternative user option. This error has only begun since the mailboxes were migrated from Exchange 5.5 using ExMerge Can anyone assist? Michelle ...

Hot to prevent copy/paste of items in public folder
We have an application that uses Exchange public folders. I need to prevent users from using copy/paste (edit|copy, edit|paste, ctrl+c, ctrl+v) on the messages in these folders. They are doing this from the folder view. We a custom form associated with each of these folders. There is code the form which prevents in-cell editting by detecting when an item_write event fires when there was no previous item_read event. Unfortunately these form events do not fire when users copy/paste items. Is there any way to prevent the copy/paste? Thanks, Tony ...

Is there a full list of messageclasses for Outlook items?
I am writing a peice of code in c# which loads a msg file and depending on its messageclass I load it into the appropriate Outlook item and perform some operations (like SaveAs) on it. Is there a full list of message classes that I can refer to? This is what I have at the moment and I would like to get a full List of messageclasses for completeness: switch (messageClass) { case "IPM.Appointment": //AppointmentItem { AppointmentItem myAppointment = (AppointmentItem)oMailItem; myAppointment.SaveAs(strTxtFilename, MailFileType); myAppointment = null; break; } case "IPM.Co...

Account Shows Items to review not showing in register
Hello, thanks for the help in advance!! Using Money 2004 TRIAL. Was going to switch from quicken to MS because it seemed a lot easier to master. Both when I DOWNLOAD an an account file from my Credit Card company and import and also when I use the internet update to update my checking account, the account summary on the left of the register shows there are items to review but nothing shows in the register. I have two checking accounts at the same bank and the other seems to work fine so it should reason the problem is not on the banks end... I have tried clearing my temp files and...

cannot forward new items to an external email address
hi there i created a public folder and in the "Moderated Floder" option i used "forward new items" to an external email address (instead of the internal email address for the company), e.g., gmail or yahoo. However, i never received any messages. Any suggestion will be greatly appreciated! On 6 Dec 2006 14:16:22 -0800, lei.guang@gmail.com wrote: >hi there > i created a public folder and in the "Moderated Floder" option i used >"forward new items" to an external email address (instead of the >internal email address for the company), e....

Item Find Field
Please add "Supplier Reorder Number" as searchable field in the Item Find window. M$, Making the Item Find window customizable would be a better all around solution. i.e. Choosing which fields are returned, choosing which fields to add to the searchable fields and automatically bringing up the find window and searching for possible matches when the item is not found at the transaction screen. "Ed Balda" <EdBalda@discussions.microsoft.com> wrote in message news:4BE4C456-F6E9-4D18-9457-EFE424D7986B@microsoft.com... > Please add "Supplier Reorder Number&...