Home
Top AuthorsTop ArticlesArticles WritingSubmit ArticlesRSSFQA 
 
Business
Advertising
Article Marketing
Ask an Expert
Business
Business Coaching
Business Ideas
Business News
Business Opportunities
Careers
Classifieds
Conference
Construction
Corporate
Customer Service
Employment
Entrepreneurs
Ethics
Graphology
Home Business
Human Resources
International Business
International Property
Leadership
Management
Manufacturing
Marketing
Medical Business
Merchant Accounts
Negotiation
Networking
Non Profit Organizations
Online Business
Organizational
Other Business
Outsourcing
Presentation
Project management
Public company
Public Relations
Retail
Retirement
Sales
Small Business
Strategic planning
Team
Training
Transportation and Logistics
UK Property Investment
Workplace safety

 
 
 

Crystal Reports XI


Publisher: helen
Date: 2008-05-04
Ranking Click at the star to rank
Ranking Level
0
No. ranking 0
 
Sponsored Links
If you want the best for you business you want to have world leading software. High standard software allows you to get on with your job, increasing productivity meaning you get more work done at a faster rate. An example of such world leading software is Crystal Reports XI.

Crystal Reports XI is the very best in reporting technology. Available in many stages such as starter, professional or sever, Crystal Reports XI has revolutionised the way in which you can produce and send reports.

Crystal Reports is a service you can use to distribute existing reports over the web instead of by email or hard copy. Crystal Reports XI is powerful and dynamic. It allows you to design, explore, visualise and deliver reports via the web/embedded in applications.

With Crystal Reports XI you can conduct on report business modelling and make execute decisions instantly. Crystal Reports XI also reduces dependency on IT and developers.

The idea behind Crystal Reports XI is so you can design reports for presentation quality. The reports that you produce with Crystal Reports XI can be previewed on the screen, printed onto paper or exported to several different file formats such as PDF, Excel, text or CSV. The formats that you use on Crystal Reports can vary, allowing you to produce your reports in ways that no other software can match. With Crystal Reports XI you can produce reports in the standard simple column way or you can be more creative by producing reports with pie charts, bar charts, cross-tab summary tables and nested sub-reports, which will allow the person viewing the reports to find the exact data that they need to view without having to look through a lot of data.

Crystal Reports XI allows your report to be clear and precise. Crystal Reports XI offers you data access and report design as well as report integration and delivery management. It is clear to see why Crystal Reports XI is the industry leader when it comes to reporting software.

To get the best experience and report solutions for your business with Crystal Reports XI some system requirements should be taken into consideration, all of which, if you don’t already have them, can easily be found:

• Microsoft Windows 2000 SP4, XP, or later Operating System
• Additional operating systems for Java Reporting Component only - Linux Red Hat Enterprise 3, Solaris 8 or later, AIX 5.1 or later, HP-UX 11i v1
• Pentium II Processor or higher (Pentium III-class recommended)
• 128 MB of RAM (256 MB recommended)
• 350 MB of free hard disk space (600 MB recommended)

All of the different functions that Crystal Reports XI gives you can be accessed through rich developer interfaces, providing complete control over report listing, processing, modification, viewing, and administration.

Crystal Reports XI is perfect for your business if you want your business to be the best. Crystal Reports XI will provide you with everything that you need to produce the best reports possible. You won’t find freedom like this with any other reporting software.


 

Crystal Reports XI Keywords:

business      crystal reports xi      Crystal Reports XI      Business      Business     

 
     
 
 

Related Article:Crystal Reports XI

Collapse All
 

Know Your Crystal Before You Buy

Lowry Mell 2008-04-30
Title: Know Your Crystal Before You Buy
Whether you are buying crystal glassware, crystal stemware or crystal figurines, it is important to know the quality level of the crystal. This is especially true if you intend to purchase lead crystal product which is the highest quality of crystal.

Knowing just a little bit about crystal will help you to make a wise purchasing decision and prevent you from paying a higher price for lower quality product. Without getting deeply into the technical aspects of crystal manufacturing, here are some of the basics to help you.

