I'm sure this is an easy one but . . .

I want to turn off (or hide) the entire title row for a grid. How is this accomplished? Thanks!

A

Hope this is what you are looking.

TABLE FILE CAR
PRINT CAR AS ''
BODYTYPE AS ''
BY COUNTRY
END
-EXIT

Kamesh

This did the trick. Thanks!

A

I have a excel report in which displays rows and subhead when detailed view is selected by the user. But now when user is unchecking the detailed view, I wish to print the column title and subhead alone and the row contents has to be hidden. Is there any way to achieve this thro webfocus query language in dev studio? HIDING ROWS CONTENT AND DISPLAYING ONLY SUBHEAD AND COLUMN TITLE? Any Idea?

If you impose an impossible condition (like "WHERE COUNTRY NE COUNTRY;"),
and SET EMPTYREPORT = ON (or ANSI),
you will get columns titles but no rows of data.

But I am not sure what you mean by printing the "subhead". There will be no sort-break SUBHEAD if there are no rows of data in the output.

Detail report:

TABLE FILE CAR
SUM
SALES
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
"COUNTRY: <COUNTRY"
END

Subheading-only report:

TABLE FILE CAR
SUM
SALES NOPRINT
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
"COUNTRY: <COUNTRY"
END