Link to home
Start Free TrialLog in
Avatar of Jeff S
Jeff SFlag for United States of America

asked on

Crystal Reports issue - getting blank sheet (While Printing or Reading Records needed?)

I am experiencing and odd issue with Crystal Reports that is difficult to explain at best.

The issue I believe may be the ID I am pulling through my Stored Procedure may not be evaluated until the records are printing or something like that, as I am getting a blank sheet prior to the sheet of records I am pulling.

I have 5 fields I am adding into my Patient Statement. They are custom Patient Aging fields: PatBalance0to60, PatBalance61to90, PatBalance91to120, PatBalace121to180 and PatBal180Plus. I have created a Running Total for each and Summarizing the values, evaluating for each record and resets on change of the GuarantorId. These running totals are also going into my GuarantorId Group Footer. Should I evaluate these while reading or Printing the records? Not sure why I am getting a blank page and its quite maddening! Suggestions, tips to try?
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jeff S

ASKER

mlmcc,

No, I do not have NEW PAGE BEFORE set on the GuarantorId Report header nor in the footer. I do have it set to KEEP TOGETHER on the Footer and in the Footer. The report header does not have NEW PAGE AFTER selected either. Statement-Plain-Paper-FQHC-05162016R.rptStatement-Plain-Paper-FQHC-05162016R.rpt

I truly am stumped on this one. I seem to keep getting one page prior. I have attached the report file to the thread if needed. I changed the font on the fields to red that were added in.
Avatar of Jeff S

ASKER

Found the issue in the stored procedure that pulled in the record set. I changed some of the SQL and it resolved my odd issue. Thanks as always for the look.