on 10-16-2015 7:24 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Or Open the report in Crystal Report.
Right Click Details -> "Section Export" -> Check "Format with Multiple Columns".
New tab by name "Layout" will be added on the top. Select that tab.
There specify the Width , Horizontal & Vertical Gap and than select "Accross then Down" or "Down then Accross" as per your need.
--Praveen G
Thank you sir.
Your both the solutions worked well to achieve the layout I was looking for, but it also introduced me an other issue.
I didn't mentioned in my previous query but I'm also required to insert one more detail section (Details b) in default layout, right below this column layout detail section (Details a). But now I'm unable to add this in default layout (single column), "details b" automatically get the same layout as "details a".
Please suggest a solution for this.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.