Skip to Content

Adding measures to rows in crystal reports 2016

Hi All,

I have below requirement please help me on this. It's very urgent requirement. I want it in Cross tab table.

I'm getting data as first table. But I want to as 2nd table. Please help me

Thanks

Riaz

question-1.jpg (19.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 02, 2017 at 04:26 PM

    Hi Riaz,

    The columns are based on groups so you will have to make a formula that will separate your records into two different categories. Now you can use that formula as your column.

    Good luck,

    Brian

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Brian Dong,

      Thanks for the response. Depends on what do I need to group. These are all measures. I don't have other column. Is there a way to group measures using measures.

      Thanks

      Riaz

  • Jun 05, 2017 at 08:05 AM

    Hi Riaz,

    How are the measures supposed to be categorized?

    Do you have a 'real' data sample please?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 05, 2017 at 11:19 AM

    question-2.jpg

    Above is the file

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Riaz,

      Your questions are not detailed enough. We need more specific details of how you would like your measures grouped or more information on how you data is structured.

      Can you use measures to group? Yes. The question you should be asking is how can you group your measures based on what type of scenario. We can't answer your questions without details.

      In the second screenshot, how would you like to see the data grouped?

      What are the rules to have the different group?

      Unfortunately, you screenshots just show us numbers with no real help.

      Thanks,

      Brian