Filtering Out Data

[Former Member]

<p>Hi:</p><p>With reference to a project which shows students and exams.</p><p>I would like to be able to pull out just a single report whereby <strong>only 1</strong> student&#39;s results and exam answers get displayed. How do I go about doing this?</p><p>I read from another thread that I could just put in all the information regarding students and exams and later use a custom parameter/parameters during runtime to get my intended result.</p><p>Is a further elaboration or clarification possible to best execute this scenario?</p><p>Orbid</p>

[SJohnson]

Hi,

In the case you describe you will likely want to use a parameter field to limit the number of students returned in the main report. The in-product documentation which ships with CR4E provides some detailed documentation around how to create Parameter Fields and use them in your Record Selection. To find the appropriate section open your Eclipse Help. Expand the book titled <span style="font-weight: bold">Crystal</span>Reports for Eclipse Designer Guide.This book will contain a chapter titled âu20ACu0153<span style="font-weight: bold">Parameter Fieldsâu20AC</span>. Expand this and follow the steps outlined under the âu20ACu0153<span style="font-weight: bold">Creating a parameter fieldâu20AC </span>chapter. The final step of this chapter links to the next page which explains how to use the Parameter Field in the Selection Formula.

Additionally, the <span style="font-weight: bold">Customer Profile Report.rpt</span> sample report which ships with CR4E also demonstrates how to use a parameter as a filter.

Regards,
Sean Johnson (CR4E Product Manager)

[Former Member]

<p>Hi:</p><p>I think Orbid is looking for an enhancement in SQL Scrapbook to include Parameters. Even though The DataView of SQL ScrapBook says "Parameters" and their values can be seen there but there was no help provided on how to incorporate the usage of Parameters which will help and solve lot of issues while using customized Queries.</p><p>Thanks & Regards, </p><p>Saba.</p>

[SJohnson]

<p>Currently the SQLScrapbook page which comes with Eclipse does not appear to support parameters in the SQL query. I recently wrote a reply to another post which included the required code to add a parameterized SQL query without using the SQL Scrapbook page. You can find the post here:</p><p><u><strong><a href="/node/518/299#comment-299">http://diamond.businessobjects.com/node/518/299#comment-299 </a></strong></u> </p><p>Regards,<br />Sean Johnson (CR4E Product Manager) </p>