Print Page | Close Window

Discrepancy between the reports

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=129
Printed Date: 19 May 2024 at 8:27am


Topic: Discrepancy between the reports
Posted By: abhi81
Subject: Discrepancy between the reports
Date Posted: 17 Jan 2007 at 7:03am
Hello,
My report has a page header b section which i am using to display the headers for the detail section if it is page 2 or more. I also have 2 subreports on which i want to suppress it that comes at the end of the report.
 
I am using the formula described below for suppressing the section. This works as desired in the CR viewer without any code but when i fire the report using an ASP page passing the order nums required the suppression formula fails and it prints it on every page except the fist page.
 
Please advise.
 
if (not isnull({ReportView1.HasPers})) and (isnull({ReportView1.internalcomments}) or {ReportView1.internalcomments}="") then
 if pagenumber=1 or pagenumber=totalpagecount then
  true
 else
  defaultattribute
else if (not isnull({ReportView1.HasPers})) and (not isnull({ReportView1.internalcomments}) or {ReportView1.internalcomments}<>"" )then
   if pagenumber=1 or pagenumber=totalpagecount or pagenumber=totalpagecount-1 then
      true
    else
       defaultattribute
else if isnull({ReportView1.HasPers})and (isnull({ReportView1.internalcomments}) or {ReportView1.internalcomments}<>"" )then
 if (pagenumber=1) then// or (pagenumber <>1 and pagenumber <= totalpagecount) then
  true
 else
  defaultattribute
else if isnull({ReportView1.HasPers})and (not isnull({ReportView1.internalcomments}) or {ReportView1.internalcomments}<>"" )then
    if pagenumber=1 or pagenumber=totalpagecount or pagenumber=totalpagecount-1 then
        true
   else
        defaultattribute



Print Page | Close Window