Input Data from Calendar and using the same get the data from the SQL tables

[#1]

How do I get the matching data based on the input passed from the Input Fields. For example if have start and end date as my input how do i filter the records from the main data for the inputted values.

[MayilVahanan]

HI

Please see the attached file.

Hope it helps

[#3]

Thanks

Let me explain what is my scenario.  I have 3 SQL tables and have created links between these tables.  One of the table has a date column where i need to filter.  I created 2 input fields (calendar).  Using these 2 Input fields i need to refresh the data from these 3 SQL tables and display the result set. It is similar to like this

where date between <startdate> and <enddate>

If you can provide me with the steps of doing this it will be of great help.

[#4]

Thanks

Let me explain what is my scenario.  I have 3 SQL tables and have created links between these tables.  One of the table has a date column where i need to filter.  I created 2 input fields (calendar).  Using these 2 Input fields i need to refresh the data from these 3 SQL tables and display the result set. It is similar to like this

where date between <startdate> and <enddate>

If you can provide me with the steps of doing this it will be of great help.

[#5]

Thanks

Let me explain what is my scenario.  I have 3 SQL tables and have created links between these tables.  One of the table has a date column where i need to filter.  I created 2 input fields (calendar).  Using these 2 Input fields i need to refresh the data from these 3 SQL tables and display the result set. It is similar to like this

where date between <startdate> and <enddate>

If you can provide me with the steps of doing this it will be of great help.

[#6]

Thanks

Let me explain what is my scenario.  I have 3 SQL tables and have created links between these tables.  One of the table has a date column where i need to filter.  I created 2 input fields (calendar).  Using these 2 Input fields i need to refresh the data from these 3 SQL tables and display the result set. It is similar to like this

where date between <startdate> and <enddate>

If you can provide me with the steps of doing this it will be of great help.

[#7]

Thanks

Let me explain what is my scenario.  I have 3 SQL tables and have created links between these tables.  One of the table has a date column where i need to filter.  I created 2 input fields (calendar).  Using these 2 Input fields i need to refresh the data from these 3 SQL tables and display the result set. It is similar to like this

where date between <startdate> and <enddate>

If you can provide me with the steps of doing this it will be of great help.

[#8]

Thanks

Let me explain what is my scenario.  I have 3 SQL tables and have created links between these tables.  One of the table has a date column where i need to filter.  I created 2 input fields (calendar).  Using these 2 Input fields i need to refresh the data from these 3 SQL tables and display the result set. It is similar to like this

where date between <startdate> and <enddate>

If you can provide me with the steps of doing this it will be of great help.

[MayilVahanan]

Hi

Try like this

Where vStart and vEnd are input fields.

In chart, apply this expression

=Sum({<StartDate = {'>=$(=Date(vStart))'}, EndDate = {'<=$(=Date(vEnd))'}>}Sales)

,

I hope that startdate n enddate have link..

If you need to check the format for input field means, please use like  in the demo application..

Expression explanation:

So, from these,

it calculates the sales, for StartDate is greater than the vStart variable, and EndDate is lesser than the vEnd..If you need restriction means, you can apply like the demo application..

In demo application,if you give the invalid format means,its show the error message, that is apply in custom error message in constraints tab.

In that tab, we can able to apply the various option.. So from that, we can apply the condition as per our requirement. In number tab, we can change the format, how to apply..

[#10]

Thanks

Let me try and will update you.