Page 1 of 1

A way to use where clause in Report

Posted: Sun Jan 27, 2013 12:07 pm
by 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..

Re: A way to use where clause in Report

Posted: Mon Jan 28, 2013 8:55 am
by 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.

Re: A way to use where clause in Report

Posted: Fri Nov 01, 2013 3:46 am
by val_pilats
Hi! Still no way to use dynamic values (tag value) in WHERE clause?