Old thread, ongoing challenge... Learning MSSQL and building queries. Simple query strings have returned tables such as the following: All vehicles which have received new brake pads All vehicles which have received an alternator All vehicles by fleet number (unit number) All vehicles with recommend...

Well... Using Crystal Reports and Microsoft SQL Server Management Studio I was able to identify the vehicle unit number variable. I used CR to edit one of the pre-made reports in Shopkey (Sublet Detail Report) to include this variable. Printing the report currently displays vehicle unit numbers for ...

Thanks for the reply. I've looked at Bolt-On. It could help with some of the data but we're really looking to use the information in a different way than most shops. After spending a few hours looking at how existing reports are configured I'm wondering if I can even access the data I need. I'm curr...

Because this is a fleet environment we really need to use data differently than a retail shop. So I'm hoping to be able to use Crystal Reports to design and generate my own reports. I have some database experience but it's very obvious that making what I need is going to take more than a few minutes...