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
Picture-7.png
Last Comment
ASKER
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.
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.
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.
To get the years, group the main report by the year then use the subreports in the group.
mlmcc
mlmcc
ASKER
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?
The drill down feature doesn't export.
mlmcc
mlmcc
ASKER
Then is there workaround to have the feature implemented in above scenario.
What, to be able to drill in when you export or to open all the subreports amnd export then?
mlmcc
mlmcc
ASKER
Yes, to be able to drill in when you export to PDF which will include each subreport for a year.
I don't think that is possible.
mlmcc
mlmcc
Crystal Reports
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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