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


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.
Sailee GovekarStudentAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raghavendra HullurSoftware DeveloperCommented:
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.
Sailee GovekarStudentAuthor Commented:
For better understanding.. Refer attached image
Sailee GovekarStudentAuthor 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.

Raghavendra HullurSoftware DeveloperCommented:
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 ConsultantCommented:
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

Sailee GovekarStudentAuthor 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".
    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".
    Multiple images in column format property option.
Then the Product Code Group footer.
Raghavendra HullurSoftware DeveloperCommented:

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sailee GovekarStudentAuthor Commented:
It worked with the help of Subreport.

Thank you so much
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SAP Businessobjects

From novice to tech pro — start learning today.