BEX Report layout Vs Crystal Report layout issue

building reports crystal reports
1

Hi BOB Team

Hope all are doing good!

We are working on Crystal Reporting(Crystal Reports 2008)

Issue:Unable to replicate Bex Report layout in Crystal Reports
Layout templae in Bex as below

==================================================
Country Name|State Name|City Name|Warehouse|Sales_Qty|SalesPrice

united states AAAAA Newyork UTN001 20 3000
united states AAAAA Newyork UTN002 30 3000

united states AAAAA Losvegas UTN003 40 4000
united states AAAAA Losvegas UTN004 50 5000

whne data is grouped it is visible in BEX AS WHICH CAN BE USED FOR
PIVOT

==================================================
Country Name|State NAme||Sales Qty|Sales price

United states AAAAA 20 2000
30 3000
40 4000
50 5000
==============
140 14000
===============

If above layout to be replicated in crystal laoyout will be as below which will not allow us to PIVOT the data

===========
Country Name

United States

State NAme

AAAAA 20 2000
30 3000
---------------------------------------------------------------------------------BBBBB 40 4000
50 5000
==============
140 14000
===============

Issue comparision

Bex report displayed groued data in single line which alows PIVOT
CRYSTAL displyas groued data in mulitple lines with spaces which doesnt
allows pivot

Expected Solution

is there any way that we can display grouped data in single line
and PIVOT can be done in CRYSTAL Reports

Please share your ideas on this!

Thx
bose

crystalrepxi (BOB member since 2010-09-02)

2

Yes. Suppress the group headers and footers and put all of your fields in the Details section in the format you want.

-Dell

hilfy :us: (BOB member since 2007-04-16)