A way to use where clause in Report

[memethemyn]

Hi..

Is there a way to use a where clause in excel when using a database report..

I tried many way even the filtering in option excel but I didn't get a result..

Also I try to import a third party report component into IX but I couldn't.

Please Help me about this issiue..

Mehmet Emin..

[mark.monroe]

You can use a where clause in the Report, but the where can not be dynamic. You can not for example use a tag in the where clause to change what the query is looking for.

This will not work because you are referencing a dynamic variable, SomeTagValue.
Select MyCol from TableName where ID < SomeTagValue.

You can only do:
Select MyCol from TableName where ID < 1000.

[val_pilats]

Hi! Still no way to use dynamic values (tag value) in WHERE clause?