The main difference between glass and crystal is the lead content. Both glass and crystal are composed of sodium, but crystal also has silicone and metallic oxides added to give it a lead content of at least 10 to 24%. The addition of these materials makes the crystal heavier and changes the light refraction index of the item. The result is a brighter and cleaner piece. Since lead crystal is not as brittle as standard glass, craftsmen can make deeper and more complicated cuts in the crystal.

For glass to be called “lead crystal,” the glass must meet three criteria defined by rigorous rates and percentages.

There are four types of lead crystal:

Full Lead Crystal which has 30% or higher lead content, a density rating of 3.00 and a refractory index of 1.545 or greater (how crystal refracts light)

Lead Crystal which has a 24% lead content or higher, a density of 2.45 and a refractory index of 1.545 or higher refractory index.

Crystal glass also referred to as Crystalline which has only 10% lead content, a 2.45 density and a refractory index of 1.520

Crystal glass also referred as to crystalline (resonant glass in French) which has a 10% lead content, a density rating of 2.40 and a low to zero refractory index.

There are many factors that affect the price of crystal beside the lead content. Obviously the higher the lead content the higher the base cost of the product. The method of producing the final figurine also affects the price. Figurines can be made by pouring the glass into a mold, creating a figurine by assembling and gluing various shaped crystals or cutting a design from a solid block of glass. Each method is progressively more expensive because of the labor involved.

Another factor affecting the price is the intricacy of the crystal figurine design, regardless of the production method. Each method will usually involve some cutting, grinding, gluing and polishing.

There are a number of companies, mostly Chinese, that produce crystalline figurines. You can purchase these figurines at a very reasonable price if you are on a tight budget. Just keep in mind that you are not purchasing a "lead crystal" product. Also be aware that there are unscrupulous companies that claim that their figurines are lead crystal when they are really crystalline. It is difficult for the untrained eye to tell the difference between the two. You certainly don’t want to buy a crystalline figurine for a lead crystal price.

You can protect yourself by purchasing from reliable merchants in your local area or on the internet. Your dealer can tell you the lead content of any crystal figurine you want to purchase. They are carefully instructed by the major figurine manufacturers in all aspects of their products. The major manufacturers also include a Certificate of Authenticity with every crystal figurine. The certificate is your additional assurance of the quality level of the product.

You can buy with confidence using this information. You don’t have to be an expert to purchase good quality products. Just ask the right questions and determine the correct type of crystal and you will purchase the right product at the right price.

Unique Crystal Figurines http://www.CrystalSplendor.com


 

Crystal Jewellery or Crystal Maze

Paul Shane 2007-12-06
Title: Crystal Jewellery or Crystal Maze
When you hear the word 'crystal' what does it remind you? It reminds me of the popular old reality game show of our times – 'crystal maze'! But when my wife hears the word 'crystal', I can see her face beaming. No points for guessing that, women just love crystal jewellery. And specially when there are so many designs and colours to choose from, they can not be blamed if they go mad about crystal jewellery.

The exciting range of crystal jewellery include pendants, earrings, rings, bracelets and now there are anklets and armlets too that have crystal embedded. Not just embedded, crystal make excellent pendants that hang beautifully from necklaces, neck chains, bracelets and soft ankles look so pretty and beautiful when small crystal pendants hang from the anklets.

Even accessories like belts, shoes, purses and bags are also not left untouched by the glory and mystifying beauty of crystal. Blue, red, green, there are options galore to select from. And you can add them or stud them on your accessories to make them look cool and trendy. This will also distinguish you amidst the crowd. And not just women, even men love to experiment with their looks and styles and crystal plays an important part in such endeavours. Crystal is also worn by men. They wear it in rings and some also wear it in a pendant. Sometimes they wear it for fashion and sometimes for faith (crystal is believed to have healing powers).

Besides that, crystal is popular mostly because of its beauty and shine. There are different kinds of crystal available, like amethyst etc. They look very cool and beautiful when worn in jewellery. There are different kinds of crystal that suits different occasions. Also a lot depends upon the design of the jewellery. So the next time you wish to gift your wife a crystal jewellery, make sure you know what suits the occasion.

About The Author: Paul Shane cherishes a hobby of studying and collecting Jewellery, to dig out the making and story behind them, especially the rare or exquisite ones, also the Pearls being used for manufacturing the jewellery. He also loves studying consumer behaviour related to jewellery selecting and buying. At present he is associated with a leading group called E-Beads Limited.


 

Crystal Chandelier for an Attractive Room

Eliza Maledevic 2007-04-10
Title: Crystal Chandelier for an Attractive Room
If you hear the word lighting fixture, what is the first thing that comes up to your mind? I would say crystal chandeliers. Since, crystal chandeliers are well-known sophisticated and attractive lightning that you can put in a home.

Through the 15th century crystal chandeliers are said to be a popular decorative designs for the homes and other commercial establishments. Sometimes crystal chandeliers are said to determine your way of living in the society.

The use of crystal chandeliers started many decades ago. We usually see crystal chandeliers hanging in our living rooms, dining areas and hallways. As time pass by, the use of crystal chandeliers started to bloom. Almost everyone wish to own or have a crystal chandelier. Others spend hundreds of thousands of money just to buy a crystal chandelier.

Nowadays crystal chandeliers are also use as a decoration for the bedrooms. It is said that a crystal chandelier can help in making a room look more beautiful. Crystal chandeliers give a different look into a room because of the magical colors from its lightings.

Other interior designers said that crystal chandeliers can be turn into a modern look that will make them add more distinguishable effects on the color and aura of your rooms. With the use of crystal chandeliers you’re trying to show a different look or a new way to emphasize the aura of your house.

Craft experts say that our crystal chandeliers can now be turn into a more modern design. We can turn the colors of the crystal chandeliers into a focal point that can create a more dramatic look instead of just a plain light source. While other crystal chandeliers can be crafted in different abstracts with the shades of a sulk drum.

Other crystal chandeliers are often ornate with many lamps and other shapes of glass, which illuminates the room in many patterns. Crystal chandeliers can make you feel you belong to a royalty family because of the underlying and exquisite beauty it radiates.

Because of the majestic charm, which crystal chandeliers possess, it attracts most people to decorate their houses with it. When buying your crystal chandeliers there are lots of different designs that you could choose from which are sold in the market. It will really depend on your taste on how you will choose a crystal chandelier for your home. There are different chandeliers that are made from the crystals, brass, wrought irons and so many more.

To be able to decide on what kind of crystal chandelier will fit your room, always start with decorations that are simple in colors or those crystal chandeliers that will be predominant in the decoration of your rooms.

Be reminded that blending in all the decorations in your room is very important to make it more look beautiful and attractive.

As soon as you purchase the crystal chandelier you want, you can now hang it out to your room. Definitely, your room looks wonderful as the crystal chandelier is hanging there.

Surely you know that crystal chandelier can make your home or your room in particular, so you have to take some time to clean it up. Clean the crystal chandelier so to maintain its appeal and spark. Just be extra careful in cleaning it. Know more about GoldenAge Crystal Chandeliers & Lighting Fixtures


 

Astonishing Crystal Chandeliers

Eliza Maledeviz 2007-02-15
Title: Astonishing Crystal Chandeliers
Definitely, no one can deny the beauty and charm of crystal chandeliers.

Since the 17th century, these amazing pieces have been delighted us and until now.

Nowadays, there are heaps of different types of crystal chandeliers. One of the crystal chandeliers that stand out is the Strass crystal. Strass crystal is manufactured by Swarovski. It is actually recognized as the world’s finest crystal.

This crystal is first machine cut, next hand polished and soon be coated with an unseen optical layer, which will create an astonishing effect. Actually, these Swarovski crystals are the ones to be used every year in the design of the excellent Swarovski Crystal Palace Collections. These astonishing crystal chandelier designs was first introduced last 2002, and the latest presentation happened in April 2006.

Now, let us see some of the astonishing crystal chandelier designs that have been here for years.

