Wednesday, September 2, 2015

Crystal Reports : Crosstab Summaries

I often find is helpful to display both a SUM and a COUNT within the rows of a Crosstab object. A recent client needed to see both the SUM of {INVOICES.AMOUNT} and the COUNT of invoices based on {INVOICES.DATE}.

After adding your Crosstab as normal, go into the "Crosstab" tab under "Format Crosstab"

1. Add a row to the crosstab for a SUM of {INVOICES.AMOUNT}
2. Add a row to the crosstab for a COUNT of {INVOICES.INVOICENUM}
a. What we want to count here is the uniqueID field in the INVOICES table
3. Hit OK
4. In order to make the values stand apart in the Crosstab cells, I like to change the text alignment (left and right) of each summarized field.

3 comments:

张小 said...

the rim of the small seconds and chronograph minute totaliser. The red minute track on the chapter ring around the black skeleton dial echoes the tip of the chronograph hand and breitling replica the minute counter graduation. The latter surrounds the discreet grey date display. The self-winding HUB 1242 chronograph calibre brings the timepiece to life. Whoever said that stained glass, the decorative art of coloured glass pieces, was for medieval churches alone? Contrary to popular belief, Hublot proves that watchmaking is more than just a fantastic artistic and creative medium, it’s also an exciting playground. The result is called the Classic Fusion Tourbillon Vitrail. Designed and made by the Nyon factory, its tourbillon movement has a skeleton architecture housing glass patchwork in red or blue hues depending on replica breitling the model. This painstakingly detailed feature means that each tiny piece is laser-cut and fitted using O-rings. The colourful stained glass that is the dial lies in a titanium or black ceramic 45mm case with matching screw-down bezel.They have been interspersed with carbon layers by breitling replica watches a system which modifies the fibres’ position by 45 degrees. The result is an incredibly light calibre and a super sturdy watch.

Watches Replica said...

This is the new Inter third shirt 2015/16, Inter Milan’s new second alternate strip for the 15/16 football season. Made by Nike, the new Nerazzurri third jersey was officially unveiled on soccer jerseys 16 September, 2015, thus completing the club’s list of releases for the new season.Inter’s new third jersey is yellow in colour, the first time in over a decade that Nike have given a yellow uniform to the Nerazzurri. The last Nike yellow kit to be worn by Inter was back in the 2003-04 season.The “Night Rising” shirt features a striking ombre graphic design, using the same elements present in the new blue Barcelona third kit. The predominantly yellow shirt and shorts will be paired with black socks, and the new third strip will be first seen in cheap soccer jerseys action next month when Inter take on Sampdoria.These are the new WSW shirts 2015/16, West Sydney Wanderers’ new home and away strips for the upcoming A-League season. The uniforms have been made by Nike, who inked a five year deal with the club at its inception back in 2012. Wanderers won the 2014 Asian Champions League by beating Al Hilal, becoming the first Australian team to win the title, and the new strip features a golden star towholesale soccer jerseys commemorate that achievementOther changes in the new WSW home jersey include the Nike logo moving to the centre and thicker hoops. NRMA Insurance remain principal sponsors after agreeing to a three year extension last season.

PLC training in chennai said...


WIZTECH Automation, Anna Nagar, Chennai, has earned reputation offering the best automation training in Chennai in the field of industrial automation. Flexible timings, hands-on-experience, 100% practical. The candidates are given enhanced job oriented practical training in all major brands of PLCs (AB, Keyence, ABB, GE-FANUC, OMRON, DELTA, SIEMENS, MITSUBISHI, SCHNEIDER, and MESSUNG)

PLC training in chennai
Automation training in chennai
Best plc training in chennai
PLC SCADA training in chennai
Process automation training in chennai
Final year eee projects in chennai
VLSI training in chennai