<html xmlns="http://www.w3.org/TR/REC-html40" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word"> <head><meta http-equiv="Content-Type" content="text/html; charset=utf-16le"> </head> <body lang="EN-US" link="blue" style="tab-interval:.5in" vlink="purple"> <p>&nbsp; <div class="WordSection1"> <div id="container"> <div id="mainContent"> <div id="sidebar"> <div id="sidecontainer"> <div id="navcontainer"> <ul type="disc"> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; mso-list:l0 level1 lfo1;tab-stops:list .5in"><span style="font-family:trebuchet ms,helvetica,sans-serif;"><a href="../../index.html"><span style="color:#000080;">Home</span></a></span></li> </ul> <ul type="disc"> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; mso-list:l0 level1 lfo1;tab-stops:list .5in"><span style="color:#000080;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><a href="../../Services-Crystal-Clear-Solution/Services-Crystal-Clear-Solution.html">Services</a></span><o:p></o:p></span></li> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; mso-list:l0 level1 lfo1;tab-stops:list .5in"><span style="color:#000080;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><a href="../../Crystal-Reports-Tips/Crystal-Reports-Tips.html">Tips And Tricks</a></span><o:p></o:p></span></li> </ul> <ul type="disc"> <li> <ul type="circle"> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l0 level2 lfo1;tab-stops:list 1.0in"><span style="color:#000080;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><a href="../../Crystal-Reports-Tips/Beginner-Tips/Beginner-Tips-1.html">Beginner</a></span><o:p></o:p></span></li> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt: auto;mso-list:l0 level2 lfo1;tab-stops:list 1.0in"><span style="color:#000080;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><a id="current" name="current"></a><a href="Intermediate-Crystal-Reports-Tips-1.html">Intermediate</a></span><o:p></o:p></span></li> </ul> </li> </ul> <ul type="disc"> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; mso-list:l0 level1 lfo1;tab-stops:list .5in"><span style="color:#000080;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><a href="../../Contact-Crystal-Clear-Solution/contact.php">Contact</a></span></span></li> <li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; mso-list:l0 level1 lfo1;tab-stops:list .5in"><span style="color:#000080;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><a href="../../Sample-Reports/Sample-Reports.html">Sample Reports</a></span><o:p></o:p></span></li> </ul> </div> <div id="side_plus"></div> </div> </div> <div id="sidebar2"> <div id="sidebar2Content"> <p align="center" style="margin-bottom:12.0pt;text-align:center"></p> </div> </div> <div id="content"> <div id="content_text"> <div align="center" class="MsoNormal" style="text-align:center"> <hr align="center" size="2" width="100%" /></div> <p class="MsoNormal"><span style="mso-fareast-font-family:&quot;Times New Roman&quot;; mso-no-proof:yes"><img alt="crystal clear solution llc" border="0" height="106" id="_x0000_i1032" src="../../files/ccs-blue-new-reisling-7-copy-2.jpg" width="236" /></span><span style="mso-fareast-font-family: &quot;Times New Roman&quot;"><o:p></o:p></span></p> <div align="center" class="MsoNormal" style="text-align:center"> <hr align="center" size="2" width="100%" /></div> <p class="MsoNormal"><br /> <br /> <span style="color:#FF8C00;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><span style="font-size: 18pt;">Tips &amp; Tricks</span> </span></span><br /> <br /> <span style="color:#FFA500;"><strong><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><span style="font-size: 10pt;">Making a Multipage Report Header Show Page Headers or Footers on Every Page</span><br /> <span style="font-size: 10pt;">Level: Intermediate.</span></span></strong></span><br /> <br /> <span style="color:#000080;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><span style="font-size: 10pt;">To make a multipage Report Header show Page Headers or Footers on every page, you must create a fake Report Header which prints in place of the real Report Header.<br /> <br /> Use the following steps to create a fake Report Header.<br /> <br /> 1. Create a new formula called <span class="SpellE">ReportHeaderGroup</span>: @<span class="SpellE">ReportHeaderGroup</span> <span class="SpellE">WhileReadingRecords</span>; 0<br /> 2. Create a Group 1 based on this formula.<br /> 3. Create a <span class="SpellE">subreport</span> and call it <span class="SpellE">ReportHeader</span>.<br /> 4. Insert the <span class="SpellE">subreport</span> into Group Header 1.<br /> 5. Copy everything from the main report&#39;s Report Header into the Report Header of the <span class="SpellE">subreport</span>, <span class="GramE">then</span> suppress everything in the <span class="SpellE">subreport</span> except the Report Header section you want.<br /> 6. In the main report, suppress the current Report Headers, and the new Group Footer 1.<br /> <br /> The <span class="SpellE">subreport</span> is the new Report Header and shows Page Headers and Footers for all pages. (The size of the <span class="SpellE">subreport</span> in the main report&#39;s group header determines the space available in the <span class="SpellE">subreport</span> for placing report objects. To check the space available, open the <span class="SpellE">subreport</span> after resizing it in the main report. The <span class="SpellE">unshaded</span> area will be the only area visible in the main report. Ensure you have room in the <span class="SpellE">subreport</span> to place your objects for the fake Report Header.) </span></span></span><span style="mso-fareast-font-family:&quot;Times New Roman&quot;"><o:p></o:p></span></p> <div align="center" class="MsoNormal" style="text-align:center"> <hr align="center" size="2" width="100%" /></div> <p class="MsoNormal"><br /> <span style="color:#FF8C00;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><span style="font-size: 10pt;"><span class="GramE">Creating Parameters in Crystal Reports<br /> Level: Intermediate.</span></span></span></span><br /> <br /> <span style="color:#000080;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><span style="font-size: 10pt;">Need to allow other users to select records without <span class="SpellE">alllowing</span> them into your report design?<br /> Parameters are a quick and easy solution.<br /> To insert a parameter for a contact name, which will be a string value, just perform the following steps:<br /> <br /> 1. Select Insert/Field Object from the Main Menu.<br /> 2. Click on Parameter Fields.<br /> 3. Right click and choose New.<br /> 4. Type in &quot;Contact Name&quot; for your parameter name field.<br /> 5. Type in &quot;Please Enter Contact&#39;s Name&quot; for your prompting text.<br /> 6. Choose the String from the Value type Dropdown Menu.<br /> 7. Press <span class="GramE">Okay,</span> and you will be returned to the Field Explorer Tab.<br /> 8. To add your new parameter to your report, select it from the Field Explorer Tab and drag it into your page header.<br /> 9. Now you have created a parameter, read the next section to learn how to incorporate your <span class="SpellE">paramter</span> into the Select Expert. </span></span></span><span style="mso-fareast-font-family:&quot;Times New Roman&quot;"><o:p></o:p></span></p> <div align="center" class="MsoNormal" style="text-align:center"> <hr align="center" size="2" width="100%" /></div> <p class="MsoNormal"><br /> <br /> <br /> <span style="color:#000080;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><span class="GramE"><span style="font-size: 10pt;">Incorporating Parameters into the Select Expert in Crystal Reports</span><br /> <span style="font-size: 10pt;">Level: Intermediate.</span></span><br /> <br /> <span style="font-size: 10pt;">Once you have created a parameter field, you need to perform a few additional steps if you want the parameter to modify the report selection criteria based on the user&#39;s input.<br /> Let&#39;s assume you created the parameter field {<span class="GramE">?Contact</span> Name} above.<br /> Let&#39;s also assume the table that contains this field is called &quot;Contacts&quot; and the field is called &quot;Name&quot;.<br /> You can change these based on your own data.<br /> <br /> 1. Select Report/Edit Selection Formula/Record... from the Main Menu.<br /> 2. Type in the following: {<span class="SpellE">Contacts.Name</span><span class="GramE">}=</span>{?Contact Name}<br /> 3. Save and Close your formula editor.<br /> 4. Now press the refresh button to see your parameter working. </span></span></span><span style="mso-fareast-font-family:&quot;Times New Roman&quot;"><o:p></o:p></span></p> <div align="center" class="MsoNormal" style="text-align:center"> <hr align="center" size="2" width="100%" /></div> <p class="MsoNormal" style="margin-bottom:12.0pt"><br /> <strong><span style="color:#FFA500;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><span style="font-size: 10pt;"><span class="GramE">Setting Parameter Default Values in Crystal Reports<br /> Level: Intermediate.</span></span></span></span></strong><br /> <br /> <span style="color:#000080;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;"><span style="font-size: 10pt;">Parameters are handy, but it helps to give the user some values to select from.<br /> In this case, we will use the table &quot;Contacts&quot; and the field &quot;Name&quot;.<br /> Follow the steps below to set your default values for the parameter field {<span class="GramE">?Contact</span> Name}:<br /> <br /> 1. Select Insert/Field Object from the Main Menu.<br /> 2. Click on the Parameter Field {<span class="GramE">?Contact</span> Name} in the Field Explorer.<br /> 3. Right click and choose Edit.<br /> 4. Press the Set Default Values Button.<br /> 5. Choose Contacts from the Browse Table Dropdown.<br /> 6. Choose Name from the Browse Field Dropdown.<br /> 7. You can add all values from the selected field by pressing the double right arrow (&gt;&gt;), or choose the values individually. You may also type in any values you would like to display.<br /> 8. Press Okay <span class="GramE">twice,</span> and you will be returned to the Field Explorer.<br /> 9. Now refresh your report, to see the default values which you have just added to your parameter. (Note: upgrade to XI for dynamic parameters.) </span></span></span><span style="mso-fareast-font-family:&quot;Times New Roman&quot;"><o:p></o:p></span></p> <p align="center" style="text-align:center"><o:p><span style="color:#000080;"><span style="font-family: trebuchet\ ms, helvetica, sans-serif;">&nbsp;</span></span></o:p></p> <div align="center" class="MsoNormal" style="text-align:center"> <hr align="center" size="2" width="100%" /></div> <p class="MsoNormal"></p> </div> </div> <div id="content"> <div id="content_text"> <p class="MsoNormal"><span style="font-family:trebuchet ms,helvetica,sans-serif;"><o:p><span style="color:#000080;">&nbsp;</span></o:p></span></p> </div> </div> <p class="MsoNormal"><br clear="all" style="mso-special-character:line-break" /> <span style="font-family:trebuchet ms,helvetica,sans-serif;"><span style="mso-fareast-font-family:&quot;Times New Roman&quot;"><o:p></o:p></span></span></p> </div> <div id="footer"> <p class="MsoNormal"><span style="color:#000080;">&copy;Crystal Clear Solution LLC 2001-2018 </span></p> </div> </div> </div> </p> </body> </html>