Skip to Content
0
Former Member
May 03, 2014 at 04:42 PM

Rows in view display is less than rows in records

686 Views

Hi Crystal Export:

I need your help since Rows in view display is less than rows in records-
see attached file for my crystal report.

I am using Crystal Developer version 12.3.0.061 on Window 7 operating
system. Product Type Full.

The crystal report has a query which givet 12 rows from MSSQL tool.

Query for this report is dynamic. E.g.. from Menu: Report->Select
Export->Record, I added formula:

if {?DateType} = 'In' then

date({Command.INDATE}) >= Date(2013,4,2) and {Command.INDATE}
<Date(2013,4,3)

else if {?DateType} = 'Issue' then

{Command.ISSUEDATE} >= Date(2013,4,2) and {Command.ISSUEDATE}
<Date(2013,4,3)

else if {?DateType} = 'Expires' then

{Command.EXPIRYDATE} >= Date(2013,4,2) and {Command.EXPIRYDATE}
<Date(2013,4,3)

Note: this is a test formula, the real one will not use hard coded date.

After View->Print View menu item selected, there are 12 Records rows as
expect shown at bottom , however there are only 10 rows in display or report. I
am wondering if it is a bug or I did something wrong.

Your help will be great appreciated.

Jean