How display greybar color effects?

Posted on 2001-07-09
Medium Priority
Last Modified: 2011-09-20
Basics:  Crystal Reports 8.0

Question:  How do I print a background color (Silver) on every other line on a report?  I want to make it easier for the user to read long and wide reports that contain a lot of numbers.  

There is a type of paper called greybar or greenbar that is preprinted with grey or green lines for dot-matrix printers but that is normally not available for laser jet type printers.  So I want to just print a grey (silver) background color on every other line of the report thus achieving the same effect.

Normally to accomplish this I edit the detail section to conditionally print the grey background color if the record number being printed is an even number.  But in this case, there may or may not be group headers and/or footers.  Thus to show a uniform look on each page, I want to print the background grey on every other line regardless of the number of detail lines and headers/footers.

Any ideas?  Thanks.
Question by:EYoung
LVL 12

Accepted Solution

DRRYAN3 earned 200 total points
ID: 6267286

Remember that you are not printing "lines" of text.  You are rendering a graphic and have to track "lines" in this case yourself.  I would suggest a report variable you reset at each page break and increment with each printed line by putting a dummy field at the end of each possible printed line, either header, footer or detail.  If the contents of the formula that increments the counter produces a space character on each possible line, you should be able to check that counter to see if you should apply the color effect.  You will have to exercise restraint in your choice of fonts - use only one with one size throughout or your effect will not look good.

Author Comment

ID: 6267300
Thanks.  That works.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment. Powered …
Suggested Courses

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question