Subreport + Group + New Page before + Blank page

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
MerionAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
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
 
MerionAuthor Commented:
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
 
mlmccCommented:
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.

 
MerionAuthor Commented:
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
 
MerionAuthor Commented:
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
 
mlmccCommented:
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
 
MerionAuthor Commented:
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
 
mlmccCommented:
Not sure.  I would probably need to see the report.

mlmcc
0
 
MerionAuthor Commented:
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
 
mlmccCommented:
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
 
MerionAuthor Commented:
0
 
mlmccCommented:
Check the formulas I added.

mlmcc
sample.txt
0
 
MerionAuthor Commented:
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
 
mlmccCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.