f secure antivirus free download full versionfear 2 project origin download freecountdown timer downloaddownload accelerator plus free download windows 7 64 bit
This crystal report tutorial demonstrates how to use Crystal Reports 4.6, which may be the version of Crystal Reports that shipped with Visual StudioVisual Basic 6.0. Crystal Reports supplies a relatively easy approach to incorporate reporting for your application. The basis of your report is often a database query.
It must be pointed out that this version of Crystal Reports is rather old, and this this version plus the past versions of Crystal Reports who have shipped with VB are likely to be watered down versions that don't have all the features of the standalone manufactured goods is sold by Seagate Software. Furthermore, CR 4.6 won't work with MS-Access databases over Access 97. That said, whatever you learn about designing reports with CR 4.6 may help when working with later versions. Regarding the MS-Access issue, later versions of Access 2000, 2002, etc. can understand and save in Access 97 format.
Crystal Reports 4.6 is bundled with Visual Studio/Visual Basic 6.0, yet it is not installed automatically. To install it manually, locate the CRYSREPT folder with your installation CD - - for Visual Studio 6.0, the trail is COMMONTOOLSVBCRYSREPT for the third CD. In that folder, double-go through the file You are going to be asked if you need to install Crystal Reports. Respond Yes. It will then let you know where it's going to install CR; you'll be able to override the placement if desired. Following that, CR is going to be installed, and many moments later you have access to a message indicating that installation was successful.
contains three tables: EmpMast, DeptMast, and JobMast. The tables are structured as follows:
Primary Key. Uniquely identifies each employee from the database.
Foreign Key to PK of DeptMast table. Identifies which department the worker works in.
Foreign Key to PK of JobMast table. Identifies the workers job.
The volume of hours per week the worker is scheduled to figure.
Primary Key; uniquely identifies each department within the database.
The name with the department.
The departments location can be quite a building, suite number, floor, etc.
Primary Key; uniquely identifies each job within the database.
The job title description.
The minimum hourly rate that a person working in it is usually paid.
The average hourly rate that a person working in this location is usually paid.
The maximum hourly rate a thief working in this location is usually paid.
Two reports will likely be developed because of this database: Annual Salary Expenses by Department and Annual Salary Expenses by Job.
For the Annual Salary Expenses by Department report, you need to show various fields from the worker database tables grouped and subtotaled by department. You also desire to show a great total for the end on the report. A sketch with the design might look something such as the following:
The design from the Annual Salary Expenses by Job report is the identical, except that you would like to show various fields from the worker database tables grouped and subtotaled by job. You might sketch the look as follows:
This tutorial begins off by showing the step-by-step process for designing the primary report, Annual Salary Expenses by Department. Once which is done, it is going to be a simple matter to repeat that report and modify it to build the Annual Salary Expenses by Job report.
With the report designs in your mind, open Crystal Reports Report Designer from your VB Add-Ins menu:
A registration form appears. Click the Cancel button.
From the Crystal Reports File menu, select New :
The Create New Report dialog box appears. Click the Standard button.
The Create Report Expert dialog box appears while using Step 1: Tables tab open. Click the Data File button:
The Choose Database File dialog box appears. Navigate for the directory where your database file resides, then go through the name with the database file so it appears under File Name:. Click the Add button, then click on the Done button.
The 2: Links tab then appears, showing a diagram comparable to that of Access Relationships diagram.
Move on by clicking the: Fields tab.
Using the Add - button, choose the desired fields through the Database Fields listbox so they appear within the Report Fields listbox. Select the fields based around the initial design. For fields which might be involved in the primary key - - foreign key relationship, only select one particular fields from either table as an example, find the DeptNbr field from either the DeptMast table OR the EmpMast table, however, not both.
Select DeptNbr and DeptName on the DeptMast table.
Select EmpNbr From the EmpMast table.
Skip into the JobMast table and pick the JobNbr and JobTitle.
Jump back up towards the EmpMast table and find the HireDate, HrlyRate, and SchedHrs.
Still adhering to Tab 3, you are able to specify column headings by selecting each with the Report Fields in return, and definitely a heading by typing the required text inside Column Heading: textbox automagically, the column heading matches the field name.
Were still not done with Tab 3. We need two computed columns, one for the staff member name which will likely be a concatenation on the EmpLast and EmpFirst fields and one with the annual salary which will probably be the employees hourly rate multiplied by their weekly hours multiplied by 52.
Click the Formula button. The New Formula dialog box appears. Type EmpName inside textbox and click on OK
The Edit Formula dialog box appears. In the Formula text area, type:
TrimRight , TrimRight
Note: Crystal Reports have their own formula syntax, which differs through the syntax of VB and Access expressions. You can scroll the Fields, Functions, and Operators listboxes over the Formula text entry area to discover whats available. Also, as opposed to typing everything directly into the written text entry area, it is possible to double-click on the listbox selection and also the text of the selection will appear within the Formula text box.
Click the Check button. If you entered the formula correctly, the material No errors found will show up. Passing that, go through the Accept button.
The formula are able to appear from the Database Fields listbox as EmpName. With EmpName highlighted, go through the Add- button to include it for the Report Fields list. In the Report Fields list, drag and drop EmpName in order that it appears under. Give EmpName a column heading of Employee Name.
Now we've got to create the annual salary formula. To accomplish that, abide by these steps:
rg Make sure anything OTHER than EmpName is selected from the Database Fields listbox.
rg In the New Formula dialog box, type AnnSal and then click OK.
rg In the Edit Formula dialog box, type
rg Use the Add- button to take AnnSal over through the Database Fields list for the Report Fields list.
rg In the Report Fields listbox, drag and drop the AnnSal formula in order that it is the past field from the list.
rg Give AnnSal a column heading of Ann Salary.
Click some: Sort tab. Select through the Report Fields list and click on the Add- button. then appears from the Group Fields list. Repeat this process for EmpName. Your screen need to look like this:
Click the 5: Total tab. Within this Total tab, an inner tabbed dialog appears, with one tab per field selected inside the sort. On the tab, remove all items except AnnSal on the Total Fields list, as shown below. What we assert is that you should print a subtotal for your annual salary anytime there is really a change, or break, inside the department number.
Still within the 5: Total tab, click on the EmpName tab and take all items through the Total Fields list, as shown below. We dont would like to print subtotals after every employee name.
We dont need to accomplish anything in tab 6, so select the 7: Style tab. For the title, type Annual Salary Expenses by Department.
Click the Preview Report button. At this time, the Create Report Expert is completed and you cant get back on it, but you'll be able to make any desired changes inside the Crystal Reports interface. Following could be the screen which is initially displayed after you select the Preview Report button from Step 7 on the Expert:
On the Crystal Reports toolbar, go through the Zoom button, so you may see the Expert did in your case it gives which you start, but it really needs some work:
rg Go to your File menu, select Printer Setup, and affect the Orientation to Landscape.
rg In the Page header area, select the title Annual Salary Expenses by Department to pick out it. Resize the title in order that it spans the width from the entire report. Go towards the format bar and go through the center button to center the title.
rg From the Insert menu, select Text Field. In the dialog box that appears, type Run Date: and click on the Accept button. At that point, your mouse pointer can also get box representing the words field you only entered. Drag this box for the line the spot that the date is. Use your mouse to prepare the items so they really look in this way:
rg Still inside the Page Header area, take away the column headings for Dept and Dept Name. Do this by selecting each item using the mouse and pressing the Delete key.
rg In the primary area labeled 1: DeptNbr - - A the main one above Details, pick the item there and delete it.
rg In the Details area, find the DeptNbr and DeptName fields, and drag them with all the mouse to the initial 1: DeptNbr - A area.
rg Once inside the new area, select both of these fields and go through the Bold button. Insert a text field in this region using the identical technique while you did with Run Date: while using text Department:. Make this text field bold also. Arrange the fields so they look much like the following you are able to resize an industry by selecting it and dragging for the handles, the same as resizing a control using a VB form:
rg Note that this default format for your department number includes a comma. We dont want that. Right select the department number, and select Change Format - V on the context menu. The Format Number dialog appears, as shown below. Clear the Thousands Separator checkbox and then click OK. Note: You can also add or remove comma formatting by selecting this line of business and clicking the comma button about the formatting toolbar.
rg Remove the commas through the formats for the worker number along with the job number. Resize the fields for the detail line and resize their corresponding column headings so your column headings could be fully read plus the field info is lined up beneath them. Use the screen shot below being a guide:
rg In the next area labeled 1: DeptNbr - - A one below Details, you will note a text item denoted by Xs within the far left from the line. Delete that text item. In exactly the same area, toward the right-hand side on the line, you will note a numeric item denoted by 55.56. This may be the department subtotal. Resize this item so it will be larger, and move it on the right to ensure that it lines up while using detail annual salary field, as shown below:
rg Insert a text field using the text Subtotal for Department to your left on the subtotal not towards the immediate left, because we're going to insert another field between these. Click the Bold button making it bold.
rg On the Insert menu, select Database Field - V The Insert Database Field dialog box happens shown below. From it, select DeptNbr and drag the DeptNbr field on the subtotal line, between the writing Subtotal for Department as well as the numeric subtotal.
rg In the area on the report labeled Grand Total, delete all fields except the primary one a text item together with the text Grand Total plus the last one a numeric item that is certainly the grand total from the annual salaries. Resize and lineup the remaining two items in order that the report looks like the next:
rg In the Page Footer area on the report, there can be a field to the page number. With your mouse, move search engine optimization gainesville up to your right-hand side in the page heading area. Add a text field saying Page: and set it adjacent towards the page number, as inside following screen-shot:
Thats nearly it. Click the Preview tab to check out the finished product.
Due for the fact this became set as much as print in landscape orientation, several screen shots are offered to show one more report. Below will be the left-hand side in the report:
Scrolling towards the right, we see the next:
Scrolling down, we see the subsequent:
At here, if you need to do any further tweaking, it is possible to click the Design tab and achieve this. You can also print the report at the moment. Before exiting Crystal Reports, save the report within the same directory as the VB project, underneath the name Crystal Reports automatically appends extension.
The real objective will be able to print the report through the VB program. The how-to for that's coming up shortly, but first, there exists another report to build. The second report is analogous to that one, other than it will probably be sorted and subtotaled by job, not department. Fortunately, this second report don't even have to be produced scratch. We can modify the very first report to make the second report.
To make the second report, adopt these measures:
2. Double-click to spread out it in Crystal Reports.
3. Dismiss the registration screen by clicking Cancel.
5. From the Report menu, select Report The Edit Report Title dialog box appears. Change the title to Annual Salary Expenses by Job and click on the Accept button.
6. From the Report menu, select Change Group Expert. The Edit Group Section dialog box appears. There should basically be one item from the listbox, reading Group 1: - - A. Select that item and click on OK. Another Edit Group Section dialog box appears. The first combo box ought to have selected. Click the drop down arrow and select and then click OK.
7. In the Page header area, right-select the title, select Edit Text Field, alter the word Department to Job and then click Accept.
8. The next objective would be to switch the department fields inside first 1: JobNbr - - A area using the job fields inside the Details area. To do this, perform this steps:
a. Move the work number and job title fields in the Details line to a open area from the 1: JobNbr - - A line.
b Move the department number and department name fields through the first 1: JobNbr - - A line on the space formerly occupied by the task fields from the Details line. Resize the department name field so it fits.
c. In the initial 1: JobNbr - - A line, edit the text in the Department: text field so it says Job:. Move the task number and job title fields close to your Job: text field and make the two of these items bold.
d. In the Details line, take away the bold formatting in the department number and department name fields.
e. Back from the Page header area, affect the text from the Job and Job Title column headings to Dept and Dept Name, respectively.
f. Make cosmetic adjustments as necessary.
9. In your second 1: JobNbr - - A area, delete the department number field. Replace it with all the job number field. To do this, go for the Insert menu, select Database field, and select JobNbr. Resize the JobNbr field making sure that its sufficiently small to fit the location where the department number used for being. Remove the commas in the formatting and produce it bold. Edit the words field Subtotal for Department, changing your message Department to Job. Make cosmetic adjustments as necessary.
10. Thats practically it. Click the Preview tab to examine the fruits of one's labor. If you wish, go back to make any adjustments you deem necessary and print the report. When that you are done, save the report and exit Crystal Reports.
First, you need to add the Crystal Report control for your VB toolbox. To do it, head over to Project sP Components and look Crystal Report Control 4.6 from your Components dialog box, as shown below:
The form used inside the demo application connected with this topic, named frmCRDemo, is shown below. The form contains two teams of option button control arrays each contain two option buttons indexed 0 and 1. The first option button control array, named optReport, appears inside frame labelled Select Report; your second option button control array, named optDestination, appears within the frame labelled Select Destination. The Crystal Report control was renamed rptAnnSalExp. No other properties on the Crystal Report control were set at design-time; all necessary properties are set in code at run-time. Only one Crystal Report control is required to print any amount of reports off of any form. The Crystal Report control isn't visible at run-time. Finally, there's two command buttons within the form; the OK button along with the Exit button. The OK button runs the report based about the options selected because of the user within the frames above; the Exit button ends the approval.
Following may be the code for both the frmCRDemo form along with a standard module called modCommon. The Crystal Reports-related code will likely be explained pursuing the code listings.
Note that inside cmdOKClick event procedure, the variable strReportName is defined to or, dependant upon which optReport button was clicked. The variable intDestination is scheduled to either crptToWindow or crptToPrinter, both built-in Crystal Reports constants, dependant upon which optDestination button was clicked if you decide to send the report to your window, a print preview type screen appears allowing the user to watch the set of screen; if you decide to send the report for the printer, it is going to be sent directly to your default printer without having preview.
rg ReportFileName refers to your name on the report definition that you simply saved in Crystal Reports. Alternatively, this property will also be set at design-time.
rg DataFiles is really a Crystal Reports property array specifying the database files for being used since the basis for that report. The file you specify here will override the database file used if your report was made in Crystal Reports. Although different MDB files may be used at Crystal Reports design-time vs. VB run-time, they still must support the same table and/or query names, with all the same structure, which are used to build the report.
rg Destination describes where you need to direct the output on the report. In code, it is possible to use a predefined constant like crptToPrinter or its numeric equivalent as used from the sample code. This property will also be set at design-time. The sample app uses either crptToWindow numeric valuation on 0 or crptToPrinter numeric importance of 1.
rg Action would be the property that produces the running with the report. It must be set to a single to run.
Download the project files for your sample application here.
If you enjoyed reading this post, subscribe for updates its free
I use a VB app that passes two dates that happen to be used to pick out records for my report, this works fine.
However, I would choose to be competent to change the report title field from VB eg from date1 to date2 you have the picture?
I cant workout how to complete any ideas?
Wed, 10/22/2008 - 06:26 - Anonymous not verified
Which reporting tool are u using, Ill asume data report. Well this tool data report features a facility which enables you manage the controls around the reports for labels. What u ought of do just go towards the code window in the report and choose the initialize event then type the code like normally the one listed below:
This facility is just available for label controls at run-time. You can ask me a question via my email. Hope it will help.
Thu, 11/03/2011 - 00:44 - Anonymous not verified
DISPALY IMAGE IN DATAREPORT AT ANY COST.THIRD PARTY SOFTWARE OR ACTIVEX ITS VERY URGENT
Thu, 07/05/2007 - 06:23 - Anonymous
this code could hardly run. i've vb6 and cystall report 9. i can't find cystal report 4.6
Fri, 03/21/2008 - 06:19 - Anonymous
Unless otherwise noted, all content on this web site and inside the source samples is Copyrighted Y 2011 because of the owner of All rights reserved - Contact Information
This crystal report tutorial demonstrates how to use Crystal Reports 4.6, which would be the version of Crystal Reports that shipped with Visual StudioVisual Basic 6.0. Crystal Reports comes with a relatively easy solution to incorporate reporting to your application. The basis of any report can be a database query.
It must be pointed out that this version of Crystal Reports is pretty old, which this version plus the past versions of Crystal Reports which have shipped with VB are often watered down versions that will not have all the amazing features of the standalone merchandise that is sold by Seagate Software. Furthermore, CR 4.6 will not likely work with MS-Access databases over Access 97. That said, whatever you learn about designing reports with CR 4.6 might help when working with later versions. Regarding the MS-Access issue, later versions of Access 2000, 2002, etc. can see and save in Access 97 format.
Crystal Reports 4.6 is bundled with Visual Studio/Visual Basic 6.0, yet it is not installed automatically. To install it manually, locate the CRYSREPT folder on the installation CD
Get full use of our entire library!
Portable training you are able to use anywhere!
I just finished Brian Whites InDesign CS2 course. It was the very best one I have labored on so far. He did a great job-VERY thorough.
Works with Windows, Mac and Linux
1000 courses in video format. Start learning in seconds!
Crystal is really a user-friendly database reporting tool that enables users to visually create reports and change these phones virtually any format imaginable. This allows users with hardly any knowledge of SQL or databases to quickly create, distribute, and analyze reports from practically any data source. In addition, the multiple export formats can ensure your data might get from point A to point out B in any format needed. This hands-on Crystal Reports XI: Beginner course by expert instructor Kurt Dunlap will educate you on what is needed to get started on creating reports in Crystal XI without delay. The source reports and test database will also be provided in order that users can follow together with ease. To begin learning today, simply click within the movie links.
Crystal is often a user-friendly database reporting tool that enables users to visually create reports and change these to virtually any format imaginable. This allows users with hardly any knowledge of SQL or databases to quickly create, distribute, and analyze reports from just about any data source. In addition, the multiple export formats can ensure your data might get from point A to point out B in different format needed. This hands-on Crystal Reports XI: Beginner course by expert instructor Kurt Dunlap will coach you on what is needed to start out creating reports in Crystal XI immediately. The source reports and test database are provided making sure that users can follow in conjunction with ease. To begin learning today, simply click for the movie links.
The first 3 chapters of is available to try out for FREE first chapter limited to QuickStart! and MasterClass! courses. Just click for the movie url to play a lesson.
This Course can basically be played employing a subscription. You can play only first 3 chapters free of charge. Click Here to avail to sign up.
1000 courses in video format. Start learning quickly!
Get your own personal downloaded or packaged copy on this course and keep forever.
7 days free unlimited access.
Register now to play the very first 2 chapters of the course for FREE. To access other lessons you'll be able to subscribe monthly, or purchase VTC Credits to work with throughout the site. Try VTC at no cost now remember to work with the Pay since you Learn Option!
If that you are already a dynamic member, please sign in to access the tutorials.
Client and visitor information gathered by VTC is employed ONLY by VTC, our lists aren't rented or sold. For more information, view our online privacy policy.
BY SUBSCRIBING TO THIS SERVICE, YOU ARE CONSENTING TO BE BOUND BY AND ARE BECOMING A PARTY TO THIS AGREEMENT, THE TERMS AND CONDITIONS OF WHICH SHALL PREVAIL IN GOVERNING YOUR RIGHTS OF USE. BY CLICKING THE BECOME A MEMBER BUTTON, THE INDIVIDUAL OR ENTITY LICENSING THE PRODUCT YOU IS CONSENTING TO BE BOUND BY AND IS BECOMING A PARTY TO THIS AGREEMENT. IF LICENSEE DOES NOT AGREE TO ALL OF THE TERMS OF THIS AGREEMENT, THE BUTTON INDICATING BECOME A MEMBER MUST NOT BE SELECTED, AND LICENSEE MUST NOT INSTALL OR USE THE SOFTWARE.
VTC means Virtual Training Company, Inc.
You refers for the user or subscriber.
Software refers towards the VTC training content and software.
2. LICENSE: VTC hereby grants to You a global, non-royalty bearing, non-exclusive license make use of the Software according for the provisions contained herein and susceptible to payment from the applicable subscription fees.
3. RESTRICTIONS: You may not do any with the following:
Save the Software to Your disk drive or other storage medium; permit others to make use of the Software except as specified by addendum; modify, reverse engineer, decompile, or disassemble the Software; make derivative works based about the Software; publish or else disseminate the Software. VTC, Inc., VTC Online University, and also the Virtual Training Company site is owned and operated by VTC, Inc. to be a corporation of record.
All materials on this web site are the property of VTC unless otherwise specified. No material on the market pages could possibly be copied, reproduced, republished, downloaded, uploaded, posted, transmitted, or distributed by any means. Modification from the materials or use on the materials for virtually any other purpose is really a violation of copyright law along with proprietary rights. For purposes on this Agreement, the use from a such material on every other web site or networked computer environment is prohibited.
4. FEES: The rights granted under this Agreement work only upon payment in the subscription fees, which might be strictly non-refundable besides as expressly provided herein. The term monthly subscription means any thirty day period. The term yearly subscription is described as one 365 day period. A yearly subscription ends within the same numerical date the way it began example July 28, 2004 to July 28, 2005.
The VTC Online University is use of every VTC training tutorial inside our library. You pay a set fee for use of these titles. You are billed according in your renewal selection below, which enable it to renew monthly, yearly, or in any increment offered. If you choose being billed monthly, you will likely be billed every 30 days for your subscription before you request the subscription be cancelled. Our terms of use state that you have to cancel a monthly subscription at the very least two days before your renewal date. These two days give to us enough time to ensure that you will not likely be charged again.
5. LIMITED WARRANTY: VTC warrants that this Software, if operated as directed, will substantially reach the functionality described. VTC doesn't warrant, however, that Your use with the Software will probably be uninterrupted or the operation from the Software is going to be error-free or secure. In addition, the safety mechanisms implemented from the Software have inherent limitations, and You must determine how the Software sufficiently meets Your requirements. VTC also warrants that this media containing the Software, if given by VTC, costs nothing from defects in material through the date You acquired the Software. VTCs sole liability for almost any breach in this warranty will probably be, in VTCs sole discretion: i to switch Your defective media or Software; or ii to advise You the best way to achieve substantially precisely the same functionality while using Software as described; or iii when the above medications are impracticable, to refund the subscription fee You paid with the Software. Only if You inform VTC of Your problem with all the Software throughout the applicable subscription period will VTC be obligated to honor this warranty. VTC use reasonable commercial efforts to fix, replace, advise, or refund pursuant to your foregoing warranty within thirty thirty days of being so notified. If any modifications are made towards the Software by You over the warranty period; should the medium is exposed to accident, abuse, or mistreatment; or if You violate the terms on this Agreement, next the warranty shall immediately terminate. This warranty shall not apply if your Software can be used on maybe in conjunction with hardware or software in addition to the unmodified version of hardware and software that the Software was designed to become used as described.
THIS IS A LIMITED WARRANTY, AND IT IS THE ONLY WARRANTY MADE BY VTC OR ITS SUPPLIERS. VTC MAKES NO OTHER WARRANTIES, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NONINFRINGEMENT OF THIRD PARTIES RIGHTS. YOU MAY HAVE OTHER STATUTORY RIGHTS. HOWEVER, TO THE FULL EXTENT PERMITTED BY LAW, THE DURATION OF STATUTORILY REQUIRED WARRANTIES, IF ANY, SHALL BE LIMITED TO THE ABOVE LIMITED WARRANTY PERIOD. MOREOVER, IN NO EVENT WILL WARRANTIES PROVIDED BY LAW, IF ANY, APPLY UNLESS THEY ARE REQUIRED TO APPLY BY STATUTE NOTWITHSTANDING THEIR EXCLUSION BY CONTRACT. NO DEALER, AGENT, OR EMPLOYEE OF VTC IS AUTHORIZED TO MAKE ANY MODIFICATIONS, EXTENSIONS, OR ADDITIONS TO THIS LIMITED WARRANTY.
6. PROPRIETARY RIGHTS: VTC reserves all proprietary rights in and for the Software, is protected by copyright along with intellectual property laws by international treaties. VTC, Inc.
Trademark Notice: VTC, Virtual Training Company, Inc., The VTC Logo, and VTC Online University, are trademarks of VTC, Inc. All other company and product names might be trademarks with their respective owners.
The information contained herein is at the mercy of change without warning. Copyright 1995 - 2005 VTC, Inc. All rights reserved.
7. TERMINATION: This Agreement shall automatically terminate if You fail to comply with all the restrictions described herein. Your obligations to pay for outstanding subscription fees shall survive any termination in this Agreement.
8. LIMITATION OF LIABILITY: UNDER NO CIRCUMSTANCES AND UNDER NO LEGAL THEORY, TORT, CONTRACT, OR OTHERWISE, SHALL VTC OR ITS SUPPLIERS OR RESELLERS BE LIABLE TO YOU OR ANY OTHER PERSON FOR ANY INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES OF ANY CHARACTER, INCLUDING WITHOUT LIMITATION, DAMAGES FOR LOSS OF GOODWILL, WORK STOPPAGE, COMPUTER FAILURE OR MALFUNCTION, OR ANY AND ALL OTHER COMMERCIAL DAMAGES OR LOSSES. IN NO EVENT WILL VTC BE LIABLE FOR ANY DAMAGES IN EXCESS OF THE AMOUNT VTC RECEIVED FROM YOU FOR A LICENSE TO THE SOFTWARE, EVEN IF VTC SHALL HAVE BEEN INFORMED OF THE POSSIBILITY OF SUCH
DAMAGES, OR FOR ANY CLAIM BY ANY OTHER PARTY. THIS LIMITATION OF LIABILITY SHALL NOT APPLY TO LIABILITY FOR DEATH OR PERSONAL INJURY RESULTING FROM VTCS NEGLIGENCE TO THE EXTENT APPLICABLE LAW PROHIBITS SUCH LIMITATION. SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF INCIDENTAL OR CONSEQUENTIAL DAMAGES, SO THIS EXCLUSION AND LIMITATION MAY NOT APPLY TO YOU.
9. Links To Other Materials: Linked sites purchased at the VTC site will not be under the charge of VTC, and we usually are not responsible to the content of a typical linked site or any link incorporated into a linked site. VTC may change links based solely on our discretion, and now we reserve the ability to terminate any link or linking program anytime. VTC will not, by linking to sites, endorse companies or products that it links and reserves the ability to note therefore on its internet pages. If you decide gain access to any in the third party sites associated with this site, one does this entirely at your own personal risk.
Forums, and Chat are certainly not always screened by VTC, and we will not be responsible for your content associated with a public or open forum content once your there. VTC may change these public forums based solely on our discretion, and that we reserve the authority to terminate any forum any time. VTC isn't going to, by permitting these forums, endorse companies or products which can be mentioned of these forums, and reserves the authority to note so on its website pages. If you decide to get into any in the public forums in this web site, or associated with this site, you choose to do this entirely at your personal risk.
9. GOVERNING LAW DISPUTE RESOLUTION: This Agreement is governed by Virginia law. All disputes between You and VTC will be finally resolved through arbitration in Winchester, Virginia. This site is controlled by VTC from the offices in the United States of America. VTC cannot make representation that materials within the site are appropriate or accessible for use in other locations, and entry to them from territories where their submissions are illegal is prohibited. Those who choose to reach this site business locations do it on their own initiative and are liable for compliance with applicable local laws. You may not use or export the Materials in violation of export guidelines. Any claim relating for the Materials should be governed from the internal substantive laws from the Commonwealth of Virginia, USA.
VTC may revise these Terms any time by updating this posting. You should visit these pages from time to time to check the then-current Terms since they're binding upon you. Certain provisions of such Terms could be superseded by expressly designated legal notices or terms positioned on particular pages at this Site.
If you've any questions regarding this insurance policy, or perhaps your information specifically,
When exporting from Crystal to Excel, the output can make out for being unusable with out a lot of reformatting within the spreadsheet. This tends to make business managers unhappy. Fortunatly, with a number of programming and report formatting options, you are able to have perfect Excel exports with little or no effort.
Average Rating: This article has to be rated.
I recently received some feedback regarding a close-to-launch project. The testers reported that they can't manipulate the Excel spreadsheet which was generated from Crystal Reports. In particular, they received the big mistake This operation necessitates the merged cells to get the same size. whenever they tried to sort the details. This report looked great being a PDF, but once I tested the workbook, I saw their problem. Although the report looked effective in first glance, close inspection showed there have been all sorts of weird sized columns and rows stuck in occasionally. Therein lies the challenge, and fortunately, an alternative is to never difficult even during Crystal The entire demo will need about half an hour.
This article assumes you possess a basic working knowledge with the Visual IDE, adding controls to pages, and creating Crystal Reports. You will also have to have the eXtreme Traders database in most form open to you. The Access version is installed together with your Crystal installation, and well take advantage of this database inside our example. I use Visual 2003, and although I dont anticipate any differences between VS 2002 and VS 2003, please send me a email if you will find any.
In Crystal, the Excel export tries to perform a WYSIWYG translation on the report. This can sometimes result in some interesting ends up with Excel, since a Crystal Report places objects using x/y coordinates, but Excel uses line-by-line row/column placements. I am not sure why Crystal engineers thought WYSIWYG in Excel became a good idea, since we have now our number of PDF, RTF or HTML outputs. Intuitively for me anyway, people want data in Excel to enable them to manipulate it further, not as the report maintains its pretty formatting. This may have already been done in order to entice us to upgrade with a full version of CR, or it can be an instance of giving way too many features where fewer is best.
Crystal Reports 9 has a Extended Excel option, and CR 10 replaces this approach with one called Data Only. In either case, the objects are rendered as closely as is possible to row/column format, making the exported spreadsheet more usable and never having to resort to some with the tactics well use below. Since neither these options is accessible to us in, we're going to have to compensate by formatting and design changes.
Business Objects has released a whitepaper regarding Excel exports in CR 10. This whitepaper could be downloaded from, and supplies some useful information. Keep under consideration that the whitepaper discusses features present in CR 10 which are not seen in The troubleshooting section specifically is useful and general enough to put on to likewise as CR 10. Well use some on the information on the whitepaper likewise as a few of my own example of a simple example.
The instructions with this section are necessarily brief where covered in other articles on this web site. For this demo, we will utilize xTreme database that may be included with all the Crystal installation.
In Visual Studio, produce a new web application. In my case, Ive named the project Excel, but you may name yours whatever you decide and like. Next, a dd a brand new Crystal Report for your project. Well name this to signify unhealthy layout. Use the Standard Report Expert to generate your report, and abide by these steps:
On the Data tab, drill down OLE DB ADO Make New Connection.
Choose Microsoft Jet 4.0 OLD DB Provider, and click on Next.
VS 2002 users should browse to C:Program FilesMicrosoft Visual Crystal ReportsSamplesDatabase, and VS 2003 users should browse to C:Program FilesMicrosoft Visual Crystal ReportsSamplesDatabase.
Select and then click Finish.
Choose the Employee Address table, and then click Next.
Add the subsequent fields for the report: ID, City, Region, Country, Postal Code.
Well skip the rest on the options offered to us just for this sample, so click Finish.
Your report will come in a default layout. Save the report file.
Imports Imports CrystalDecisions. Shared
Dim rptExcel As New ReportDocument Dim strExportFile As String . Dim objOptions As DiskFileDestinationOptions New DiskFileDestinationOptions strExportFile objOptions objOptions Nothing rptExcel Nothing
Grant Modify permissions with your projects directory under IISRoot for the ASPNET user this really is required to you'll be able to export an Excel file for the hard disk. Save the many files, compile and run assembling your project. If all went well, you needs to be prompted to look at an Excel spreadsheet. Go ahead and open the Excel spreadsheet.
Place your cursor inside Employee ID column. Notice that it truly is one cell wide. Now move your cursor one column towards the right, on the City column. Notice it is four fields wide. Look for the rest from the fields a similar way. Region is four cells wide, Country is four cells wide, and Postal Code is three cells wide.
Now, highlight all from the data not the headings-just your data. Navigate Data Sort, and judge Column A when your sort column, and then click OK. You should experience an error message that claims This operation demands the merged cells for being identically sized. This message may be the fast track to angry sales managers paying that you simply visit. They do not desire to slice and dice a spreadsheet in order that the columns fit properly. They just want it to be effective when the information are exported.
There are a few report formatting options and document properties you may set programmatically for Excel output. One in the programming options is ExcelUseConstantColumnWidth. When set to true, the Crystal engine set all Excel fields towards the same width, and merge as much fields as important to hold the entire field. Setting this to false will permit the Crystal engine put each value in a very single cell of an more appropriate width.
Dim rptExcel As New ReportDocument Dim strExportFile As String . Dim objExcelOptions As ExcelFormatOptions New ExcelFormatOptions False objExcelOptions Dim objOptions As DiskFileDestinationOptions New DiskFileDestinationOptions strExportFile objOptions objOptions Nothing rptExcel Nothing
Now, rebuild and run any project. Youll see now that you'll find very narrow columns between each in the data columns. Tabbing from column to column signifies that Employee ID works on the single cell, City requires two cells a narrow one, probably C, and also a wide one, probably D, Region and Country each utilize a wide cell, and Postal Code uses two cells.
Whats occurring here? The answer is the fact the variable column width option will not be perfect. Better than before, although not perfect. When a column includes merged cells, this is normally because the Crystal engine couldn't figure out the best way to size the column properly. There may happen to be a spacing issue, and the width in the data column was such that this engine couldnt figure out how you can best size the column. Fortunately, after some design tweaking, we can easily cure the remainder of our problems.
Looking at your data in Postal Code, we are able to see the column is wider than necessary-it really only needs one cell. Perhaps by causing it exactly the same width as Employee ID field inside our report, it are going to be the same width in Excel. To do this, choose the header and field for Postal code, then a header and field for Employee ID. Make sure to pick out Employee ID last. Right-click on any on the selected fields, and judge Size Same Width. Save your report, rebuild and run the application. Make sure to close your browser-dont just reload the page. Sure enough, Postal Code is just one cell wide. However, the column titles are truncated. This is going to take some trial and error in your part by stretching the columns to obtain right, the good news is you know the task. Make sure and keep the header a similar width because field within the report file.
What about City? Trying a similar resizing trick reveals the reason is already the identical size as Region and Country, the latter two simply need one cell. As I stated earlier, another root cause of merged cells is odd spacing between columns. Zoom in to about 150%, and youll identify that all with the data columns are approximately a similar distance apart-about 1 grid spacing. Adjusting the spacing and rebuilding/running demonstrates that we didnt fix one thing. The answer is actually slightly higher about the page-the Print Date field. Set the Print Date field towards the same width as Employee ID, save/rebuild/open, and everything must be nicely arranged, all in columns which can be one cell wide. If you need more room for the report title, stretch the title field to ensure its width is equal to that relating to several columns. When the report is rendered, the stretched field is going to be merged cells, but the info columns will stay separate.
Besides sizing all of the fields inside the same column to your same width, these fields really should be aligned neatly. In our simple example, we probably don't possess any alignment problems. But, if you wish to align a variety of fields, select every one of the fields you intend to align. Right-click about the field you wish to match the mediocre ones to, and select Align Lefts on the menu. You can align lefts, rights, tops, bottoms. Try a couple of options and pay attention to what happens you are not going to break anything, and this is often a learning exercise.
If the thing is very thin rows or columns between other rows or columns, adjust the spacing involving the elements. Try and keep a consistent spacing horizontally too as vertically-this assists the Crystal Engine determine where you should place the cell boundaries. Ideally, there should basically be one grid space between two elements.
In our little demonstration, tidying up the few formatting problems for instance truncated column headings will demand a little patience and possibly several cycles of resize/save/rebuild/run. You can resize the column headings, making sure the details field may be the same width. When designing production reports, this process actually goes rapidly if you understand what to look for.
Make sure precisely what should show up in one column is aligned neatly, and may be the same width.
Put as few heading fields as necessary. Excel output usually doesnt have to have a page number, print date, report title, etc. If you dont need them, remove them from your report. If one does need these fields, youll require some patience to have everything to size correctly.
Try and also have uniform sizes for your fields. Make the fields as wide while they need for being, but try to keep as few different sizes with your report as it can be. Excel columns is usually resized easily that has a mouse click, so it is just not a big deal to possess a lot of large fields if theyll all fit in your page-see below.
Space your data fields as closely as it can be-preferably with one grid spacing between each data field. Try and maintain uniform spacing, preferably an individual grid space, between all elements.
You might need to adjust the width of your respective page to accommodate each of the fields. Since people is going to be adjusting the column width, and perhaps adding summary cells, the particular page width doesnt matter a lot of. Try setting the report page to landscape, and rehearse larger paper sizes if required. Visit my blog for the short example of the way to Change Paper Size and Orientation in Crystal.
In the job, you ought to build two reports for everyone two purposes. One report formatted nicely with headers and page numbers to become printed, then one report that is certainly intended to export to Excel.
Unable to download Excel Data.
Recently we implemented SSl to your Site.
from on that day onwards we have been unable to download Excel data from Crystal Report Export Viewer.
I want to find out if any one are going to be able to provide me some advice in this little following problem.
I used custom colors within my crystal report when i export the report to Excel all is well, but once i export my report through my program i wrote visual studio 10 it turns my custom colors to white and red. If anyone has any idea why it is happening would you please help.
How precisely the same issue might be fixed if Crystal Reports is utilised in a Java/J2EE project?. I am setting various options in JSP using CrystalReportViewer object
After I export crystal report 130 pages to excel. Only header with the first page appeared and all of other pages without headers.
I have to know why any time a had a colum during my report along with a export to excel, that new colum are usually place for the end in Excel. It does nt respect the order in the colum in the report????
Hi could you please suggest me the way to get the drill down data that s exported make up the crstal reports.I wish for getting the drill down data tha ts from the crystal
why crystal report export to excel data only, the title will likely be put about the wong place.
I want to generate a stand-alone application that may convert data to file, prompting an individual to specify the file. Any suggestions? We are having a crystal web service to make the file and display in crystal viewer. The user can help to conserve the formatting but wish to be in a position to sort your data in excel.
Organizations use reporting tools to reach data sources and generate customized reports. Crystal Reports 2008 enhances report building and report processing techniques which has a slew of features that add value on your presentation. In this system, you will make a basic report by connecting to your database and modifying its presentation.
You will connect with a database to extract data and provides it as being a report.
This course is made for persons who require output coming from a database. In some cases, database programs have limited reporting tools, and/or such tools might not be accessible. Students might have programming and/or SQL experience.
Before using this course, students must be familiar using the basic functions of Windows, for example creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files. In addition, students must have taken the Microsoft Office Access 2007 Intro course or have equivalent knowledge about basic database concepts.
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Upon successful completion with this course, students are going to be able to:
explore the Crystal Reports interface.
develop a basic report and modify it.
use formulas for filtering data.
build a parameterized report.