Hello,

I am creating a report from Metadata and it will only return 700 rows in my production enviroment. When I have a BY FIELD on two columns i only get back 700 rows. If I do a BY field on only the shipper Code I get 1500 rows back.

When running this same code in our test environment I get the 1500 rows back when I have the BY Field on the two columns.

PRODUCTION:

TABLE FILE LOADREPORT
BY LOADREPORT.LOADREPORT.SHIPPERCODE
BY LOADREPORT.LOADREPORT.NAME
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=6.000000,
$
ENDSTYLE
END


TEST ENVIRONMENT:

TABLE FILE TESTLOADREPORT
BY TESTLOADREPORT.TESTLOADREPORT.SHIPPERCODE
BY TESTLOADREPORT.TESTLOADREPORT.NAME
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=6.000000,
$
ENDSTYLE
END

This message has been edited. Last edited by: <Kathryn Henning>,

What version are you on? Is test and prod the same version. Is test pointing to production data?

Version 7703

test and production are the same version. I'm talking our database is either production or test.

I have my test pointing to our test database. However the test database is replicated so the data is the same as in production.

Thank you

This is taken care of.

in our database on the production side one of the shipper names had a `(tic) instead of a '(apostrophe)

Webfocus didn't error out it just wasn't displaying all the data.