• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Exploring Reports > Setting Up Spreadsheet-like Calculations in Repo...

Setting Up Spreadsheet-like Calculations in Report Controls

There are different ways to type expressions in report controls. You can right-click a control to access its Control Source property in the Property sheet, or you can click directly on the text box and start typing. You might be wondering, “Why not just type the formula in the box directly every time?” This method would work, except for the fact that you might need to right-click the controls anyway to check the other properties. What’s more, right-clicking the control offers options for better views of your expressions.

There are two ways to refer to controls in a report. You can refer to them by their control name or by their control source, which is most commonly the field name. If the control source happens to be an expression, then you should use the control name to refer to the control. This works to your advantage by giving you a mechanism to set up spreadsheet-like calculations. The next steps show you how to accomplish this:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint