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

How to capture Calendar Input control value

Hi Friends,

In my report user selects the date from calendar control ,

so my question is How to capture that date and display in report header?



Need Help....

Regards

Sushma

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 10:45 AM

    Hi Sushma,

    We can capture input control value using ReportFiltersummary() function. You can extract you desired value using POS function along with reportfiltersummary function.

    Sample syntax to capture input control.

    =Trim(Substr(ReportFilterSummary("Throughput");Pos(ReportFilterSummary("Throughput");"Classification Equal")+20;7))

    Throughput is tab name.

    Classification Equal is dimesion name on which we created input control. +20 is used to extract characters after classification equal.

    Regards

    Shabnam

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 11:17 AM

    Hi Sushma,

    Take an empty cell and write the below formula in that cell:

    =FormatDate(ToDate(Replace(Left(Replace(UserResponse("Calendar Day");" ";" ");10);" ";"");"MM/dd/yyyy");"dd/MM/yyyy")

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2014 at 12:41 PM

    Hi Susma,

    its simple,

    Please follow these steps:

    1.Go to Report Element Tab->Table->Define vertical Table please select vertical table.

    2.Drag the Calendar month Object in that vertical Table.

    3.Go to Input Control Tab-Select Wrench Button it wil prompt one Dialog Box and Go to Dependencies Tab and Select Vertical Table:BLOCK2.

    Thanks,

    Prasad


    InputControl.png (36.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 10:44 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2014 at 10:45 AM

    =ReportFilter([Your Date Object])

    [Your Date Object] is the date dimension on which you have created the input control.

    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.