To unhide a section, right click on the name of the section again, then choose Don't Suppress from the context menu. You can also choose Show. When a section is hidden on a report, you will see diagonal lines through it, like shown below. You cannot delete any of the four default sections however, you can hide them by clicking on the name of the section, then choosing Suppress (No Drill-Down) from the context menu. You can also chose Hide (Drill-Down OK). On the other hand, anything you put in the Page Footer section will appear at the bottom of every page in your report. The Details section repeats for every row of data you have in your report. For example, if you have 300 rows of data in your report, there will be 300 Detail sections in your report.Īnything you put in the Report Footer section will appear at the end of your report. It follows the last bit of data. It is, essentially, the end of the report. You might put a logo, page numbers, or column headings in the Page Header Section. Just as with the Report Header section, you can drag the double line at the bottom of the Page Header section to increase or decrease space. The Page Header section appears at the top of every page in your report. Whatever you put in the Report Header section will appear at the very beginning of the report. You can adjust the size of the Report Header section by dragging the double line downward to add more space or downward to decrease space. These sections are Report Header, Page Header, Details, Report Footer, and Page Footer. If you look at a blank report in Crystal Reports, you will see four default report sections. To do this, click and hold the left mouse button at the top of the Field Explorer panel.ĭrag the mouse. You will see an outline of the panel as you do.ĭrag it to the left side or bottom of the window. The panel will snap into place.įollow the same steps to move the Field Explorer panel back to the right side of the window. You can also move the Field Explorer panel so it snaps to the left side or bottom of the Crystal Reports window. To view or work in the Field Explorer panel, simply move your mouse over it. The Field Explorer panel is then expanded. When you click the pin, the Field Explorer panel is minimized to the right side of the screen. To do this, click the pin icon at the top of the Field Explorer panel. You can dock the Field Explorer panel so it's easier to access, but not visible until you need it. You can use this icon to display or close the Field Explorer panel. If you do not see the Field Explorer panel, go to the standard toolbar and click on the Field Explorer icon.
Crystal report viewer not refreshing plus#
To view your tables and views, expand Database Fields by clicking the plus (+) sign.Ĭlick the plus signs (+) beside the tables(s) and views(s) to see the fields. Once you click OK in the Database Expert dialogue box, you will then see the table(s) and view(s) you selected appear in the Field Explorer panel on the right hand side of the Crystal Reports window. Next, you can set the margins for the report. This is the white space that appears on the top, bottom, left side, and right side of the report.Ĭlick OK when you're finished. You can also choose the orientation of your report: portrait or landscape. You can also select your unit of measurement for the ruler, as well as anywhere else where you'll need to use measurements. You can choose pixels, inches, or centimeters. Under Page Options, you can choose the paper size you want to use for the report. If you don't want to print the report, you can put a checkmark beside "No Printer (Optimize for screen display)". Under Printer Options, choose the printer that will be used to print the report. To set up your report page, go to File>Page Setup. The way you set up your page will define the paper size, the orientation, the units of measurement, and the margins. As much as you need to think about your data, your data sources, and how you want the data to appear in your report, it's also important to think about the appearance of your report – or the design – before we start adding data to it. The design of your report begins with the way you set up your page.