Using Crystal Reports
You can create Cyrstal Reports that use in-memory data. The main advantage is that the report is always up to date and no publishing to SQL is required. But creating reports are more difficult without having SQL to create custom views.
When creating a new report in CR, choose ADO.NET (XML) as data source and point it to the PtDbDataset.xsd file.