Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Feb 22, 2017 at 01:04 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 22, 2017 at 04:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 22, 2017 at 05:04 PM

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

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 22, 2017 at 10:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded