Crystal reports 2005 Suppressing page headers when there is a subreport (in the report footer)
-
Here is what i have spent the past day banging my head against. I have a report with page headers and in the report footer i display two subreports and i need to suppress the page header when the subreports are displayed. From what i understand i need to write a formatting formula but i have no idea what this formula is or what it looks like I am very new to Crystal reports. Any help will be appreciated Thanks in advance Colwin
-
Here is what i have spent the past day banging my head against. I have a report with page headers and in the report footer i display two subreports and i need to suppress the page header when the subreports are displayed. From what i understand i need to write a formatting formula but i have no idea what this formula is or what it looks like I am very new to Crystal reports. Any help will be appreciated Thanks in advance Colwin
Be glad to know that in other places in the world people are banging their head to!!! I need CR to end my applicaton, if i was more than a begginer in CR i would be glad to help you there. Good Luck X|
nelsonpaixao@yahoo.com.br trying to help & get help
-
Here is what i have spent the past day banging my head against. I have a report with page headers and in the report footer i display two subreports and i need to suppress the page header when the subreports are displayed. From what i understand i need to write a formatting formula but i have no idea what this formula is or what it looks like I am very new to Crystal reports. Any help will be appreciated Thanks in advance Colwin
Create a Formula and place it in a blank and suppressed section before your sub-report, force new page after this section as well === Formula SuppressHeader
WhilePrintingRecords; BooleanVar SupressStuff; SupressStuff:= trueCreate another Formula and place it after your sub report within a blank suppressed section === Formula SuppressHeaderNOTWhilePrintingRecords; BooleanVar SupressStuff; SupressStuff:= falseCreate a Third Formula which will give the value SupressStuff to other formula (this sounds weird but bear with me). Place a copy of this in the report header as well. == Formula SuppressStuffDisplayWhilePrintingRecords; BooleanVar SupressStuff;Now in your Header and Footer Sections go into Section Expert and click the formula box at Suppress (No Drill-Down) and place the third formula in the@SuppressStuffDisplayor if you want to be fancy use this which does the same thingif @SuppressStuffDisplay= true then true else falseHow this works; simple answer is flow control. Crystal runs from Top to Botton and runs in a flow. So it always does the stuff before it does the current stuff. Event fire as well like new page and page headers etc.. So before it gets to the subreport it set the value of SupressStuff to false which then suppressed any headers and footers. Then after the subreport it sets SupressStuff to true which allow headers and footers to be printed easy eh ?DEVELOPER DAY SCOTLAND 2009 Watch this space http://www.developerdayscotland.com/[^]
-
Here is what i have spent the past day banging my head against. I have a report with page headers and in the report footer i display two subreports and i need to suppress the page header when the subreports are displayed. From what i understand i need to write a formatting formula but i have no idea what this formula is or what it looks like I am very new to Crystal reports. Any help will be appreciated Thanks in advance Colwin
In your main report, go to Section Expert and find the properties of the Report Footer. Select the "New Page Before" option for the footer section. This will force a new page to be printed right before your embedded sub-report. I've used this method and it works fine. Your sub-report will not have the page header or footer from the main report. Give it a try.