Rank: Newbie
Groups: Registered
Joined: 7/2/2018(UTC) Posts: 8 
|
Hello Everyone, Is it possible to compare data from previous years within a specific date range ? EG I would like to compare the data from 2018 , 2017 , 2016 for 3/01 ~ 6/30 I only have a delivery date in my DB and that is what is being used to filter date right now. so I can select the date range for any given year but cant figure out how to display the needed range for all years at the same time . Any help is greatly appreciated :) Thanks Bruce Edited by user Wednesday, July 11, 2018 5:35:50 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Seal Report will not have native function to do that.
You can either do that in SQL and provide a table having your comparison data done per year, so it is purely SQL...
OR another option is to process your result table in Seal Report using custom razor script (requires C# knowledge !).
You have a sample in the 'Dashboard Sales' report, select 'general month' model, then select 'Progression' element, then edit the 'Advanced\Cell Script' property...
Same for '50-Cell Script - Progression and running totals'
You can use also script to modify the result table itself (check '54-Final Script - Change result table')
Check also for scripts in the forum
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
