Skip to Content

I am new to crystal reports and after knowing the great news about Crystal Reports Integration for SAP Business One, want to understand Crystal Reports in the ever quickest possible time so that my regular works doesn’t much get affected.

On my journey of exploring things my objective is clear that I should able to generate a simple report that is similar to SBO PLD Layout of Sales Order at first.

Immediately things came to my mind is Will I able to develop a crystal report for delivery document that is printed along with Packing List and Batch/serial number information. I think Yes using Sub Report Concept of Crystal Reports. But, I want to focus on Sales Order for now. 

The following are my list of things I wants do:

Note: I do not want to start working with SBO database at first. To better understand, I thought of working with standard sample database supplied along with Crystal Reports itself.

1. I want to download Crystal Reports, Install, connect to sample database

2. Search for online resources to start reading – a good manual to start with

3. Search for a forum to ask questions or browse existing answers posted on forums

4. Start my first simple report

5. Start developing my agenda – Sales Order similar to SBO default PLD Layout

1. I want to download Crystal Reports, Install and Connect to Sample Database

Go to http://www.businessobjects.com/ and downloaded evaluation version of Crystal Reports 2008. I need to input my email id to get license key. Got installed Crystal Reports 2008 by entering the product that is received in my email id. To my surprise there is no sample mdb (MS Access) database supplied along with Crystal Reports 2008. I came to know that to simplifiy download process, sample database is supplied as XML datasource along with Crystal Reports 2008.

Started search for the sample database Xtreme.mdb in businessobjects site, Google.

Luck favoured me in couple of minutes and downloaded a craze.mdb from a site http://kenhamady.com/cru/archives/113. I will be wrong If I do not thank Ken Hamady and The Crystal Reports Underground.

2. Search for online resources to start reading – a good manual to start with

After reading support portal of Business Objects, I landed up at http://help.sap.com/ and found the Crystal Reports 2008 User’s Guide at the following URL:

http://help.sap.com/businessobject/product_guides/cr2008SP0/en/xi3_cr_usergde_en.pdf

3. Search for a forum to ask questions or browse existing answers

I located a lot of information related to online resources and community forums on Crystal Reports 2008 Start Page (after you start Crystal Reports 2008 from start->program menu).

And the following are the URLs:

1. To join a user group:

http://www.busobjects.com/usergroup/join_group.php

2. Diamond Technical Community (now SCN forums). Here SCN is SAP Community Network

https://boc.sdn.sap.com/forum/32

3. Developer Guides and API References

https://boc.sdn.sap.com/developer/library

4. For Licensing

http://www.businessobjects.com/product/catalog/crystalreports/licensing.asp

5. Crystal Reports 2008 – FAQ

http://www.businessobjects.com/pdf/product/catalog/crystalreports/cr_2008_faq.pdf

6. Crystal Reports Product Portal

https://boc.sdn.sap.com/product-portal/3

7. Crystal Reports Sample

https://boc.sdn.sap.com/crsamples

8. Crystal Reports e-Book

https://boc.sdn.sap.com/crystalreports2008

9.Crystal Reports Webinars

https://boc.sdn.sap.com/webinars

10. SAP SDN – Business Objects support for Crystal Reports and Xcelsius

http://www.sdn.sap.com/irj/sdn/businessobjects-support

11. SAP SDN – Crystal Reports Design

SAP Crystal Reports

For information, SBO Integration Blog URL References:

1. Crystal Reports Integration for SAP Business One

http://www.sdn.sap.com/irj/sdn/businessone?rid=/webcontent/uuid/807d22cb-cb1d-2b10-8794-fb76d7feca88

2. Crystal Reports 2008 Basic for SAP Business One

Crystal Reports 2008 Basic for SAP Business One

4. Start my first simple report

4.1 Start Page of Crystal Reports

01 Crystal Reports Start Page

4.2 Created Connection with Sample Database craze.mdb [Access database]

4.3 Selected the connection (Data Source) that is created in step 4.2, Selected Table – Customer

4.4 Clicked next and selected all fields to display in report

4.5 Clicked next and selected Country Column as Group By column

4.6 Clicked next and no change in default (Summaraized fields) and Clicked next and no change in default (Group that will be sorted on Country column)

4.7 Clicked next and no change in default (No chart)

4.8 Clicked next and selected column Last Year’s Sales greater than £10000.00

4.9 Clicked next and selected Template Block(Blue)

4.10 Clicked finish and the report is generated.

4.11 Clicked File -> Summary Info and Set Title to “Country Wise Customer Sales Summary” and other information

4.12 Clicked File -> Page Setup and configured and saved the report

4.13 Clicked View-> Preview to see the report data

My first simple report is completed.

5. Start developing my agenda – Sales Order similar to SBO default PLD Layout

Started attempt for functionality similar to PLD repetitive area functionality in Crystal Reports.

Ok, First I want to understand how to relate two tables say Orders and Orders_Detail.

This time I decided not to use report wizard.

5.1 Started a Blank report

5.2 Selected datasource and two related tables – Orders and Orders_Detail. It is good to see a Links tab in Database expert (where we are selecting our data source/ connection). I noticed tables are linked by name.

5.3 Using Field Explorer, through drag & drop option I placed required fields in Report Header, Details, Footer. If you are used to PLD, then understanding the Report Header (Start Of Report), Page Header, Details(Repetitve Area), Report Footer(End of Report), Page Footer are similar like functionality.

However, issue here is how details is similar like PLD repetitive area, where repetitive area has header, details, footer.  So, What I followed is Create a Group based on Sales Order – to get Group Header, Details, Group Footer. Group header is suppressed as I have shown the headers in Page Header. You can choose to show Group Header just like repetitive are header.

5.4 Created a static type – parameter(yet to understand dynamic) for SalesOrderID using Field Explorer

5.5 In Report Select Expert, for record selection mapped parameter for SalesOrderID

{Table/Command.Order ID} = {?P_OrderID}

Problem Solved for now. I have to still think it over for a better solution than this. I am hopeful that better solutions will be possible.

Like SBO PLD Layout in Crystal Report

5.6 Preview Output looks like:

Preview of CRPLDLayout

I will put my efforts to update this blog as I learn.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Naveen Vishal
    Gud work done dude..even im a newbie to sap-abap, vr still workin on sap 4.7, hopin to upgrade soon..
    keep up this gud work, satish..

    Regards,
    Naveen

    (0) 
  2. Sridharan T
    It was really good content. Being Crystal reports integration already available for B1, it is nice to have a content like this to start working with.
    (0) 
  3. Richard Duffy
    Thanks for pulling this together Satish – it proves that just like they say on The X Files – the truth is out there (as is the information needed to be productive).

    I enjoyed reading the contetn and thanks for pulling it together.

    Richard

    (0) 

Leave a Reply