Hi,
I recently have a problem which i can not understand.
I developed Reports using the Reporting Services 2000
with
VB.NET Enviroment and Suddenly I saw that a simple
query which is working fine in Qury Anlyzer, Does not
Work in the Reporting Services (nor in the Developing Enviroment).
The same query return 1893 Rows in the Query Anlyzer and 0 Rows in
the Reporting Services Enviroment.
What Can Be the Problem or the Reason for this ?
Here is the Query I am Using:
"SELECT *
FROM view_ChrNoMDCFull_Archive
WHERE (Source <> 9) AND (DocJobCode8 = '15332004')"
Best Regards
Nimrod Rotner