Link to home
Get AccessLog in
Avatar of MKItani
MKItani

asked on

suppress subrepot+crystal bundled vs 2008+window application

Hi All,
I have a report call another subreport s follows:

Page Header

Group Header
Detail
Group Footer
Subreport

in case the subreport doesn't have a records i want to suppress the subreport or the group footer that involves the subreport how i can do it?

Regards,
Avatar of PANkaj Kumar
PANkaj Kumar
Flag of India image

Dear,

simply put your sub report by default size( don't re-size sub report) and remove all unwanted space.
Avatar of Mike McCracken
Mike McCracken

If there are no records you need to make sure the subreport doesn't display anything like header text.

You can conditionally suppress all sections of the subreport with

Count({SomeField}) = 0

You can then format the subreport
On the last tab there is an option to SUPPRESS BLANK SUBREPORT

You can then suppress the section it is in with
SUPPRESS BLANK SECTION in the Section Expert.

mlmcc
Avatar of MKItani

ASKER

t U mlmcc i did what you wrote above but i still have a problem because in the section group footer i have the option "new page Before" so i still show a blank page.
what is your suggestion?
what i think about is to add a condition formula to the "new page Before" so in case is suppress so we don't add a new page.
but how i can write this formula?

Regards,
I don't think there is a formula to control that because the NEW PAGE BEFORE is done before the section is built.  Is there another section with a NEW PAGE BEFORE?

mlmcc
Avatar of MKItani

ASKER

T U mlmcc,
look group footer is devised in two sections footer a and footer b and the sub-report is inserted in the second b, and i don't have any problem if you want to set the "NEW PAGE BEFORE" in any section you want but i want to get the desired result.

regards.
I was asking is there another section that haas NEW PAGE BEFORE set because if you have 2 of them you might get the blank page

GH1 - New Page Bfore
Details
GF1 - New Page Before with subreport

If no records in the subreport you are still at the top of the page and when the next group is done you get a New Page again thus a blank page.

Try this
Put the New Page Before on the Subreport report header or detail section

mlmcc
Avatar of MKItani

ASKER

t U a lot mlmcc,

the hierarchy of the report is as follow:

Page Header

Group Header
Detail
Group Footer a
Group Footer b
Subreport

no i don't have a new page before in another section and in case i suppress the group footer section at design time i don't get a blank page so the problem is he execute the "new page before" in the section footer before to suppress the sub-report so for this reason i ask you how i can set a formula to "new page before" in case the section isn't suppressed?

In case i put the "new page before "in page header of the subreport instead of the group footer of the main report, it doesn't work.

regards
Avatar of MKItani

ASKER

also i have removed "new page before" from the group footer section of the main report and also in case the main report involved records and the sub-reports doesn't involved records i show a blank page so maybe the option "suppress blank section" doesn't work in case there is a sub-report because in the format object of the sub report i set "suppress blank section".

regards,
Can you upload the report?

mlmcc
Avatar of MKItani

ASKER

T U mlmcc,

Please find the attachment file.

regards,
VendorStatementAccountsReport.rpt
I don't particularly see anything wrong.  The subreport GF1 wasn't suppressed so I suppressed it.

I changed the NEW PAGE BEFORE to check for > 0 records

mlmcc
VendorStatementAccountsReportRev.rpt
Avatar of MKItani

ASKER

T U mlmcc,
where i can found the change:
I changed the NEW PAGE BEFORE to check for > 0 records

regards,
In the subreport GH3

mlmcc
Avatar of MKItani

ASKER

i am still wainting for an accurate answer for my question:
"in case the subreport doesn't have a records i want to suppress the subreport or the group footer that involves the subreport how i can do it?"
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of MKItani

ASKER

yes i will try it TU.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.