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

 

Active Report Control to change crosstab columns (using relative dates)

Started by donut, 05 May 2024 05:58:52 PM

Previous topic - Next topic

donut

Greetings.

Info:
1. [Using Relational data]
2. [Using Gregorian calendar data module]
3. Crosstab visualization: Date as column, categories as row and sales as measure
4. * New to active report

In my active report, I want to have a toggle button that when clicked, it will filter my date based on the relative filters. For example, two buttons set up as "current day vs previous day" and "current day vs previous month". When "current day vs previous day" is clicked, the crosstab column should show sales of today's vs yesterday's. When "current day vs previous month" is clicked, the crosstab column shows sales of today's vs sales of end of last month.

Currently in my crosstab query, I have the date, category and sales as data item, in my detailed filter, I have the relative date filters: date.currentday or date.previousday or date.previousmonth. This is of course showing three of them altogether, but instead 2 are needed only, with date.currentday being static.

Appreciate for any feedback

Cheers!



MFGF

Quote from: donut on 05 May 2024 05:58:52 PMGreetings.

Info:
1. [Using Relational data]
2. [Using Gregorian calendar data module]
3. Crosstab visualization: Date as column, categories as row and sales as measure
4. * New to active report

In my active report, I want to have a toggle button that when clicked, it will filter my date based on the relative filters. For example, two buttons set up as "current day vs previous day" and "current day vs previous month". When "current day vs previous day" is clicked, the crosstab column should show sales of today's vs yesterday's. When "current day vs previous month" is clicked, the crosstab column shows sales of today's vs sales of end of last month.

Currently in my crosstab query, I have the date, category and sales as data item, in my detailed filter, I have the relative date filters: date.currentday or date.previousday or date.previousmonth. This is of course showing three of them altogether, but instead 2 are needed only, with date.currentday being static.

Appreciate for any feedback

Cheers!




Hi,

Just confirming - this is an Active Report? If so, I think the easiest option here is to add a deck to your report with two cards - one card for current/previous day and one card for current/previous month. Add a crosstab to each card, and build each of the two crosstabs to show the relevant items (day items in the crosstab on the current/previous day card, and month items in the crosstab on the current/previous month card). Finally, add a control (probably a dropdown list is best) that sets a variable that selects the deck and drives which card is displayed.

Cheers!

MF.
Meep!

donut