A 5.0 has been published on Git Hub.

The 5.0 offers a lot of new features: Dashboards, KPI, Input Values, Dynamic Display for enumerated lists, etc..

Check also the new documentation at sealreport.org.


Feedbacks are welcomed !

Edited by user Wednesday, June 26, 2019 8:51:46 AM(UTC)  | Reason: Not specified

Normally your 4.1 report should work with the 5.0, however you have to check them anyway (use at least Check Report Execution helper menu of the server manager).
Always check your custom template if you have made any modifications.

Okay, found a bug I guess in the new version.

If you take your sample report 52-User Input - Select columns to display.

In your sample report, there is only one restriction. If you execute the report, you will get an SQL syntax error :

---

16:00:07 Error in model 'model': Unexpected error when executing the following SQL statement:
SELECT
Products.CategoryID AS C0,
Sum([Order Details].Quantity) AS C1,
Sum((1-Discount)*[Order Details].Quantity*[Order Details].UnitPrice) AS C2,
Products.ProductID AS C3,
Products.ProductID AS C4,
Sum([Order Details].Discount*[Order Details].Quantity*[Order Details].UnitPrice) AS C5
FROM
(Products INNER JOIN [Order Details]
ON Products.ProductID = [Order Details].ProductID)
WHERE (Product ID,Product Name,Quantity,Amount,Discount)
GROUP BY Products.CategoryID,Products.ProductID
ORDER BY Products.CategoryID ASC,Products.ProductID ASC,Sum([Order Details].Quantity) ASC,Sum((1-Discount)*[Order Details].Quantity*[Order Details].UnitPrice) ASC,Sum([Order Details].Discount*[Order Details].Quantity*[Order Details].UnitPrice) ASC


Error detail:
Syntax error (missing operator) in query expression '(Product ID,Product Name,Quantity,Amount,Discount)'.

---

Please advice how to fix.
Thomas

hi, just took the version distributed with the new version, without applying any change...

OK, my samples folder is messed up because i have now a mix of old versions and new versions.

In the old version of that report, and the name was then 52-User input - Select columns to display.srex, the enumerated list of columns was defined as a restriction in the report, but not anymore, as now it is as Report Input Values.