Skip to Content

Problem with Report heading

I have a report with the Heading "Details"

How can i change the heading dynamically. For example if i select year 2005 the heading should change to 2005 and if selected 2006 it should change to 2006.

Thank you

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 19, 2011 at 09:01 PM

    1. Double click on your header cell

    2. Delete the header title or formula and replace it with this formula, for example:

    ="Selected Year: "+UserResponse ([My Query Name] ; "My Year Prompt Name")

    3. Press Enter

    (Note: instead of My Query Name you have to use your query's name fopr example Query1, instead of My Year Prompt name you have to put the prompt you use in your report)

    Edited by: PadawanGirl on Apr 19, 2011 11:01 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 20, 2011 at 09:48 AM

    There is an alternative way, If you are using 3.1 SP3 version, you could probably use "PromptSummary" function.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      But, when using this promptsummary(), will give the list all the prompts that you're using in the reports, also sometime clients may not like the heading with the prompt text starting with "Enter the ". So its better to use UserREsponse(). which will bring you the values alone for selected prompts

      Thanks

      dineshkumar

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2011 at 07:22 AM

    You can use pos() and substr() to extract a particular part of the query, prompt or filter summary and store this in a variable. Then just use that variable in the header.

    This approach will work regardless of how you'd like to filter the report.

    For a report filter summary, it would be something like:

    =Substr(ReportFilterSummary("Report 1"); Pos(ReportFilterSummary("Report 1"); "Year Equal") + 11; 4)

    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.