1. Home
  2. Point-Of-Sale Software
  3. RMS Reports

RMS Reports

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

Reply to
Luminox
Loading thread data ...

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

Reply to
Glenn Adams [MVP - Retail Mgmt

Glenn,

Sent you e-mail regarding this ...

Scott

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

Reply to
Luminox

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.