Skip to Content

Today I attended an ASUG session where Tammy Powlas was presenting on how you can integrate Crystal Reports with SAP.

Tammy Powlas works for Fairfax Water and this would be a customer success story.

ASUGSession.png

Figure 1: Source – ASUG

In the below slide you can see the background of the company Tammy works for,  Fairfax Water is one of the largest water utility companies in Virginia.

FairFaxWater.png

Figure 2: Source – ASUG

Tammy then discussed why use embedded analytics. Some convincing points are listed.

WhyEmbedddedAnalytics.png

Figure 3: Source – ASUG

Tammy then discussed what is embedded analytics. The below statements came from the big red competitor of SAP.

EmbeddedAnalytics.png

Figure 4: Source – ASUG

Tammy then also elaborated on SAP definition of embedded analytics.

EmbeddedSAP.png

Figure 5: Source – ASUG

Tammy then discussed in that most SAP reports are displayed using ALV grid, all these reports can be displayed in Crystal Reports. Also discussing ALV as a source.

CrsytalReportsERP.png

Figure 6: Source – ASUG

Tammy was discussing what software is needed on the server and client machines in order to use Crystal Reports.

Software.png

Figure 7: Source – ASUG

The below demonstrates the difference between ALV and Crystal. Gives you a good feel how the ALV would look like when in crystal.

ALVVSCrystal.png

Figure 8: Source – ASUG

Tammy discussed further the output options and that no extra servers or infrastructure is needed. It becomes part of your SAP ERP. Your SAP ERP must be on EHP 5.

Crsytal2.png

Figure 9: Source – ASUG

Tammy also discussed how to setup the below, also how you can customize reports easily and add extra content.

Config.png

Figure 10: Source – ASUG

Tammy then demonstrated this functionality in action with several mini videos. Great stuff.

/wp-content/uploads/2013/06/demo_232541.png

Figure 11: Source – ASUG

Tammy also discusses data sources and options.

DataConnectivity.png

Figure 12: Source – ASUG

As part of the data source options we can see that when connecting to SAP ERP we can use Transparent Tables and InfoSets.

ERPDataSource.png

Figure 13: Source – ASUG

Another option to connect to SAP ERP is by making use of the universe.

Universe.png

Figure 14: Source – ASUG

The above was key things that caught my eye.

For more info follow me on twitter @louisdegouveia

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply