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

Notification

Icon
Error

Options
Go to last post Go to first unread
AmbientGuitar  
#1 Posted : Friday, August 9, 2019 3:00:30 PM(UTC)
AmbientGuitar

Rank: Newbie

Groups: Registered
Joined: 7/29/2019(UTC)
Posts: 4
Ireland
Location: Belfats

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

epf  
#2 Posted : Wednesday, August 14, 2019 10:23:05 AM(UTC)
epf

Rank: Administration

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

Thanks: 12 times
Was thanked: 116 time(s) in 113 post(s)
If you do not see the properties updated on the right panel when you click on the restriction, this means that the restriction link is lost...
you cannot used cut/paste in the restriction text, if you want to add a restriction, you MUST Drag and Drop the element from the left tree view.

when you view the SQL generated, you can notice that restriction prompted are replaced by (1=1) which is neutral for the syntax,
if you see things like [Product Name Equals ?] in the SQL generated, the syntax error is obvious for your SQL Database.
AmbientGuitar  
#3 Posted : Wednesday, August 14, 2019 2:23:18 PM(UTC)
AmbientGuitar

Rank: Newbie

Groups: Registered
Joined: 7/29/2019(UTC)
Posts: 4
Ireland
Location: Belfats

Thank you very much for your guidance.
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.