Switch layout of Data

building reports crystal reports
1

Greetings all,

Brand new to CR and have been requested to do the following and I don’t have the slightest idea.

Data returned natively in the following format:
Org1|Team1|Member Title|Member Name

Output desired is something like a cross-tab:
___________Member Title X |Member Title Y |Member Title Z
Org1|Team1|Member Name1|----(blank)------|Member Name2
Org1|Team2|Member Name2|Member Name1|------(blank)----

What I’m trying to do here is layout the data where the different team members are laid out in rows and their titles are the corresponding row headers.

However, using cross tabs, I get the layout, but all I can find is it summarizes the team members and basically gives me a count of all of the team members for each title.

I don’t think cross tabs are how I want to do this, but I’m ignorant on the CR language.

Any guidance would be appreciated.

Thanks!

BusObjectsUser1968 :us: (BOB member since 2009-04-20)

2

In the Cross Tab, use the Member Name as the Summarized Field and set the Summary to “Maximum”. This should give you the text of the Member Names instead of a count of them. However, this will only work if there is only one member name for each title.

-Dell

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

3

Dell,

I think I understand what you are saying. I’ll give it a try tomorrow and post back on success or if my ignorance needs additional guidance.

Thanks for the suggestion!

BusObjectsUser1968 :us: (BOB member since 2009-04-20)

4

Thanks for the help.

That got it done.

BusObjectsUser1968 :us: (BOB member since 2009-04-20)