Removing all page breaks from a Crystal Reports 2016 v14 - Excel export

0 votes
Since I last used Crystal, I have had a client who had a lovely report (with page breaks in all the right places). They really want to export the report to one large Excel file, however, there is a difficulty with that.

We have it set up so that the page header only exports once, but we are unable to prevent recurring group headers from occurring when it seems Crystal thinks the output data should be "page broken."

I can't seem to find a way to "ignore page breaks" in the Excel export or on the detail or page sections. Is there any way to do this?
Nov 15 in Others by Kithuzzz
• 20,660 points
33 views

1 answer to this question.

0 votes
Try ExportFormatType.ExcelRecord instead of ExportFormatType.Excel. It will not be formatted after that.
answered Nov 15 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10 in Others by gaurav
• 22,040 points
274 views
0 votes
1 answer

Generate a flat list of all excel cell formulas

Hello, you'll have to follow certain steps ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
73 views
0 votes
0 answers

How to drop all tables from a database with one SQL query?

What if we don't want to type ...READ MORE

May 28 in Others by Sohail
• 2,960 points
45 views
0 votes
0 answers

How to drop all tables from a database with one SQL query?

drop all tables without typing name. Is ...READ MORE

Jun 7 in Others by polo
• 1,480 points
39 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
449 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
394 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,365 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
2,816 views
0 votes
1 answer

Removing duplicates from Excel rows by adding values of some columns

Copy the first three columns to another ...READ MORE

answered Sep 23 in Others by narikkadan
• 37,660 points
48 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP