?
Solved

Subreport + Group + New Page before + Blank page

Posted on 2008-11-17
14
Medium Priority
?
2,184 Views
Last Modified: 2012-05-05
I'm using Crystal Report version XI.

I have a report containing a subreport. in a group Header section.

Subreport has ID as group in it - first group has 'New Page Before' option checked. now, subreport itself is working properly by itself. (Means showing each new ID on new page) but it leaves first page black if I run it with original report which contains that subreport.

How can I resolve this problem ?

Thanks
0
Comment
Question by:Merion
  • 7
  • 7
14 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 22979750
Instead of using NEW PAGE BEFORE
Uncheck the NEW PAGE BEFORE
Click the FORMULA BUTTON to the right of NEW PAGE BEFORE
Use this as the formula
Not OnFirstRecord

mlmcc
0
 

Author Comment

by:Merion
ID: 22980336
Thanks, It is not atleast showing blank page!
I have some questions:
- from where can I read about such options more? is it covered under Formula topic?
- Still the Page Title of subreport is not repeating on each page.
and
- I have two subreports in container report so, can I give page number in continuous sequence?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 22981090
Second on rfirst.
Page numbering is controlled in the main report.
You should be able to put the page numbers in the main report page footer and they will work correctly.

mlmcc
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 

Author Closing Comment

by:Merion
ID: 31517601
I understood your first answer which solved my initial problem but didn't understood second answer! for which i am going to post another comment. Thanks again!
0
 

Author Comment

by:Merion
ID: 22987640
what do I have to do with 'Second on rfirst'?

Let me explain my Problem again
There is a blank report which has two subreports in Page headers. Both subreport has page title on page header section. Which works well if I run individual report but not in above scenario. Title is there on very first page of each subreport whare as it should be there on each page.
Can you give any solution on it?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 22988736
Meant second question first

Subreports don't have page headers or footers.
Page headers and footers are controlled by the main report.

There is a trick to getting them in a subreport
https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10bb8295-a375-2b10-788c-cce7eee0f43a

mlmcc
0
 

Author Comment

by:Merion
ID: 22998560
Great! It works.
but 'Not OnFirstRecord' formula didn't work for second group. It prints first group name & page is blank. this happen before starting of each new record of 2nd group.

Thanks.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 22999476
Not sure.  I would probably need to see the report.

mlmcc
0
 

Author Comment

by:Merion
ID: 22999791
Site is not allowing to attach .rpt file. Let me explain...
It happen with very basic report also. A report with 2 groups, first group has 'New page before' unchecked but 'not onFirstrecord' formula applied on it, second has same settings as first.
Result is on 1st page: 1st group's name only
2nd page starts with first record of second group
where it should print: 1st page - a record of 1st group then 1st record of 2nd group
2nd page - 2nd record of 2nd group.

I appreciate your help!











0
 
LVL 101

Expert Comment

by:mlmcc
ID: 23000231
Make a copy and change the extension to TXT.

Or use

www.ee-stuff.com
You can log in using your EE name and password.

mlmcc
0
 

Author Comment

by:Merion
ID: 23000983
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 23001463
Check the formulas I added.

mlmcc
sample.txt
0
 

Author Comment

by:Merion
ID: 23008581
Wonderful, it works for me...that would be very helpfull if you can explain which formula is doing what?
I Thank you very much for your help...how can I Accept last Solution also?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 23010210
You closed it earlier so there is nothing to do.

Basically all the formulas are doing is to toggle a variable.  When the group A is printed the variable gets change to true so there won't be another new page.
The one in the group2 header toggles it back to false so if there is another group2 then you will get the new page.

The variable is used in the suppressiion formula to test if the group1 header is on the page.

mlmcc
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question