Condensing and Expanding reports

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...

Reply to
Jack T
Loading thread data ...

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

Reply to
Jeff

Reply to
Jack T

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:

Reply to
Rob

Reply to
Jack T

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.