Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1252
  • Last Modified:

Reports 6i Repeating Frame-How to draw a line after?

I have a repeating frame inside a main frame. This repeating frame is made to print three records maximum exactly in one page. I want to do the following. When the number of records is less than three, then instead of printing white space below, I want to repeat the column headings alone (of course with or without data as the case may be for three times always, so that always placeholders for three records are available). So also, if the number of records is less than three, then I want to put a cross (score out) these empty cells with a slanting line in order to indicate that the rest of the records are not filled. Thus this slanting line should expand if the number of records is less in order to occupy the space below. FYI, I have some fields of the main parent frame below this repeating frame like footer note. I need your help.
0
reeyag
Asked:
reeyag
  • 2
1 Solution
 
annamalai77Commented:
hi there

for the first case where u want to print the heading

check the outer frames properties. in that u have conditional formatting. double click on that and check whether the hide the object check box is clicked . if so then uncheck it and try running the report.

regards
annamalai
0
 
reeyagAuthor Commented:
Thank you. I have not used any conditional formatting. Only if there is a condition, then this hide object option comes. I have a maximum of 3 records to be printed per page and if the number of records is less than three, then also, I should display 3 always (of course only the headings of the fields(record header) for the rest), with a slanting line across the record headers without data so that no one can tamper with it. Can you help me out?
0
 
imrancsCommented:
put 2 record headers there on the report manually and position then accordingly, and then in conditional formatting check
if there are 2 records then supress the 2nd
if there are >=3 records then supress both 2nd and 3rd



Imran
0
 
annamalai77Commented:
well then reeyag

u have conditional formatting for all the fields and if the data is null then u can put slash

or otherwise have another frame where u check the count of records and store in a formula column. print the frame if the formula column returns 0 otherwise hide the object that should solve ur problem.

regards
annamalai
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now