Skip to Content
0

transpose a column representing a structure in Crystal Reports 2013 imported from a bex query

Feb 22, 2017 at 12:42 PM

37

avatar image
Former Member

Hi experts,

I´m new to Crystal Reports 2013.

I try to build a CR which shall base on a bex query.

All Characteristics of the bex query have been imported properly to the CR.

The Structure which is represented in a Column within the bex query has been imported as a single field into CR and it is displayed there as a single colum including several key figures as shown below:

Structure:

Current Period

Last Period

Current Periode vs. Last Periode

etc.

I want this structure/Key figures to be reppresented as Header of my CR:

Current Period | Last Period | Current Periode vs. Last Periode

I would be grateful if you could help me on this.

Many thanks in advance

DSDS

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Abhilash Kumar
Feb 22, 2017 at 01:04 PM
0

Hi Dris,

Insert a Crosstab.

Use the column from the BEx query as the 'Column' in the crosstab.

Format the crosstab to suppress the 'Total' text and you can also take out the GridLines etc from the Customize style tab.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 22, 2017 at 04:06 PM
0

Hi Abhilash,

many thanks for your quick reply.

I appreciate your help, but I prefer to solve it via formula, could you help on that?

BR

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Feb 22, 2017 at 05:04 PM
0

You'd need a formula for each column. You'd also need to know how many rows there are beforehand.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 22, 2017 at 10:28 PM
0

could you please give me an example for the formula "Last Year Cumulated" for the month "March" using three rows A/B/C and the characteristics FinancialYear & ReportingPeriod?

Thanks

Share
10 |10000 characters needed characters left characters exceeded