Column layout detail section and normal row layout detail section in Crystal Report

Sailee Govekar
Sailee Govekar used Ask the Experts™
on
Hi,

I want to achieve a row layout detail section and at the same time column layout detail section.

For example, I want my detail section a to detail section f as normal Row Layout detail section.
Similarly, detail section g should be Column layout detail section.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Hi,
Is this in Crystal Reports or Business Objects?
Can you give an example with sample data?
If you want this in Crystal Reports, then, If the details for row data and column data are not related, then you can try using row layout by details sections and using a sub report for column layout. But it depends on your data.

Author

Commented:
For better understanding.. Refer attached image
Report5.jpg

Author

Commented:
It is Crystal report and not Business objects.
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

Commented:
Frankly speaking, I never used this "Format with multiple Columns". I just tried it today. Can you explain what's your requirement or change with regards to the screenshot you shared?
If it's like parent child kind of information, then I would suggest you to use normal parent information in your A 2 J Sections and use a sub report for child data under K section. Correct me if I am wrong.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Your image of details a to j is that one detail record being displayed?
Are there multiple images for each detail record?

Remember you get 1 detail section for each record in the database.
Also I just checked.  The whole detail section is formatted with multiple columns.  You can't do it on multiple columns on a sub-detail section

mlmcc

Author

Commented:
Hi Raghvendra and mlmcc,

The format of the report I am trying is For Example,
I have one group named as Product Code from "Stored Procedure 1".
In it I have two detail sections (Detail Section A and Detail Section B)
I have a list of data which is to be displayed in "Detail section A" in the row layout format from "Stored Procedure 2".
  Example,
    Product Name         Product Color      Quanity
    Cotton                 pink                      10
Again I have a list of data which is to be displayed in "Detail Section B" in the column layout from "Stored Procedure 3".
  Example,
    Multiple images in column format property option.
Then the Product Code Group footer.
Commented:
Hi,

As mlmcc confirmed, the detail section b can have multiple images for each Product Name as long as those images are not part of a single column. I mean, for e.g. you can display 5 different images, if those are from different database columns.

If the images are from same column, say for Product Name Cotton with Product ID XYZ there are 5 images under a different table (or even same table) having same Product ID XYZ, then you can display all those 5 images side by side using a sub report by linking the sub report based on Product ID from your main report.

I hope this helps to decide on your report design.

Author

Commented:
It worked with the help of Subreport.

Thank you so much

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial