Anyone who uses Reynolds and Reynolds ERA DMS software knows that it is full of information. How we access that information and use it for reporting purposes is another story. If you use ERA, you probably know about Query Builder, a tool that enables us to extract data and dump it into an Excel spreadsheet. With that said, does anyone have any good, useful queries that they have built that they'd be willing to share? Personally, I'm always looking for new ways to analyze data in my DMS without having to manually transpose data onto an Excel spreadsheet. The queries can be related to any department - sales, service, parts, body shop, accounting. Thanks.