in
Forums
Blogs
Files
Devexpress.Com
ClientCenter
Support Center
DevExpress Channel

Thinking Out Loud

March 2008 - Posts

  • Creating Cross Tab Reports using the XtraReports Suite (WinForms-Visual Studio .NET)

    If you've had to create cross-tab reports with competing reporting tools in Visual Studio .NET...well, you know what a nightmare it can be. Thought all of you might find it useful to see step by step instructions on creating a cross-tab report with the XtraReports Suite v2008 vol 1. In this example, I'll focus on WinForms - in a subsequent blog post, I'll describe how you can accomplish the same for ASP.NET.

    Before I continue - let me put on my marketing hat and say that the XtraReports Suite is available for $499.99 with full source code and $349.99 without source code. It's also included in our DXperience Subscription packages. Regardless of how you purchase it (standalone or as part of DXperience), XtraReports offers you full featured reporting for both WinForms and ASP.NET

    Ok...onto the step-by-step cross-tab report tutorial. The first dozen or so steps are rather basic so if you get bored, jump to the Adding Fields section for the heart and guts of cross-tab report creation with the XtraReports Suite.

    1. Start Visual Studio (I know, this one is sort of a no brainer)
    2. Create a new Windows Application
    3. On the Project menu, select Add New Item…, or press Ctrl+Shift+A to invoke the Add New Item dialog.
    4. Choose XtraReport Class v8.1, and click Add.
    5. Open the Toolbox pane and then drag & drop the XRPivotGrid control from the DX: Reports.v8.1 toolbox tab onto the Detail band.

    Binding Data

    1. Invoke the Smart Tag for the XRPivotGrid (for this, click the arrow icon located at the top-right corner of the XRPivotGrid control).
    2. In the Smart Tag, choose the Data Source property and click the Add Project Data Source link.
    3. Choose the Database type, click Next.
    4. Set the Data Connection to the nwind.mdb file. For this, click New Connection, set the Microsoft Access Database File (OLE DB) as the Data source, click Browse and locate the nwind.mdb file on your hard drive. Click Ok, then Next.
    5. Click No to leave data source file in its original location.
    6. Click Next.
    7. Choose the SalesPerson view, and click Finish. Now the XRPivotGrid is bound to the SalesPerson view (its Data Source is set to nwindDataSet1, Data Member to SalesPerson, Data Adapter to salesPersonTableAdapter).

    Now onto the interesting stuff

    1. In the XRPivotGrid's Smart Tag, click the Run Designer… link.
    2. Click the Retrieve Fields button.
    3. Switch to the Layout section in the navigation bar on the left.
    4. Drag & drop the CategoryName and ProductName fields to the Row Fields area.
    5. Drag & drop the Country and SalesPerson fields to the Column Fields area.
    6. Drag & drop the Quantity and ExtendedPrice fields to the Data Items area.
    7. Click Apply.
    8. Close the editor.

    The following is an image describing what you ought to see in design time

    XtraReports Design Time

    Preview the Cross-Tab Report

    To preview a report, add this code to the Click event of a button.

    private void button1_Click(object sender, EventArgs e) {    new XtraReport1().ShowPreview();}

    Execute the application - the result should look like this: 

    XtraReports - Cross Tab Report

    Obviously, formatting the report to meet the needs of your customers is the next step - but we'll leave that for another day...Also, dont forget to read my post on using the XtraPrinting System to render your WinForms UI to paper - if using the XtraPivotGrid, you have some interesting options available to you so that you radically reduce the number of reports you'd otherwise be forced to manually generate.

  • Use the Source Luke

    Every once in a while, we get a question that makes me say hmm....not because the question is complex or ill-conceived...just that no matter how much effort we put into repeating the same thing on our site, people make assumptions or draw conclusions based on past experiences.

    The question went something like this - "Do you offer source code escrow for your components."

    Of course, the answer is we do not since we ship 100% of the source code for all of our Visual Studio .NET and Delphi controls. Since we ship source, there's no need for an escrow. Smile

    So...to sum up...we ship source for all our controls (though you have the option of buying non-source versions of our products if you wish to save a bit of money) and this includes the XtraReports Suite. Just because others don't ship source for their reporting tools, does not mean we don't Smile

  • I Love End User Report Designers...NOT!

    A long time ago, in a galaxy far away...I, like many of you, had to create reports for my end-users. Let me tell ya, I hated it. No matter what I spec'd and built, it was never enough. Eventually, I reverted to shipping an end-user report designer with the hope of reducing my headaches, but of course, that did not happen. A report designer in the hands of the average Joe spells trouble and a ton of questions I had no time to answer. Thankfully, I no longer see nightmares about all the reports I had left to complete...

    Over the years, I've talked to many developers at tradeshows and user group events and have come to the conclusion that I'm not the only one who hates creating reports. Conversation at these events usually goes something like this. "Hey, do you guys make a reporting tool?" Yes, we do. "Do you guys have an end-user report designer?" Yes, we do. Then I ask...Do you like to create reports? "No, I hate it." Do your users understand how to create their own reports with the report designer. "No, they don't but we still ship it regardless."

    Once we've established our mutual disgust of the report creation process, I usually point people to something I wish I had those many years ago - a way in which to bring my UI to the printed page and in so doing address a large number of report requests from my end-users. Before I continue, I want to state that the approach I'm about to describe in no way eliminates the value of an industrial strength reporting tool like XtraReports - there are countless reports that only a reporting tool can address....and I'm thankful our team has been able to deliver a high quality reporting tool to market....

    Getting back to the conversation - at this point, I usually start our demo application and go to one of our XtraGrid Suite demos.

    XtraGrid Client App

    I spend a few minutes sorting/grouping/summarizing/customizing the contents of the grid - things that end-users can learn quite quickly. Then I select the Print and Export To menu item and press Print Preview. After a couple of additional customizations, such as specifying the shrink to fit option and entering header/footer info, they see the following:

    Grid Rendered to Paper

    Quick and Easy - the UI (which can be customized by the end user) that we spend so much time creating rendered to paper.

    Moving forward, I then start our PivotGrid demo...

    PivotGrid Client Application

    Make a few changes within the UI and select the Print Preview option again

    PivotGrid Rendered to Paper

    At this point, my mind usually travels back in time recalling the nightmares I had in my past life...Oh well, I keep telling myself that I'm a better person for the pain I endured.

    Now, I know that many of our existing customers are doing these very things and exploiting the XtraPrinting System and rendering their UI to the printed page. For those of you at the product evaluation stage, don't forget to select the Print Preview option from our demos and see if the XtraPrinting System can help you address the needs of your users more effectively (and far more quickly).

  • Planes, Trains, and Product Names

    Every once in a while, we receive a question from a bewildered customer asking us what they receive when they buy a product from us. My hope with this post is to clarify some of the more common questions we receive.

    Products for Visual Studio .NET

    First, I thought I came up with a real clever name for our .net package - DXperience. Turns out, people have a hard time pronouncing it. It's actually pronounced "The Experience"

    DXperience is a bundled package of products. It comes in 4 versions.

    • DXperience Universal
    • DXperience Enterprise
    • DXperience Professional
    • DXperience ASP.NET

    The following web page describes what you pay and what you get in return for each of the products listed above. http://www.devexpress.com/Products/NET/DXperience/editions.xml

    In addition to these bundled offerings, you can purchase nearly all of our .NET offerings individually. For instance, you can purchase the XtraGrid along with XtraReports if those are the only product you plan on using.

    Our website contains detailed information on each product and/or suite we offer. If you want to know what is included with a given product library, simply visit the appropriate product web page. The following is the product page for the XtraGrid - http://www.devexpress.com/Products/NET/WinForms/XtraGrid/

    If you navigate to the specifications/pricing page (use the navbar on the left hand side of the page), you'll see that when you purchase the XtraGrid Suite (either individually or as part of a DXperience bundle) you will have access to over 50 controls. The page also lists pricing - the XtraGrid is available for $399.99 with source code and $299.99 without source code.

    The Subscription Model

    All DevExpress Visual Studio .NET products are sold based on a subscription model. All this means that when you purchase one of our products, you receive 12 months of free updates from the date of purchase...be it a minor service update or a major new version. After the 12 month period and at your discretion, you can "renew" the subscription and receive another 12 months of free updates. If you choose not to renew...no problem...you can continue using the last version you obtained or are eligible to use. The 12 month time frame is merely for new versions/updates and has no relevance to rights of use (as long as the EULA is not violated).

    I have to admit, the term subscription can be a bit confusing...some of our competitors dont sell individual products as we do and only sell bundles. These bundled products are given the generic label of a "subscription." In our model, subscription is a term used to describe the method by which we issue new versions and whether a person is entitled to that new version. DXperience is a bundle of products (be it for WinForms, ASP.NET, etc)...and it is sold as a subscription. XtraGrid Suite is an individual product library (contains over 50 controls)....and it is also sold as a subscription.

    Royalties

    This one is real simple...We dont charge royalties. If you abide by the terms of the EULA, you never have to worry about royalties or ridiculous per server deployment costs.

    More info on licensing/royalties can be found here: http://www.devexpress.com/Support/LicensingFAQ.xml

    Products for Delphi/C++Builder

    Our VCL product line is a bit different than our .NET product line. When you purchase an individual product, like the ExpressQuantumGrid, you receive the current shipping version. If at a later time we release a new version, you can upgrade to the new major version. As an example, we just released a new version of the ExpressNavBar. If you own an existing license, the cost to renew that product was $29.99. Minor service updates for a given product version are provided to you automatically.

    As many already know, we do have a VCL product bundle - it is called the VCL Subscription. It works just like our DXperience bundles and it is based on a subscription model.

    Finally, in our VCL product line, we offer 2 other non-subscription bundles....one is the ExpressPack (a combo of the QuantumGrid and ExpressBars) and the QuantumPack. Though product bundles, these 2 products are not sold based on the subscription model.

    Hope that makes things a bit more clear...

     

     

  • Getting Answers to Your Questions

    No one likes to wait to get answers to a questions. If you are like me, when you encounter an issue, the immediate reaction is to send an email or pick up the phone and call someone.

    The other day, we had an individual call us who was frantically trying to get rid of the trial version message in an the ASP.NET solution. He'd built his app using our trial and prior to demonstrating it to his client, he purchased a license. I asked Mehul to assist him and Mehul's reply to me was..."There's a knowledge base article about that."

    Stooopid me - after all the effort we put in to creating a knowledge base, I did not even think to consult it.

    Had I done so - it might have gone something like this....

    First, enter my search criteria in the search field and then specify Support Center in the combo box located in the upper right corner of our home page.

    Search Criteria

    Next, press Go

    With that, the very first item in the result set would have been the answer to the question at hand...

    Results

    Obviously, not all your questions will have answers to them, but it can't hurt to try the knowledge base first.

    As always, we are here to help, so when you do encounter an issue and cannot find an answer that addresses it, write to us...

     

  • New and Updated ASP.NET Controls

    As you might already know, we launched DXperience v2008, vol 1 today. Among the many new features and updates within our .NET product line are 3 new ASP.NET controls:

    • ASPxTreeList
    • ASPxHTML Editor
    • ASPxSpellChecker

    To help with product evaluation, we've created and published online demos describing some of the capabilities of these new ASP.NET controls. To access them, visit one of the following:

    http://demos.devexpress.com/ASPxTreeListDemos/ 

    http://demos.devexpress.com/ASPxHTMLEditorDemos/

    http://demos.devexpress.com/ASPxSpellCheckerDemos/

    Beyond these new controls, a series of other major enhancements have been introduced in our existing ASP.NET capable control libraries. For instance, the XtraReports Suite for ASP.NET now allows you to create cross-tab reports with ease compared with other options available in the market. For a demo, visit: http://demos.devexpress.com/XtraReportsDemos/ReportControls/XRPivotGrid.aspx

    XtraCharts now ships with new Views and our online ASP.NET demo demonstrates their use...look for the updated icon on the navigation pane at the right of the online demo to see them in action: http://demos.devexpress.com/XtraChartsDemos/

    And last, but not least, we have added a small control within the ASPxperience package - the ASPxUpload Control. It's online demo is available here: http://demos.devexpress.com/ASPxperienceDemos/UploadControl/Example.aspx

     

Copyright © 1998-2008 Developer Express Inc.
ALL RIGHTS RESERVED