Crystal Reports

[Guest]

Does any know how I can limit my data set in Crystal reports to any records that equal a specific value?

Thanks in advance!

 

[David Costelloe]

Would not the query do this for you?
If so a sample is here:
http://www.andreavb.com/forum/news/viewtopic.php?TopicID=326

I would create a stored proc and use a where clause.

Hope this helps

Does any know how I can limit my data set in Crystal reports to any

records that equal a specific value?

 

[Guest]

I agree with David just passing the data you required for the report is the preferred method. However, if you can't limit the data you send to the report, you can create a selection forumla in your report template using a parameter field and then set the parameter field via code to limit the report output output.

Check out the Crystal Reports documenation about selection formulas and parameter fields.