Crystal Reports Online Training

Learn Online, Anytime, Anywhere

Step-by-step tutorials and online videos.

Click Here To Learn More »

4.28 DCP Helpful Tips

When selecting which field to display, it’s important to choose the proper table. As we discussed earlier in the chapter, some tables have a complete list of all the available values and some tables only show the values that have been selected as part of another record. This second list is most often incomplete. For example, the Customer table will list every customer your company has. But the Invoice table will only show customers with a current invoice on file. The Customer table will be complete, whereas the Invoice table will probably be missing values.

The table you choose has a big impact on the prompts. For example, if you select the Customer table, then the user will be able to see and choose from a complete list of customers. But this list could be quite large and it will take longer for the user to find the customer they want to print. Selecting the Invoice table makes it easier for the user to choose a customer because the list will have fewer entries. However, the user might still want to see the customers with no current invoices so that he can print a report that shows the user had...

Get UNLIMITED Crystal Reports Online Training!

Click Here To Start Your Training!

1500+ Tutorial Pages

Complete Crystal Reports Online Training with over 1,500 pages of better than book quality Crystal Reports tutorials.

Step-by-step Online Videos

Learn at your own pace from the comfort of your home! Pause, rewind and watch online training videos anytime!

Online Community

Members-only community where you can post and answer questions. The community is checked on a regular basis by best selling Crystal Reports book author Brian Bischof to help answer your questions.

Cut & Paste Source Code

Save time with simple cut and paste source code you can use right now in your next report!

Click Here To Start Your Training!