In 2006, fashion designers Bruno Basso and Christopher Brooke designed a chandelier the ‘Science and Fiction’. The chandelier’s shape was based on the Marie-Therese design, which was known with the 18th century Empress of Austria. Ornate candle arms is what the Marie-Therese chandelier was noted for, and now, the ‘Science and Fiction’ has paid respect with this old standard. The chandelier has 111 crystals and 32 lit black candles, which makes it an amazing one.

Ferrucio Laviani, a contemporary designer, has shown an astounding chandelier in 2005 which was called ‘Yoga’. Yoga has 100 crystals with different pastel shades and together with this was a beautiful gold frame. Yoga’s shape is like a children’s top. It is lit with halogens, which cast off a mild and calm glow of colors.

‘Mediterraneo’ is another beautiful chandelier which was introduced by Gaetano Pesce. The chandelier was made up with 140 crystals stands and each consists of 87 Swarovski crystals which are lit by LED. Actually, this is truly a excellent and magnificent crystal design. It even emits calming and relaxing smell and it also changes shape which is appealing to the viewers.

‘Vertigo’ is a chandelier which was designed by Chris Levine. This chandelier is like the old traditional chandelier that you can see in ballrooms. But the advantage of Vertigo is that it is lit with laser lights all through the rows of crystals. And it end up being a stunning chandelier.

‘Run of the mill’ chandeliers are now the thing of the past. Since designers nowadays are keep on experimenting and creating with the artistic beauty of crystals. They are now heaps of stunning and excellent designs of crystal chandeliers. It actually makes a lot of people discover the beauty and charm that can be seen in crystal chandeliers.

Certainly, lot of people believes that crystal chandeliers can make their homes more appealing and will add beauty to their furniture and fixtures. It certainly adds impact to the ambience of a room. And there are heaps of designs of crystal chandeliers; all you have to do is choose the best that will fit to the design of your home.

Know more about Crystal Chandeliers & Lighting Fixtures


 

Crystal Reports: Making Data Crystal Clear

James Hunt 2008-05-05
Title: Crystal Reports: Making Data Crystal Clear
One of the most commonly used report-writing programs around the world; Crystal Reports have been in use for more than 10 years, though many did not realize they were using it. Not specified by name and commonly grouped with other programs, this innovative reporting tool has only recently begun to garner the attention it deserves. Taking dull, flat reports and turning them into exciting visual displays, Crystal Reports are a must-have for any contentious business.

The job of Crystal Reports is to take basic data and change it into a report which is not only easily-understood, but pleasing to the eye. By allowing the user to call upon almost all types of charts, maps and graphs, this program grants a new level of freedom to report generators. Also capable of entering texts, tiles, columns and diagrams, users are able to generate personalized charts and maps, as well as allowing them to save their reports and enter new data fields, at a later date, saving a great deal of time and work. Crystal Reports opens the business to a wide variety of options, allowing information to be sent to all networking computers, to be placed on the Web, or making printer-friendly versions that can be used in presentations.

At first glance, Crystal Reports may seem very intimidating to the new user, especially when one encounters Crystal Reports boot camps and high-priced schooling that is advertised on the Web. Fortunately, a large portion of this program relies upon drag and drop technology, simplifying what others would have you believe to be very complex. Additionally, many publications offer step-by-steps and how-to guides on using this popular program. With patience and a willingness to explore, Crystal Reports are easy to use and provide high-quality work with very little expertise.


 

Crystal Reports and the Business World

carolyn 2008-01-29
Title: Crystal Reports and the Business World
Designed for presentation quality, crystal reports is a proven, world standard solution that helps you to design, manage and deliver reports via the web as well as embedded in applications. It is a business intelligence application and was designed to generate reports from a wide range of data sources.

This leading software means users can arrange the data needed to complete a report in whichever format suits their business best. When the report is completed it can be saved as a file with an RPT extension, which means the report can be re-run at any time by re-opening the RPT file and refreshing the data within it by doing this it will demonstrate if any updates have been made. The report can then be previewed on the computer, printed or exported to a different file format such as PDF, Excel or a text document.

Whoever initially designed the report has the control and ability to open the report in the report designer in order to make changes and variations of the report. These variations can be saved as RPT files by modifying the file name. Crystal Reports are bundled with ActiveX controls, which when embedded in GUI, can provide alternative interfaces. This feature allows reports to be deconstructed into their base objects.

Crystal Reports software helps customers to create flexible and feature rich reports. The powerful report design allows you to create highly formatted and interactive professional reports. It gives you the ability to design within the leading .NET and Java development tools. The flexible application development tool also allows cross platform support from Java, .NET and COM. As well as this HTML is also generated directly by crystal reports, allowing your focus to be on application business logic rather than having to hand code.

The report management and delivery features of crystal reports also means that reports can easily be published to the web and allows you to centralise the management of operational reporting. These three features; the powerful report design, the flexible application development and the report management/delivery features are the main aspects of crystal reports. They compose the three main and beneficial features.

This impressive feature rich application has set the standard for business reporting software with over five million copies of the software already sold and its no surprise as this advanced reporting software allows you to make quick but informed decisions, which can lead your business to increased profitability. It is also flexible in what it can produce:

•Standard reports
•Cross tabulation reports
•Mailing labels
•OLAP cube reports
•Charts
•Comma separated value files
•Excel files

Crystal reports can significantly improve the way in which reports are produced within your business. They give you highly informed information across all aspects of your business and can dramatically increase business decisions thanks to up-to-date information that is quick and easy to find within the well presented, documented and structured reports that crystal reporting software brings you. This advanced software could be exactly what your business has been looking for.

 

Stunning Crystal Chandelier Designs

Jo Williams 2006-06-19
Title: Stunning Crystal Chandelier Designs
There is absolutely no denying the beauty of crystal chandeliers. These interior conversation pieces have been delighting the senses since the 17th century. While there are many different types of crystal available today, one crystal stands head and shoulders above the rest. Strass crystal, manufactured by Swarovski, is recognized the world over as the finest crystal known to man. This crystal is first machine cut, and then hand polished and coated with an invisible optical layer, creating a stunning effect. It is these Swarovski crystals that are used every year in the design of the unique Swarovski Crystal Palace Collections. These stunning crystal chandelier designs have been introduced since 2002, with the most recent unveiling occurring in April 2006. Let’s take a look at some of the stunning crystal chandelier designs that have been realized through the years.

Fashion designers Bruno Basso and Christopher Brooke designed a chandelier in 2006 called “Science & Fiction”. The shape of this chandelier was based on the Marie-Therese design, which is identified with the 18th century Empress of Austria. The beautiful Marie-Therese chandelier is noted for its ornate candle arms, and “Science & Fiction” made sure to pay homage to this old standard. The chandelier includes 111 crystals that feature a print of one of a kind design, and it is completed by 32 lit black candles.

Contemporary designer Ferrucio Laviani presented an amazing chandelier in 2005 that he called “Yoga”. He took over 100 crystals of differing pastel shades and enclosed them in a beautiful gold frame. “Yoga” is similar in shape to a standard children’s top, but this is one toy you would not want the children to play with. This marvelous chandelier is lit with halogens, casting off a gentle and hypnotizing glow of colors and crystal texture.

Gaetano Pesce introduced a beautiful chandelier in 2006 which he called “Mediterraneo”. This chandelier is a feast for the senses, as Pesce designed this chandelier in much the same style as a traditional old world chandelier – with a twist. The chandelier consists of 140 crystal strands, each one consisting of 87 Swarovski crystals lit up by LED’s that change the color of the design. In addition, “Mediterraneo” emits certain soothing smells and also changes shape before the viewer’s eyes. This is truly a unique and gorgeous crystal chandelier design.

Chris Levine was the mind behind the chandelier entitled “Vertigo”. This creation has the look and feel of old-time chandeliers similar to those you might see in ballrooms, but “Vertigo” is lit with laser lights throughout the rows of crystals. The result is a visually stunning display of what can be done with beautiful Swarovski crystals.

