PatriciaObreja
Programmer
CR 9 and SQL Server 2000
I Details section a have some formulas like this arranged vertically:
@acct1
@acct2
@acct3
@acct4
@acct5
//@acct1
stringVar array accta := Split({Field}, chr(13));
if count(accta) >= 1 then
accta[1]
else
"";
The other ones are very similar.
So I have a field that comes from the database using a stored procedure with information separated by char(13).
In Crystal I split the infromation, and each value goes to a formula.
I want that when the result of the formula is blank, to not take space from my report. I don't want to see blank, I just don't want to see it at all, to hide it, or something else.
I've tried all the possible combinations, and I think that the one that might work will be to create a Detail section for each formula, with the report is already full of subsection, and I have 10 formulas, and I really would like to have a simpler solution if possible.
-----------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium
I Details section a have some formulas like this arranged vertically:
@acct1
@acct2
@acct3
@acct4
@acct5
//@acct1
stringVar array accta := Split({Field}, chr(13));
if count(accta) >= 1 then
accta[1]
else
"";
The other ones are very similar.
So I have a field that comes from the database using a stored procedure with information separated by char(13).
In Crystal I split the infromation, and each value goes to a formula.
I want that when the result of the formula is blank, to not take space from my report. I don't want to see blank, I just don't want to see it at all, to hide it, or something else.
I've tried all the possible combinations, and I think that the one that might work will be to create a Detail section for each formula, with the report is already full of subsection, and I have 10 formulas, and I really would like to have a simpler solution if possible.
-----------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium