Shamanth
asked on
Border on first and last record
How do I conditionally control the cell borders. I added borders to the cells in Details section. Lines and text boxes are not exporting to excel. That is why I am adding borders to the cells.There are somany records in the details sections. I don't want to show lines after every record. I want to show lines on top and bottom of the section. So, I want to have border on top of the first record and the bottom of the last record. Is it possible?
ASKER
Is there any way I can format the Border Properties (There is a formula in border properties)
When I put 'not onfirstrecord' in the border properties, it returns a syntax error.
When I put 'not onfirstrecord' in the border properties, it returns a syntax error.
ASKER
I am getting line breaks on the left border if I use onfirstrecord. I am also using the lest margin. I am looking for a box kind of formula using borders
ASKER
Borders are also not working" if onlastrecord" if there are any nulls
ASKER
If onlastRecord then crSingleLine else crNoLine
Above is the formula I am using in the bottom border. Bu two fields in the last record are nulls and the borders are not displaying for those two fields. Please help!
Above is the formula I am using in the bottom border. Bu two fields in the last record are nulls and the borders are not displaying for those two fields. Please help!
you should be putting these suppression formulas in the SUPPRESS formula in the SECTION EXPERT for the section that the line exists in. this is why i suggested that you put the line in its own section.
however, it sounds like you came up with a solution in your last comment.
if you have two nulls as your last records, put in an exclusion to ignore null.
if onlastrecord and not isnull({fieldname}) then ....
however, it sounds like you came up with a solution in your last comment.
if you have two nulls as your last records, put in an exclusion to ignore null.
if onlastrecord and not isnull({fieldname}) then ....
ASKER
This" if onlastrecord and not isnull({fieldname}) then .... still gives me blank border."
Where is the option to cotrol borders in section expert?
If I use formulas like 'if onlastRecord..' in section expert it gives me an error message saying that the formula must be boolean.
Where is the option to cotrol borders in section expert?
If I use formulas like 'if onlastRecord..' in section expert it gives me an error message saying that the formula must be boolean.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I set the default report options. But still I am getting nulls. The fields ar Employee Name and Address.
Thanks much to you all for your help!
Thanks much to you all for your help!
ASKER
I used isnull in the formula for the fields. But still I see blanks for those fields on the report. That means they are not nulls? How do I handle blank fields?!!
What do you mean?
Do blanks not get the border?
mlmcc
Do blanks not get the border?
mlmcc
ASKER
Yes. Blanks don't get the border. The workaround is using instr(). I found the solution online. I think they are just blank spaces.
Thanks all for your contribution.
Thanks all for your contribution.
ASKER
Thanks
for the top line, the formula should be: not onfirstrecord
for the bottom line, the formula should be: not onlastrecord
make sure the line sections are at the top and bottom of the details.
Top Line section
Record Details
Botton Line section
another way to do this is to create a group on a field that only happens once in your record set. then create a new section for each line at the group level. you won't need the suppression formulas if you do it this way.