Avatar of TechGuru2009
TechGuru2009 asked on

Multiple Column Report in Crystal Report 2008

Is it possible to generate multicolumn report where there will be only two columns in the report not more than two. I know in detail section you can select "Multiple Column" option but this will allow to extend more than 2 columns. I also need group by year 2008, 2007. So that for each year I will get the report as per the attached format. The report structure looks like as attached.
Picture-7.png
Crystal Reports

Avatar of undefined
Last Comment
Mike McCracken

8/22/2022 - Mon
Mike McCracken

When you click the MULTIPLE COLUMN option in the section expert a new tab appears.
You use that tab to set the number of columns through the column size.  Just clicking that option leaves the report as 1 column.

Crystal has the option for across then down or down then across.
Yours looks like down then across but Crystal won't move to the next column until the page is full.  With that in mind a report as pictured really can't be done with multiple column option.

It might be easier to use 2 subureports.  One for each column

mlmcc
ASKER
TechGuru2009

Hi mlmcc

Thanks for your time. If I create two subreport then is it not going to override each other. Can you please elaborate using two subreport option to create two column report.
ASKER CERTIFIED SOLUTION
Mike McCracken

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
TechGuru2009

Thanks mlmcc

One issue though is how the group by works. I mean if I export the report to PDF then because this is a subreport so the bookmark will not be generated for 2009, 2008, 2007 etc. And in main report I won't be able to bookmark the subreport content. Any suggestion to resolve the same.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Mike McCracken

To get the years, group the main report by the year then use the subreports in the group.

mlmcc
ASKER
TechGuru2009

Thanks. Is it going to work when the report is exported to PDF and user clicks on year 2009 is he going to see all details as per the subreport and if user changes to 2008 similar details are being displayed. Do I have to group by year as well in subreport to show the same?
Mike McCracken

The drill down feature doesn't export.

mlmcc
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
TechGuru2009

Then is there workaround to have the feature implemented in above scenario.
Mike McCracken

What, to be able to drill in when you export or to open all the subreports amnd export then?

mlmcc
ASKER
TechGuru2009

Yes, to be able to drill in when you export to PDF which will include each subreport for a year.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Mike McCracken

I don't think that is possible.

mlmcc