Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 How to filter incoming recordset in Crystal report
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

GoodMorningSky
Junior Member

122 Posts

Posted - 03 October 2003 :  14:06:45  Show Profile
Hi, all.
I'm using SQL Server, and created a stored procedure that gets 4 params and return one recordset. The recordset has 'Status' field whose value is 'O' or 'N'
my Crystal report file use the storedprocedure as data source and it shows all records incoming.

But, I want to show only those record whose Status field with value 'O'.
Is it possible to filtering the incoming recordset like 'WHERE Status = 'O' ' and the report shows only those records?

Please reply how to do it if it's possible or not..
Thank you.

Software Engineer.
MCSD.NET, SCWCD

dayve
Forum Moderator

USA
5820 Posts

Posted - 03 October 2003 :  16:33:25  Show Profile  Visit dayve's Homepage
Edit your Select Expert to filter the records. Select the Status filed from the stored procedure and then choose is equal to and put in your criteria of O.


Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07