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...
Condensing and Expanding reports
Dec 05, 2005
4 Replies
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
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
"Jack T" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required