Skip to main content

Notifications

Microsoft Dynamics RMS forum

List of RMS Report "FieldNames"

Posted on by 1,565

I'm wondering if there is a list of all the different "FieldName"s for creating Custom Reports and/or adding additional filters to existing reports?

Specifically, we're looking for a list of Item attributes to filter by.

For example, HQ does not have a filter in any of it's report for whether an item is a Web Item or not so I added:


Begin Column
   FieldName = "Item.WebItem"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   Title = "Web Item"
   VBDataType = vbBoolean
   Formula = ""
   ColHidden = True
   ColNotDisplayable = False
   FilterDisabled = False
   ColWidth = 1000
   GroupMethod = groupmethodNone
   ColFormat = ""
   ColAlignment = flexAlignLeftCenter
End Column

to one of our reports


Sometimes, it takes a lot of trial and error to come up with the right naming (item.WebItem) and I'm thinking a lot of you guys would just have a list including the different options

We've got the customization guide and it's been a great resource to learn the thought behind this stuff but it's incomplete.


Thanks,
Devon

*This post is locked for comments

  • Alwani Profile Picture
    Alwani 710 on at
    RE: List of RMS Report "FieldNames"

    i agree that Customization guide is just an intial stage for us to proceed with customziation. by the time we start we learn more!! as suggested you can use "select * from tabl" or you can also use sp_help "tablename' this help you to get the information.

    But how do we know which field link to what, one way I use is sql profiler tool this is helpfull when I do transaction I monitor what is happening and by profiler I get the correct field name. Again it require some technical skills. You can always ask question related to your queires and we are here to help you solve your issue. Best of luck.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: List of RMS Report "FieldNames"

    Hi Devon,

    If you run a Query in either HQ or Store Operation Administrator on item you will see the column headers and these are the names you are looking for.  (Select * from item) will produce everything in the items table.  The column Headers are the right Naming - Microsoft's WYSIWYG (What You Yee Is What You Get)

    Hope this helps you

    Shawn

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: List of RMS Report "FieldNames"

    Hi Devon -

    Another option to find out tables and views in your database,

    sp_tables

    Or to look at columns in a table, including data about the data like data types, ie in the item table

    sp_columns item

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: List of RMS Report "FieldNames"

    Thank you.  Is this a new program I have to get or can be ran within RMS?  I am new to SQL, so my knowledge is very limited.  Thank you for your respose!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: List of RMS Report "FieldNames"

    Run SQL Queries.    I prefer using SQL Management Studio

    1.  Show all tables for a database

    use databasename

    select *

    from sys.tables;

    2.  Show all column/rows for a table

    use databasename

    select *

    from tablename;

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: List of RMS Report "FieldNames"

    Did you ever find an answer?  I am looking for the same.  Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans