Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.

Welcome Guest ! To enable all features please Login or Register.



Go to last post Go to first unread
#1 Posted : Wednesday, July 11, 2018 4:06:29 PM(UTC)

Rank: Newbie

Groups: Registered
Joined: 7/2/2018(UTC)
Posts: 8
United States

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 :)


Edited by user Wednesday, July 11, 2018 5:35:50 PM(UTC)  | Reason: Not specified

#2 Posted : Thursday, July 12, 2018 11:52:00 AM(UTC)

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
Users browsing this topic
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.