As evidenced by these original designs, the days of “run-of-the-mill” chandeliers are a thing of the past. As designers continue to experiment with the aesthetic beauty of crystals, the presentations will surely resemble the stunning crystal chandelier designs mentioned in this article. As a result, more and more people are sure to discover the beauty associated with crystal chandeliers.

 

Tips on Caring for Crystal

Lowry Mell 2008-03-20
Title: Tips on Caring for Crystal

Proper care of crystal is a part of the collecting and ownership process. Bear in mind that crystal is a form of glass and is consequentially fragile. Even solid looking crystal figurines are subject to breakage. Keep the following tips in mind and you will maintain the beauty, quality and value of your crystal.

1. When moving or cleaning a crystal item, handle only one piece at a time. This is the time when most damage occurs so be careful.

2. Glassware, stemware and crystal figurine collectibles should be stored in an enclosed cabinet to avoid the collection of dust.

3. Crystal items used for Home Décor such as crystal flower vases, ashtrays, figurines, paperweights, etc. can be cleaned free of dust with a Blow Dryer set on cool, or with a lint free cloth. Finger marks can be removed with a light spray of glass cleaner and a lint free cloth. Never use paper towels to clean crystal. The wood fibers in paper will create tiny scratches on the surface.

4. Exercise great care when washing crystal. The kitchen sink is the biggest hazard zone for crystal breakage. Crystal is subject to breaking in extreme heat. Wash in warm water only. If the water is too hot for your hands, it is too hot for the crystal. To avoid spotting, add a quarter cup of ammonia or a liquid dishwasher rinse agent with the detergent. Rinse in clean warm water and air dry on a rack or kitchen towel.

5. Take care when washing glassware. Use a soft fiber bottle brush to clean the inside of narrow glasses. For larger glasses, clean the inside with a dish cloth using only two fingers. Never put your whole hand in the glass to clean or dry the crystal. The pressure on the side of the glass will cause it to break and you risk getting a nasty cut.

6. Here are some additional safety measures you can take. Do not put five or six glasses in the sink at one time. When you reach in the water for another glass you create a mini-wave of water pressure. This pressure can push one glass into another glass or one glass into the side of the sink resulting in breakage. Washing one at a time is the better way. Another good idea is to place a rubber mat in the bottom of the sink in case a glass slips out of your hand. The next hazard is the spigot. Push it out of the wash area until you are ready to rinse.

Follow these simple tips and you will keep your crystal looking as good as new with all its original sparkle and brilliance. Use care in handling crystal and it will last a lifetime.


 

Crystal Reports and the Business World

carolyn 2008-01-29
Title: Crystal Reports and the Business World

Designed for presentation quality, crystal reports is a proven, world standard solution that helps you to design, manage and deliver reports via the web as well as embedded in applications. It is a business intelligence application and was designed to generate reports from a wide range of data sources.

This leading software means users can arrange the data needed to complete a report in whichever format suits their business best. When the report is completed it can be saved as a file with an RPT extension, which means the report can be re-run at any time by re-opening the RPT file and refreshing the data within it by doing this it will demonstrate if any updates have been made. The report can then be previewed on the computer, printed or exported to a different file format such as PDF, Excel or a text document.

Whoever initially designed the report has the control and ability to open the report in the report designer in order to make changes and variations of the report. These variations can be saved as RPT files by modifying the file name. Crystal Reports are bundled with ActiveX controls, which when embedded in GUI, can provide alternative interfaces. This feature allows reports to be deconstructed into their base objects.

Crystal Reports software helps customers to create flexible and feature rich reports. The powerful report design allows you to create highly formatted and interactive professional reports. It gives you the ability to design within the leading .NET and Java development tools. The flexible application development tool also allows cross platform support from Java, .NET and COM. As well as this HTML is also generated directly by crystal reports, allowing your focus to be on application business logic rather than having to hand code.

The report management and delivery features of crystal reports also means that reports can easily be published to the web and allows you to centralise the management of operational reporting. These three features; the powerful report design, the flexible application development and the report management/delivery features are the main aspects of crystal reports. They compose the three main and beneficial features.

