Very impressed with Seal reports. I am not a developer but I am trying to hack my way through this.

In sample report 9 Enumerated List Dynamic Display - When I click on [Product Name Search Equals ?] in Restrictions and Aggregate Restrictions of the model I see a definition on the right hand side of the screen.

However, when I do this on mine. I don't see this. I have an Enumerated List With the same details but connected to a different db.


([Category Equals ?]
AND [Product Name Equals ?]
)
OR
[Product Name Search Equals ?]


Also, why this error? I have tried several things to replicate The SQl in the example but can't get it to work.

SELECT DISTINCT
ProdStructureValues.IdentifierValue AS C0,
ProductMaster.ProductDescription AS C1
FROM
(ProdStructureValues INNER JOIN ProductMaster
ON ProductMaster.ProdAreaIdentifier1ID=ProdStructureValues.IdentifierId)
WHERE ([Category Equals ?]
AND [Product Name Equals ?]
)
OR
[Product Name Search Equals ?]
ORDER BY ProdStructureValues.IdentifierValue ASC,ProductMaster.ProductDescription ASC


Syntax error near 'AND' on line 8


Thanks in advance.

Edited by user Monday, August 12, 2019 9:44:12 AM(UTC)  | Reason: Not specified

Thank you very much for your guidance.