×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Null and/Blank Parameters when scheduling

Null and/Blank Parameters when scheduling

Null and/Blank Parameters when scheduling

(OP)
Why does a check for IsNull(Parameter_String) or Paramater_String = '' work fine(behaves like I would expect) when developing my Crystal Report.  But when I place it on the Seagate Info Server and schedule it and either check Null or leave blank on the prompt window, it does not evaluate out correctly.

I am using CR 8.5 and Seagate Info 7.5.2

RE: Null and/Blank Parameters when scheduling

(OP)
We are using SI version 7.5.2

I have a user parameter called From_Date which is a String Data_Type.

In a Formula I have:
DateVar Use_From_Date;

If ({?From_Date}= '' or isNull({?From_Date}) or  {?From_Date}= '0') Then
  (
   Use_From_Date := date(Year(CurrentDate),Month(CurrentDate),1);
  )
Else
  (
   Use_From_Date := date({?From_Date});
  );
Use_From_Date

------------------
The only one that allows me to get the current date as the date is if I enter '0' as the parameter when running the report from the Seagate Info Server.  IF I run this directly from Crystal it works fine if I just use the NULL test. One reason I am using a string is that the Date prompts in SI are confusing to the use.(But thats a different problem) But if I do use a Date and leave it blank I get the same results anyway.

RE: Null and/Blank Parameters when scheduling

Do you have any default values set, or a mask for this parameter?

Otherwise nothing glaringly wrong pops out for me.

The else condition will fail if the user doesn't enter the date properly, but I'm sure you know that. Some sanity checking on it's format might be in order.

Create another formula and place {?From_Date} in it to see what SI is returning, perhaps another to check length, etc.

-k

http://www.informeddatadecisions.com
kai@informeddatadecisions.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close