RMS Reports

Mar 21, 2007 2 Replies
L

I've begun to change some of the RMS reports to better suit the needs of my company. I understand that there is a GROUPMETHODCOUNT - which would give me a COUNT of records included in the report. But, I can't seem to make it work. Any suggestions?



Begin Column FieldName = "Message" DrillDownFieldName = "" DrillDownReportName = "" Title = "Message" VBDataType = vbString Formula = "CASE WHEN ITEM.LASTUPDATED > ITEM.DATECREATED THEN 'Item Updated' WHEN ITEM.LASTUPDATED < ITEM.DATECREATED OR ITEM.LASTUPDATED ITEM.DATECREATED THEN 'New Item' END" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2000 GroupMethod = groupmethodCount End Column



Scott


Vote
Twitter Facebook LinkedIn
G

What are you trying to get and what is the actual result?

IIRC, String type columns (vbString) do not group, regardless of the group type setting. You may be able to resolve this by creating two numeric columns ("New" and "Old") and giving the rows values of 1 or 0 based on your criteria. In that case, you would use SUM instead of COUNT.

Glenn Adams Tiber Creek C> I've begun to change some of the RMS reports to better suit the needs of my

Vote
Twitter Facebook LinkedIn
L

Glenn,

Sent you e-mail regarding this ...

Scott

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required