Report Builder problems

[Anonymous]

Hello,

I'm trying the new report builder tool, and I get a screen saying it's an evaluation version:
"About EMS QueryBuilder" ... "Evaluation version"

Also when I try to load a custom report, it gives the error "Invalid token '(' at position 16 of line 1.
Here's the affected report (it gives me the number of installations by month):

SELECT     TOP (100) PERCENT YEAR(DateAssigned) AS Year, MONTH(DateAssigned) AS Month, COUNT(*) AS Instalations
FROM         dbo.tblCustInventoryNew
GROUP BY MONTH(DateAssigned), YEAR(DateAssigned)
ORDER BY Year, Month

Thanks, and congrats for the great work! 😉

[Anonymous]

Thanks! The trial is now gone.
Regarding the report issue, if I remove that I also have to remove the sort, right? I need it sorted, so I'll leave it that way for now 😉

Keep up the great work!

[Hemoco]

BullGates wrote:
Thanks! The trial is now gone.
Regarding the report issue, if I remove that I also have to remove the sort, right? I need it sorted, so I'll leave it that way for now 😉

Keep up the great work!

You can keep the sort without problems

[Hemoco]

Download the just uploaded new version to get rid of the "trial" version.

In your query remove "TOP (100) PERCENT" and it should work.

[Anonymous]

No, I've downloaded it yesterday.

[Hemoco]

Did you downloaded the beta of last week?