Tag: Allen G. Taylor

A report is only useful if those who receive it understand what it means. Knowing how to use Crystal Reports gives you the edge in producing reports from your database that really are crystal clear. Crystal Reports 2008 For Dummies is a quick and easy guide to get you going with the latest version of this bestselling report-writing software. In fact, it’s so popular that previous editions have made it a bestseller too. Crystal Reports 2008 For Dummies gives you just what you should know to produce the reports you’ll need most often, including how to:Pull specific information from your database, sort and group it, and find the details you needUse dynamic or cascading promptsTroubleshoot and print reports and save time with templatesView reports on your LANWrite formulas to retrieve specific informationCreate and update OLAP reportsFormat reports, control page breaks, and even add graphics or Flash filesEnhance your reports with charts and mapsUse Crystal Reports in the enterpriseThere’s also a companion Web site with sample reports from the book and links to sites with more related information. With Crystal Reports 2008 For Dummies by your side, you’ll soon be able to create reports from simple to spectacular, whenever the need arises.

Would you read information presented like this? No. It’s just not natural. Sometimes presentation is almost as important as content. When you create a report, the goal is to provide information for readers in a format they can readily understand.Crystal Reports 10 For Dummies, the latest version of the most popular report writer in the world, shows you how to create simple or sophisticated reports, turning data into interactive, actionable reports that convey what’s happening in your business. You can progress cover-to-cover or use the index to find out how to:Give your reports more pizzazz by using the correct fonts, color, drop shadows, graphic elements, and moreIntegrate elements from multiple, non-database sourcesGroup sort, total result sets, cross-tab reports, and add formulas, charts, or mapsPrint reportsUse customized Business Views gleaned from the same information to provide each reader with information he or she needs to know without spilling all the beans, sales figures, marketing information, or whateverPresent multi-dimensional data in OLAP (Online Analytical Processing) cubesGet ideas from sample reports on the companion Web siteWritten by Allen G. Taylor, nationally known lecturer, teacher, and author of over 20 books, including Database Development for Dummies, Crystal Reports 10 For Dummies makes it crystal clear how to:Store your information securely in Crystal RepositoryUse Crystal Analysis 10 to display OLAP data so you and your report’s readers can analyze the information in an online environmentUse Crystal Enterprise to put Crystal Reports online for viewing by hundreds or thousands of people in your organizationWhether you want to dazzle your company’s CEO and shareholders, motivate the sales force, or simply share database information cogently, with Crystal Reports 10 For Dummies you not only make your point, you an impression. When your reports look professional, you look professional.

See how SQL interfaces with today's environments Start building and using relational databases with SQL's newest features The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through all the newest features of SQL, you'll soon be whipping up relational databases, using SQL with XML to power data-driven Web sites, and more! Discover how to * Use SQL in a client/server system * Build a multitable relational database * Construct nested and recursive queries * Set up database security * Use SQL within applications * Map SQL to XML

SQL is the international standard language for creating and maintaining relational databases. This book is a compendium of information about SQL and relational database design, development, and maintenance. The nine mini-books cover the full spectrum of issues that arise in building, using, and maintaining relational database systems. Book I: SQL ConceptsBook II: Relational Database DevelopmentBook III: SQL QueriesBook IV: Data SecurityBook V: SQL and ProgrammingBook VI: SQL and XMLBook VII: Database Tuning OverviewBook VIII: Appendixes

Many database management system (DBMS) tools run on a variety of hardware platforms. The differences among the tools can be many, but all serious products have one thing in common: They support data access and manipulation in SQL, the industry-standard language specifically designed to enable people to create and manage databases. If you know SQL, you can build relational databases and get useful information out of them. Relational database management systems are vital to many organizations. People often think that creating and maintaining these systems are extremely complex activities – the domain of database gurus who possess enlightenment beyond that of ordinary mortals. Well, SQL For Dummies, 5th Edition, sweeps away the database mystique.Written in easy-to-understand terms and updated with the latest information on SQL, this handy reference shows you step-by-step how to make your database designs a reality using SQL:2003. But you don't have to be a database newbie to find value in SQL For Dummies, 5th Edition; even if you have some experience designing and creating databases, you may discover a few things you didn't know about.Here's just a sampling of some of the things you'll find covered in SQL For Dummies, 5th Edition:Exploring relational database and SQL fundamentalsBuilding and maintaining a simple database structureBuilding a multiple relational databaseManipulating database dataExamining SQL nuts and bolts: values, expressions, operators, and queriesProviding database security and protecting your dataExploring ODBC and JDBC, and using SQL with XMLMoving beyond the basics: cursors, persistent stored modules, and error-handlingTop Ten lists on common SQL mistakes and retrieval tipsPlain and simply, databases are the best tools ever invented for keeping track of the things you care about. After you understand databases and can use SQL to make them do your bidding, you wield tremendous power. SQL For Dummies, 5th Edition, can get you well on your way to harnessing the power of databases.

Learn SQL the fun and easy way – no programming experience needed!SQL For Dummies, 7th Edition, shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. This book covers the core features of the SQL language. Topics covered include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database. This edition will be revised to reflect the new enhancements of SQL/XML:2008.The latest update of the perennial bestselling SQL For Dummies, which has sold more than 210,000 units in six editions.SQL is the most popular database language in the worldCovers creating, accessing, manipulating, maintaining, and storing information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL.Includes new content on using SQL with XML to power data-driven web sites and using SQL with Access 2010Whether you're daunted by database development or a system admin star, SQL For Dummies, 7th Dummies will have you working your web site in no time at all.