logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
epf  
#1 Posted : Wednesday, June 26, 2019 8:51:09 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 676
Switzerland

Thanks: 12 times
Was thanked: 116 time(s) in 113 post(s)
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

CPBOURG  
#2 Posted : Wednesday, August 21, 2019 9:41:12 AM(UTC)
CPBOURG

Rank: Advanced Member

Groups: Registered
Joined: 9/13/2018(UTC)
Posts: 33
Belgium
Location: Ottignies

Was thanked: 1 time(s) in 1 post(s)
Hello,

Nice to see a new version came out.

Is there an upgrade procedure to follow when our current version is 4.1 ?

Thanks
Thomas
epf  
#3 Posted : Wednesday, August 21, 2019 12:20:44 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 676
Switzerland

Thanks: 12 times
Was thanked: 116 time(s) in 113 post(s)
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.
CPBOURG  
#4 Posted : Wednesday, August 21, 2019 1:27:41 PM(UTC)
CPBOURG

Rank: Advanced Member

Groups: Registered
Joined: 9/13/2018(UTC)
Posts: 33
Belgium
Location: Ottignies

Was thanked: 1 time(s) in 1 post(s)
Just proceeded to the upgrade from 4.1 32b to 5.0 32b.

Had a few hickups after install, republished to IIS, restarted the IIS and everything went fine.

Ran a bunch of tests on specific reports, everything looks good so far. I'll port to our production environement.

Thanks for this!
CPBOURG  
#5 Posted : Wednesday, August 21, 2019 2:02:56 PM(UTC)
CPBOURG

Rank: Advanced Member

Groups: Registered
Joined: 9/13/2018(UTC)
Posts: 33
Belgium
Location: Ottignies

Was thanked: 1 time(s) in 1 post(s)
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
epf  
#6 Posted : Wednesday, August 21, 2019 6:15:07 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 676
Switzerland

Thanks: 12 times
Was thanked: 116 time(s) in 113 post(s)
the report 52 works fine, you can test it on the live demo at https://sealreport.org/demo
can you explain how you got this weird WHERE clause ?
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.