List of RMS Report "FieldNames"

(0) Share

Report

Posted on by DEVON LEROUX

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

I have the same question (0)

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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;

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Alwani 710 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Community site session details

List of RMS Report "FieldNames"

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Featured topics

Product updates

Community site session details

List of RMS Report "FieldNames"

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Featured topics

Product updates