creating  a parameter for the static value.

Posted on 2005-04-29
Last Modified: 2006-11-18
Hi is it possible for me to create a parameter for this number(-1) so that the user can enter any number from the parameter
i am having this in my record selection criteria

so instead on -1 there should a dynamic value for which the user can change in the parameters. can any one help me with this how to do.,

Thank you,
Question by:varunogili
    LVL 100

    Expert Comment

    Where is this code?  If it is in the application as it appears just use the field name or variabel he enters it in.


    Author Comment

    i am using the below statements  in the record selection criteria

    {NETCOOL_HISTORY.NODE} = {?Node} and
    {NETCOOL_HISTORY.MANAGER} = {?Manager} and
    {NETCOOL_HISTORY.LASTOCCURRENCE} >= dateadd("h",-4,currentdate)

    and in the url i am  i am giving the node and manager as the parameters. in the same way how will i create one for the  dateadd('h",-4,currentdate) . i need only for -4  so that i can pass it in the url.


    so the user can get the desired result for the hours he enters.

    LVL 100

    Accepted Solution

    Create another parameter - DayDiff


    {NETCOOL_HISTORY.NODE} = {?Node} and
    {NETCOOL_HISTORY.MANAGER} = {?Manager} and
    {NETCOOL_HISTORY.LASTOCCURRENCE} >= dateadd("h",{?DayDiff},currentdate)

    LVL 100

    Expert Comment

    Glad i could help


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now