|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
reportaddcondition Error
Posted: 23 Jul 10 4:03 AM
|
hello,
I am using SalesLogix slx7.2 with oledb connection
There is a problem when specifying multiple condition.
I have to use multiple condition based on a View
application.BasicFunctions.ReportClearConditio ns
application.BasicFunctions.ReportAddCondition "Account:Status", "=","'" & localStatus & "'", "String",""
application.BasicFunctions.ReportAddCondition "Account:Type", "=","'" & localAccType & "'", "String","AND" application.BasicFunctions.ReportAddCondition "Account:AccountManagerID", "=","'" & localUser & "'", "String","AND"
but the records not coming as given(or chosen) by above conditions. if i put single condition than it is coming but when i am
adding more than one condition it is not coming
and at the same time when i used these CONDITION in crystal report
report expert and then run the sql query(using Show sql Query) in analyzer then it is coming
from my point of thinking error is in multiple condition because in single condition it is working
any suggestion or help.......
with regds.
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|