Recently, I came across a problem in Crystal Reports. I wanted to display a separate page header on the first page of the report than the rest of the page. On first page of the report, I wanted to display a big company logo with some instructions on it and on rest of the pages; I wanted to display a small company logo.
You can achieve this by adding two page headers sections to the report and adding a formula for suppressing the section. I created two page header sections and formatted them the way I wanted on my first page and rest of the pages. The idea is you want to suppress the second header on the first page and suppress first header on the rest of the pages.
To do so, you create a formula (see X-2) for Suppress option. The formula is: PageNumber<>1. For rest of the pages, you create formula PageNumber = 1.
That's all.

HarmeetPosted Mar 16, 2012, 10:36 AM
Recently i am in problem. i want to print reports in one page two records like Origanal and duplicate. Please help me
komila sachdevaPosted Jan 30, 2009, 12:44 AM
can u pl tell me how to put a formulae on section wise. i mean i dont want my page header on report footer so how to write that...
VikasPosted Aug 20, 2007, 5:15 AM
Hi Mahesh, Its for an Invoice Report. I am having a list of values which are directly fetched from a table. There is a column named 'Type' which will be having values 'Gas' and 'Water'. It is having another column named 'values' which will list all values. Based on the 'Type' we will be displaying 'values'. Gas values will be displayed in Gas Details section and water values will be displayed in Water Details Section Q1: My requirement is to display like this Gas heading Gas details Water heading Water details Q2: Also i need to display only if there are datas in the table. But now even though if there are no datas its displaying o.oo by default. This is the code that I have used. Ex of the code used: If Isnull({RptInvoiceSub.Type}) <> True then IF {RptInvoiceSub.Type} LIKE 'GasCharges' THEN {RptInvoiceSub.value}
waya thPosted Jul 25, 2007, 3:36 AM
test