Please either Logon or create a New Account.
If-Then Statement/Hard Return
I've been trying to come up with an Activities Report that would list all the sports, etc., that a student had been in for the year.

I used an If/then statement to determine if a student had been in an activity:

^(CC;if.not.blank.then=Cross Country)

I put in a statement like that for each of the activities we have. I wanted to put in a hard return to separate them, but only if there was actually text present, not after every if/then statement, so I changed it to the following:

^(CC;if.not.blank.then=Cross Country<br>)

By golly if it didn't print just the ones that returned a value!!

I'm so excited about this and there's no one else geeky enough around here to be excited with me :~D

Peggy Medema
Valentine Community Schools
Valentine, NE
Tags: object reports  Reports  DAT
2 Responses to "If-Then Statement/Hard Return"

That works AWESOME!  Thank you for sharing!

 This geek is pounding his fist on his keyboard and giving the "peace" sign back at ya!!
 If I did the same thing on my chest like the Pro players, it would hurt.. LOL

Gary Warner
Would you like to comment? Join The PowerSchool Community for a free account, or login if you are already a member.