Crystal Report with SubReport, SubReport prints on separate page

Tim Frawley

I have created a Crystal Report with five subreports to represent
datagrids on our dataentry application. The largest datagrid is the
last item on the report. When empty this last subreport will print on
page one of the report about halfway down the page.

The problem is when this subreport has more than 50 rows it grows off
the page. Not a problem as it will print all the pages necessary for
this subreport but it starts the report on page two rather than page
one leaving about half of page one blank.

I have just created this report today and all of the report options
are still default as I am not sure which option would resolve this
issue. Each sub report is in a separate section with this last
subreport being in the 'Details e' section. There is no 'Details f'
section.

Does anyone have an idea on what I can do?

Nov 20 '05 #1

Subscribe Reply

8616

Bernie Yaeger

Hi Tim,

I have run into the same problem. Here are a few suggestions:
1. go to section expert and make sure all of the sections have 'suppress
blank' section checked
2. make sure all sections do not have 'new page after' (except the last, if
appropriate)
3. make sure the section in question does not have 'new page before'
4. lastly, you may have to contact Crystal Decisions about it - my guess is
that version 9 is a bit buggy in some areas, especially this area (I assume
you're using version 9)

My guess is all of this is ok, as it was with my system. I ended up having
to tweak the thing in several ways before I could get it to behave - and
even then, when my 'large' section gets too large, I have a problem still.

HTH,

Bernie Yaeger

"Tim Frawley" <ti*********@fi shgame.state.ak .us> wrote in message
news:bf******** *************** *@posting.googl e.com...

I have created a Crystal Report with five subreports to represent
datagrids on our dataentry application. The largest datagrid is the
last item on the report. When empty this last subreport will print on
page one of the report about halfway down the page.

The problem is when this subreport has more than 50 rows it grows off
the page. Not a problem as it will print all the pages necessary for
this subreport but it starts the report on page two rather than page
one leaving about half of page one blank.

I have just created this report today and all of the report options
are still default as I am not sure which option would resolve this
issue. Each sub report is in a separate section with this last
subreport being in the 'Details e' section. There is no 'Details f'
section.

Does anyone have an idea on what I can do?

Nov 20 '05 #2

Similar topics

760

Crystal Reports

by: Tim Burda | last post by:

I posted this in another forum, but I'm adding it here to for more exposure.I am using Visual Studio 2003 and trying to get Crystal Reports to produce output. If you have any ideas, please let me know. This is a common problem, but nobody seems to have an answer for it. CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed. What does that mean, specifically? What logon is failing?

.NET Framework

12151

Format event of a report's section

by: Melissa | last post by:

What specifically causes the Format event of a report's section to fire? Thanks! Melissa

Microsoft Access / VBA

3776

Make Subreport Function Like Main Report

by: shaqattack1992-newsgroups | last post by:

I know this is kind of a weird question, but is there anyway to give a subreport control of a main report? I posted my situation earlier about having drawings print out after a group. I have a report grouped by part group that lists the part numbers needed from that group. I have force new page after each group. This gives me a list of parts on each page. I want to print the needed drawings after the groups/list of parts. There are...

Microsoft Access / VBA

3941

How to export Subreport Data in Crystal report

by: John | last post by:

Hi. Sir: Does anyboday know how to export subreport data using the export button in crystal report tool bar? We have a main report including a on-demand report. When we click the on-demand button, the page show the subreport detail, that's fine. but when i click the export button on crystal report tool bar, the page automatically go to the main report and export main report. Does anybod know how to do that?

C# / C Sharp

1460

crystal reports and duplicate pages

by: cb2000 | last post by:

not sure if this is the right area, but let me know if it isn't I have a simple crystal report that has a subreport in it. the problem is, when I go to print it every page comes out in duplicate. I am exporting the report to PDF. when I take the subreport out, the report prints fine. the subreport is a simple listing of 2 or 3 lines for each page. any ideas?

ASP.NET

12917

Crystal report with stored procedure in subreport

by: kenneth xg | last post by:

Hi, I have problem on passing parameters to subreports' stored procedures which require parameters, from an asp.net web form. I ve tried to use the stored procedures on the main report it works fine, however once the stored procedures were put into a subreport, it cause an exception: "Missing parameter field current value"

ASP.NET

2151

Crystal Report Problem

by: Nadia Daems via .NET 247 | last post by:

I desingned a report with several subreports to use in my application. Normally each subreport have to start on a new page. I did this by making a diffrent section for each subreport and selecting the option "New page before" for each section. When a subreport is blank, both the subreport and the section are suppressed but the new page isn't, so there are empty pages in my report. Because the reportheaders of the subreports are suppressed,...

Visual Basic .NET

1562

Need help with Crystal Reports .NET report design

by: retrorocket | last post by:

I've searched and searched, I could really use some suggestions. I have a Crystal Report in report designer that contains a Report Header, a Page Header, and a Detail section. The first page should print three records from the Detail section and then be followed by signature box (plain text, contains no data). If there are more than 3 records in detail, then the next pages should continue showing records but not the signature box. This...

.NET Framework

2871

Crystal Subreports

by: Franck | last post by:

Ok i have a problem. What do i need to change to make crystal show subreport within subreports ? So i have 3 layer The MainReport Multiple SubReport Attached in the MainReport Multiple SubSubReport Attached in the SubReports Showing the SubReport itself by bypassing the MainReport the SubSubREport are showing

C# / C Sharp

9589

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9994

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9863

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8872

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7409

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6673

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

3959

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3562

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2815

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General