Conditional top border 1

[CarpalT]

The report has two fields

Description Amount

On the Amount format properties, bottom border is set to

if{Rpt_FinancialStatementOutputSp;1.description} in ["TextVal1","TextVal2"] then crDoubleLine

This works great, but I can't set the top border to single line using the same formula. (It is crSingleLine, right?)
Any suggestions? Thanks in advance!

The world is full of good people.

 

[synapsevampire]

What does "you cannot" mean?

If you get an error, post the formula used and the resultant error.

Try:

if{Rpt_FinancialStatementOutputSp;1.description} in ["TextVal1","TextVal2"] then
crSingleLine

-k

 

[dgillz]

I am getting the same results. No top line, no error, identical formulas.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[CarpalT]

Cannot" means it just doesn't. Here is exactly the formula I am using. All I did was copy the one that works (double line on bottom of field) and change "Double" to "Single".

if{Rpt_FinancialStatementOutputSp;1.description} in ["Total Assets","Total Liabilities and Equity"] then crSingleLine

There is no error message. It provides the double lower border on the field where appropriate, so I know that formula is working. The single top border does not print.
Sorry for being unclear. I knew what I was saying...
Thanks for the quick response.

The world is full of good people.

 

[dgillz]

CarpalT,

I just fixed mine.

Just create a tiny bit of white space in that section of the report, and move your object down a little bit. Its there, its just that you cannot see it from the default placement of the report object.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[CarpalT]

Would it have anything to do with evaluation time? I would think that the value of description is known by the time it hits the top border of the following field...

The world is full of good people.

 

[CarpalT]

Yes, that corrected mine, too. Thank you dgillz for providing the simple fix. It must be evaluation time? I posted my speculation about this before I saw your fix.




The world is full of good people.

 

[dgillz]

No, I think it is just the default placement of the object is too close to the above object for this to show.

In my example I was doing this in a group footer after grouping sales $ by item.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[synapsevampire]

It had worked here as I had plenty of space.

-k

 

[CarpalT]

Well, thanks again to all who were interested. Learn something new every day - whether we have time for it or not!
A round for the house, bartender!

The world is full of good people.

 

[CarpalT]

synapsevampire , that explains why you were looking for an error message...

The world is full of good people.

 

[dgillz]

Carpal,

I'll have a Makers Mark and soda.


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[toekneel]

What version of Crystal are you using?

In version 8.5, there was a bug that caused the kind of problems you are describing. It was fixed by installing Service Pack 2.

I don't know if that same bug was an issue in later versions.

 

[CarpalT]

Crystal 8.5. Help tells me it is version 8.5.0217, does that mean I all ready have SP 2?
Thanks!

The world is full of good people.