Skip to Content
avatar image
Former Member

How to show n number of data in dynamic columns with dynamic rows in crystal report

Hello,

I wonder if there's a way to show n number of data from data table rows in crystal report in three columns and multiple rows. Say if the datatable has 8 rows, it should display in crystal report as:


1st row data -> in 1st row 1st col in crystal report

2nd row data -> in 1st row 2nd col

3rd row data -> in 1st row 3rd col

4th row data -> in 2nd row 1st col

5th row data -> in 2nd row 2nd col

..

...


8th row data -> in 3rd row 2nd col

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 16, 2015 at 07:53 AM

    Hi Vikas,

    Create a New Report as a "Mail Label" and place the required fields.

    And Adjust the Label Size to required width and Gap between labels. Usually, u can print 3-4 columns in one page.

    and select printing direction is "Across then Down'.

    --Praveen G

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 01:37 PM

    How are your SQL skills?  I've been able to do things like this by writing a (fairly complex) Command (SQL Select statement) that will pivot the data into the format you're looking for.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded