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!
  • Students Click Here

*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


Available vs. Default Parameter - Works in Preview but not from the Report Manager

Available vs. Default Parameter - Works in Preview but not from the Report Manager

Available vs. Default Parameter - Works in Preview but not from the Report Manager

I have a weird problem I would like to have resolved. I create reports for our ADP Enterprise V3 application (or PeopleSoft) using an Oracle 9.2 backend database. I created a report that has a parameter that uses two stored procedures. The avaiable selection returns all paygroups that the user is allowed to see. The second procedure sets the default to the paygroup of the user.

This runs perfectly in Preview mode. Once the report is deployed however, the default is not selected...only blank check boxes.

What I have tried so far...
1. Made sure that in Report Manager, under Properties, the "Has default" is checked.
2. Changed alias of the procedures so the two procedures were not the same.
3. Used distinct in both procedures and made sure that nulls were not returned.
4. Tried using a stored procedure for the available selection and a text query for the default and vise versa.
5. Copied procedure for available and pasted in procedure for default - this worked where all selections were checked.
6. Set available to None and the default worked, but this again led to all selections being checked and not the paygroup of user.
7. Removed the "where" statement in the query for default and it worked, but again all selections are checked.

I have found no solutions on the internet and even have members of my IT staff working on this, but they are as confused as I am.

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!

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