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.

Jobs

Dynamic Parameter CR2013

Dynamic Parameter CR2013

(OP)
I am trying to create a dynamic parameter to show a list of Branches.

This subquery generates what I need including an ALL option and when I join to my data I can enter 0 for All or a specific branch number
Query built on Oracle 11

select ID BRANCHID, NAME BRANCHNAME, SHORTNAME
from fossil.LST_Branches br
where not(ID in (1, 14, 8,13, 15, 22, 24, 25))
--and (:pi_branch = 0 or ID = :pi_branch)
Union All
Select 0, 'ALL', 'ALL' from Dual
order by BRANCHNAME

I do not want to create a list of branches from the main report because I am using a Command and it is too slow

I can use the subquery as a factored table or CTE using a with statement but that does not seem to help.
We have crystal reports Server so I can build a parameter in the repository somewhere if required.

I am sure it can be done I just can't remember how!!

Thank you

Ian

RE: Dynamic Parameter CR2013

You should be able to build a separate command for your list of branches that then you can use as a LOV for a prompt. Crystal Reports will complain about an unlinked data source, but can ignore that message.

RE: Dynamic Parameter CR2013

(OP)
I knew it was simple. Worked like a charm

Thanks for your help.

Ian

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!

Resources

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