Skip to Content
author's profile photo Former Member
Former Member

How to hide a variable in the query?

Hello everyone,

I don't know if my framing would be correct but i would like to explain my problem first. I have a query with a variable in the result but with defaulted values. I don't want this variable to pop up when i am running a report. I don't want the users to know that this has been defaulted or i just feel it unnecessary for them to see this variable. So is there a way to avoid it or hide it. Ex: i have a varible with Cal day and Plant as optional variables and the third is Document number which i defaulted from 500 to 599 but i don't want this to popup while running the query or refreshing the report. Just fyi this variable has been used in the columns part as a selection with one key figure and one characteristic.

Hope i am clear,

Would surely appreciate any of your comments.

Anjali

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2005 at 06:42 AM

    Hi Anjali,

    Modify the document number variable and uncheck the "<b>Ready for Input</b>" check box. This will not display the Document number variable to the user.

    Hope this helps.

    Cheers,

    Demetrius.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.