Condensing and Expanding reports


J

Jack T

Does anyone know how I can set a item report (like the item value report) to
automatically condense (+ )or (-) the items in a department automatically?
RMS defaults to expand the items in a given department and we would like to
condense every time rather than clicking the (-) button on the report each
time. I know there must be a sequel statement that lets me do this but don't
know what it is...
 
Ad

Advertisements

J

Jeff

Jack,

Hopefully someone else will pipe in, but rather than clicking on each (-),
click on the Close all groups icon on the top of the report, the 7th icon or
just press Ctrl+Z

--
*
Does anyone know how I can set a item report (like the item value report) to
automatically condense (+ )or (-) the items in a department automatically?
RMS defaults to expand the items in a given department and we would like to
condense every time rather than clicking the (-) button on the report each
time. I know there must be a sequel statement that lets me do this but
don't
know what it is...
 
J

Jack T

Thanks a bunch! Works like a charm! Still would like to know the sequel
statement if there is one though!
 
R

Rob

Jack,

Unfortunately this is no SQL statement or setting you can set so that the
report is automatically Collapsed. Your only option is to do what Jeff
mentioned or Ctrl + O if you have more that 1 grouped row.

Rob
 
Ad

Advertisements

J

Jack T

Ok, thanks

Rob said:
Jack,

Unfortunately this is no SQL statement or setting you can set so that the
report is automatically Collapsed. Your only option is to do what Jeff
mentioned or Ctrl + O if you have more that 1 grouped row.

Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top