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

Notification

Icon
Error

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

Rank: Newbie

Groups: Registered
Joined: 7/2/2018(UTC)
Posts: 7
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 :)



Thanks
Bruce

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

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

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 527
Switzerland

Thanks: 7 times
Was thanked: 72 time(s) in 70 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.