Normal Topic Report Sample 1 (Read 25401 times)
Forum Admin
YaBB Administrator
*****
Offline



Posts: 44
Joined: Jan 1st, 2001
Report Sample 1
May 23rd, 2004 at 3:24pm
Print Post Print Post  
Sample Application: Customers_Report1
Author: Raymond Yoxall
Submission Date: May 20, 2004
DOWNLOAD SAMPLE (122KB)

This application demonstrates how to use multiple Views in combination with Width settings to force Grand Totals to line up with certain report columns. Also demonstrates using SBasic to dynamically change Group Headers.

Usage:
Open Customers\Main Form in Search/Update mode. Retrieve all records. Preview the TotalReport report.

Notes:
Implementation can be seen by looking at the TotalReport report in Designer.

The report has two Views. The first View creates most of the report. The second View prints the Grand Total at the bottom of the report. This is done to allow the use of multiple Groups, as only Groups can be forced into particular column widths. Note (in the Property Viewer) that there is a Width set for each element.In each section, the width for each column matches the appropriate column in the other sections.  This forces all the columns to line up, even though they are in separate tables.

This report also uses programming to print the column labels only once. It then changes the group headers to print a letter in a large font, producing a "telephone book" style report. See the programming for commented code.

Output Screen Shots:


  

-----&&Erika Yoxall&&Forum Administrator
Back to top
 
IP Logged
 
jyellis
Full Member
Members
***
Offline


No personal text

Posts: 114
Location: Dallas-Fort Worth Area
Joined: May 19th, 2003
Re: Report Sample 1
Reply #1 - May 24th, 2004 at 8:17pm
Print Post Print Post  
// Manually increment the grand total so we can
// use it later.
gsGrandTotal += LE3

I don't understand this.  +=????
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Report Sample 1
Reply #2 - May 24th, 2004 at 8:22pm
Print Post Print Post  
Quote:
// Manually increment the grand total so we can
// use it later.
gsGrandTotal += LE3

I don't understand this.  +=????


It's just an alternate syntax. It is identical to saying:
gsGrandTotal = gsGrandTotal + LE3

See page 42 of the Programming Guide under Add-by-Value.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Report Sample 1
Reply #3 - Feb 18th, 2011 at 2:43am
Print Post Print Post  
Off topic replies have been moved to This Thread
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged