Wrox Programmer Forums
|
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 5th, 2005, 02:14 AM
Registered User
 
Join Date: Jun 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Query That Return 0 Rows in Results

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






Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Max function to return single rows. beerOne SQL Language 1 November 6th, 2008 04:52 PM
Edit Query Results in Results Grid druid2112 SQL Server 2005 1 June 28th, 2007 08:49 AM
different results were given for the same query madhusrp SQL Server 2000 2 May 9th, 2006 01:54 AM
Crosstab query with no results edubbelaar Access 0 November 22nd, 2004 06:12 AM
Refresh Query Results Ben Access VBA 2 February 10th, 2004 10:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.