This impressive feature rich application has set the standard for business reporting software with over five million copies of the software already sold and its no surprise as this advanced reporting software allows you to make quick but informed decisions, which can lead your business to increased profitability. It is also flexible in what it can produce:

•Standard reports
•Cross tabulation reports
•Mailing labels
•OLAP cube reports
•Charts
•Comma separated value files
•Excel files

Crystal reports can significantly improve the way in which reports are produced within your business. They give you highly informed information across all aspects of your business and can dramatically increase business decisions thanks to up-to-date information that is quick and easy to find within the well presented, documented and structured reports that crystal reporting software brings you. This advanced software could be exactly what your business has been looking for.


 

Crystal Reports for Microsoft Dynamics Gp Great Plains – Overview & Faq

Andrew Karasev 2007-10-22
Title: Crystal Reports for Microsoft Dynamics Gp Great Plains – Overview & Faq
Andrew Karasev

Microsoft Dynamics GP is successor of Great Plains Software Dynamics and eEnterprise ERP application, and Crystal Reports was always the reporting tool of the choice for Dynamics. Historically GP Dynamics was available on Pervasive SQL and Ctree platform, where Crystal Reports were limited, due to the limitation to Pervasive and Faircom ODBC drivers. The last version, available on Pervasive/Ctree was Microsoft Great Plains 7.5 and since version 8.0 GP Dynamics is available on Microsoft SQL Server only, and as you can expect, SQL Server opens all the possible horizons for reports development. Current Version of GP as of November 2007 is 10.0. In this small article we will open “philosophical” principles of Crystal Reports design for Microsoft Dynamics GP:

1. Crystal Reports is “just” a reporting tool, not and magic “all-the-problems-solver”. This means that you should not overestimate the power of report wizards, but instead design either SQL view or SQL stored procedure to accept parameters and return records set to your Crystal Report. Then all you need to do in CR is to group records, sort them, and of course apply styles and other “cosmetics”. We are placing this message in the first bullet, because we saw a lot of report design failures, where designer tried to do very complex GP tables links within CR and then apply further complex restrictions, and ended up with lines duplication, and other annoying problems, which in fact pile up if you try to fix them with similar patches and at the end of the way, report was abandoned

2. SQL View vs. Stored Procedure. Of course SP looks more elegant as it accepts parameters, which are translated to CR parameters, however SP is also more powerful than the view due to the ability to include temporarily tables and intermediate calculations (based on temporary tables). Temporary tables allow you to go beyond the standard techniques of grouping in SQL Select statement – this should be the real solution, which will eliminate records duplications, described in #1. If you plan to invest your time in CR practicing for GP, you should make several practical lessons where you base GP Crystal Reports on SQL view and stored procedure

3. Other reporting tools for GP. If you are CR developer, it is natural, that you try to apply Crystal Report in all the situations, however you should be aware that GP has very powerful pre-designed tools. If you need to create financial statements: Balance Sheet, P&L, Cash Flow – you should consider FRx report designer first, FRx links to GP General Ledger and so, if more efficient than CR in Financial Reporting. GP ReportWriter. This reporting tool gets the advantages of GP report launching screens, such as SOP Invoice form, from where you can print specific invoice – so called modified reports allow you to place your company logo on Invoice form. Other features of FRx and RW are outside of the scope, please check our publications on these products

4. GP Dexterity Reporting. Dexterity is IDE and programming language of GP. Dex allows you to customize GP forms and reports plus create new ones. In order to explore Dex option, we recommend you to contact GP Dexterity developer, who should help you in the selection

5. Calling CR from GP interface. You can use several techniques. First one is traditional – use VBA/Modifier (you will need customization site enabler license for GP), from VBA scripts you can call CR engine. Second technique is Dexterity, where you call Crystal Reports engine from your custom Dexterity sanscript code. You can also consider SDK for Visual Studio developer, allowing you to extend GP forms and of course call CR from your .Net extension application



 
 

Leave Comment

Author Name*
:
Author Email*
:
Comment*
:
Security Code*
: captcha