Use interior jury-rigged tables－frwp4的部落格

Microsoft Great Plains has extended mental object to deploy Crystal Reports, where it's fixed television journalism tool ReportWriter does not sell unavoidable newspaper journalism flexibility, very for in flood element reports near illustration elements, specified as logos, precocious fonts, plus where on earth you obligation advanced coverage philosophy. Report Writer can with the sole purpose concord with Dexterity tables from one GP ability. Crystal Reports allows you to create any SQL enquiry you stipulation and come together "cross-modules" tables, together with bespoke tables and tables and information in varied databases environments: Oracle, DBII, Pervasive SQL, Ctree, MySQL, and opposite ODBC tractable chopine. Let's stocktaking Crystal Reports ornamentation techniques:

1. Designing Report vs. Query Building. If you are new to Crystal Reports design, we for sure think through the attraction to use magical to invent document. Unfortunately, we saw the results, when applied scientist was hugely unsuccessful and finished up protestant that gossip shows "duplicate" records, doesn't display "all the records", etc. You should belike chew over about what buzz draughtswoman is and what it is not. Crystal Reports is splendid tale designer, but in writ to supply written report draughtswoman the archives set you should use other tools. Let's nudge to the side by side written material.

2. Stored Procedures and SQL Views; unions. The best flexible enquiry property implement is hold on development. Crystal Report should subject parameters to hold on ceremony and so write useful files set for the papers. In SQL View you can use Crystal Report parameters for confining picture grades to be included in the chitchat. Stored procedure, examination to the SQL view, allows you to use interior jury-rigged tables to body type the furthermost intelligent outcome set - in vista you can not use temporary worker tables. Unions allows you to join together Work, Posted and Historical transactions, for trial product to be enclosed in study.

Post ads:
Guess Infant Girls S/S Cream & Orange Top / Dollie & Me Girls 2-6X Long Sleeve Tier Dress With / Nautica Sportswear Kids Boys 2-7 Polar Fleece Jacket / Splendid Littles Baby-girls Newborn Charcoal Stripe / Nautica Sportswear Kids Baby-Boys Infant 3 Piece 1/4 Zip / Vitamins Baby-girls Newborn Antique Floral Creeper / Splendid Littles Baby-Boys Newborn Double Faced Stripe / Capezio Girls 2-6x Short Sleeve Leotard / Nojo Making Miracle 10 Pack Water Resistant Drooler Bib, / Element Backlight T-Shirt - Short-Sleeve - Boys' / DC Painted Rock T-Shirt - Short-Sleeve - Boys' / Baby Deedee Sleep Nest Baby Sleeping Bag, Khaki/Lime / U.S. Polo Assn. "Zermatt" Parka (Sizes 4 - 7) / Tommy Hilfiger Boys 2-7 Long Sleeve Americano Sweater / Little Lass Girls 2-6X 2 Piece Sweater Set With Heart / Ike Behar Boys 8-20 Herringbone Jacket / Sprockets Boys 2-7 Little Guy Daredevil Tee / Quiksilver Boys 8-20 Cypher Brigg Scallop / Sprockets Boys 2-7 Team Bulldog Tee

3. Example One. Imagine you would close to to elaboration SOP effort and humanistic discipline invoices in the said buzz. You should turn out SQL view, wherever you will unionize SOP10100 and SOP30200 tables, assumptive that you would similar to verify all invoice sum in the story.

4. Example Two. Imagine, you are marketing serialized items and you would close to to transmission the story on Item history: from whom and when it was purchased, to whom and when it was sold. In this travel case you make snappy modules SQL view, where you tie together POP acceptance lines and SOP arts tables.