If you are unable to create a new account, please email support@bspsoftware.com

 

Filter the Data in visualization by Date Interval In Active Reports

Started by Pratap Reddy, 04 Jan 2018 04:09:19 AM

Previous topic - Next topic

Pratap Reddy

Hi,

I have a Requirement where i need to filter data in visualization by date interval in Active reports

Concept:

Year >= 2010 and Year <= 2012

with above year inputs visualization need to filter..


Please find the attachment.

MFGF

Quote from: Pratap Reddy on 04 Jan 2018 04:09:19 AM
Hi,

I have a Requirement where i need to filter data in visualization by date interval in Active reports

Concept:

Year >= 2010 and Year <= 2012

with above year inputs visualization need to filter..


Please find the attachment.

Hi,

So what are you struggling with? The attachment you posted doesn't explain to us what the issue is.

The approach is to use a control that allows multi-select (eg data toggle button bar, data list box, data discrete values slider etc) and populate a variable with this, then use the variable to filter your visualization.

Cheers!

MF.
Meep!

Pratap Reddy

Hi MFGF,

i have used two Data Discrete values Slider and List
i have used year data item for both Data Discrete Values Slider and values in year are 2010,2011,2012,2013
First Data Discrete values Slider i'm giving 2011
Second Data Discrete values Slider i'm giving 2013
i should get the result in List between 2011 and 2013
but it's getting First Discrete values slider values in List

Could you please give me a example if possible...


Thanks in Advance..

MFGF

Quote from: Pratap Reddy on 05 Jan 2018 12:48:26 AM
Hi MFGF,

i have used two Data Discrete values Slider and List
i have used year data item for both Data Discrete Values Slider and values in year are 2010,2011,2012,2013
First Data Discrete values Slider i'm giving 2011
Second Data Discrete values Slider i'm giving 2013
i should get the result in List between 2011 and 2013
but it's getting First Discrete values slider values in List

Could you please give me a example if possible...


Thanks in Advance..

Hi,

You only need one Data Discrete Values slider. It has a "Range Type" property, and you need to set this to "Range" so that your slider will allow you to select a range of years.

See attachment...

Cheers!

MF.
Meep!

Pratap Reddy

Thanks a ton MFGF, its working good.

In Trail Version we have only four Inputs(2010,2011,2012,2013)

In my Project i have number of inputs like (1/1/2013,2/3/2013.........soon) or Calendar(1/1/2013 ...........1/1/2018)

How can i use range for above type of dates....

Thanks in Advance...

MFGF

Quote from: Pratap Reddy on 05 Jan 2018 04:02:12 AM
Thanks a ton MFGF, its working good.

In Trail Version we have only four Inputs(2010,2011,2012,2013)

In my Project i have number of inputs like (1/1/2013,2/3/2013.........soon) or Calendar(1/1/2013 ...........1/1/2018)

How can i use range for above type of dates....

Thanks in Advance...

Do you want to use just the years from the dates, or do you want the dates themselves? If you just want to use the years, create a query calculation with the expression extract( year, [your Date item])

Cheers!

MF.

Meep!

Pratap Reddy

Hi MFGF,

Thank you for your reply.

Actually entire date i need to search in calendar data item.

Thanks in Advance.

MFGF

Quote from: Pratap Reddy on 09 Jan 2018 05:05:03 AM
Hi MFGF,

Thank you for your reply.

Actually entire date i need to search in calendar data item.

Thanks in Advance.

There is no calendar object within an active report. The best you can do is a data discrete values slider, but it can look a bit messy.

Cheers!

MF.
Meep!