Solved

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

Posted on 2004-04-27
4
1,225 Views
Last Modified: 2010-08-05
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
Comment
Question by:reeyag
  • 2
4 Comments
 
LVL 8

Expert Comment

by:annamalai77
ID: 10927209
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
 

Author Comment

by:reeyag
ID: 10935845
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
 
LVL 10

Accepted Solution

by:
imrancs earned 50 total points
ID: 10936134
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
 
LVL 8

Expert Comment

by:annamalai77
ID: 10955355
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

813 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now