function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
data.migration1.3948976100296348E12data.migration1.3948976100296348E12 

Custom Reports Wrong Data Displayed

Hi,

I am selcting from month to to month in my report showing correct data for one month

am selecting four months display wrong data..

for example am selecting from month:FEB to month:Feb it's  show correct data

now am again selecting from month:JAN to month:APR it's show wrog data.
 max selecting four months range........


please help on this

Thanks,




Ashish_SFDCAshish_SFDC
Hi , 


What is the variation that you are seeing?

Did you check the exact time zone in which you are pulling the data?

Try 2 months in between and check if it is showiong correct results. 

Post an image if possible with the deflection. 


Regards,
Ashish
data.migration1.3948976100296348E12data.migration1.3948976100296348E12
Hi Ashish,

two months range it's showing correct data..

if user selecting four month range it's showing wrong data..
means records display zigzag like.

here snippet:
for(String TerritoryName: TerritoryNameQuerySet){
                for(Integer MonthKey:StartDatesMap.keyset()){
                    TerritoryMonthKey = TerritoryName+'-'+MonthKey;
                    Map<String,Set<Id>> FreqAssignmentMap = new Map<String,Set<Id>>();
                    Set<Id> AssignemntIdSet = new Set<Id>();
                    FreqAssignmentMap.put('1',AssignemntIdSet);
                    AssignemntIdSet = new Set<Id>();
                    FreqAssignmentMap.put('2',AssignemntIdSet);
                    AssignemntIdSet = new Set<Id>();
                    FreqAssignmentMap.put('3',AssignemntIdSet);
                    AssignemntIdSet = new Set<Id>();
                    FreqAssignmentMap.put('3+',AssignemntIdSet);
                    DVLTerrMonthFreqAssignmentMap.put(TerritoryMonthKey,FreqAssignmentMap);
                    FreqAssignmentMap = new Map<String,Set<Id>>();
                    AssignemntIdSet = new Set<Id>();
                    FreqAssignmentMap.put('1',AssignemntIdSet);
                    AssignemntIdSet = new Set<Id>();
                    FreqAssignmentMap.put('2',AssignemntIdSet);
                    AssignemntIdSet = new Set<Id>();
                    FreqAssignmentMap.put('3',AssignemntIdSet);
                    AssignemntIdSet = new Set<Id>();
                    FreqAssignmentMap.put('3+',AssignemntIdSet);
                    DCRTerrMonthFreqAssignmentMap.put(TerritoryMonthKey,FreqAssignmentMap);
                    FreqAssignmentMap = new Map<String,Set<Id>>();
                    AssignemntIdSet = new Set<Id>();
                    FreqAssignmentMap.put('1',AssignemntIdSet);
                    AssignemntIdSet = new Set<Id>();
                    FreqAssignmentMap.put('2',AssignemntIdSet);
                    AssignemntIdSet = new Set<Id>();
                    FreqAssignmentMap.put('3',AssignemntIdSet);
                    AssignemntIdSet = new Set<Id>();
                    FreqAssignmentMap.put('3+',AssignemntIdSet);
                    MissedTerrMonthFreqAssignmentMap.put(TerritoryMonthKey,FreqAssignmentMap);
                }
            }

            //Creating DVL Map based on territory,month and frequency
            for(Assignment__c Assignment: QueryDVLList){                              
                if(integer.valueOf(Assignment.Frequency__c)>3){
                    FrequencyKey = '3+';
                }
                else{
                    FrequencyKey = Assignment.Frequency__c;
                }
              for(Integer MonthKey:EndDatesMap.keyset()){
                    /*  if((Assignment.Effective_Date__c == null && Assignment.Deactivation_Date__c != null) && Assignment.Deactivation_Date__c <= StartDatesMap.get(MonthKey))
                                continue;
                    else if((Assignment.Effective_Date__c != null && Assignment.Deactivation_Date__c == null) && Assignment.Effective_Date__c > EndDatesMap.get(MonthKey))
                                continue;
                    else if((Assignment.Effective_Date__c == null && Assignment.Deactivation_Date__c ==null) || (Assignment.Effective_Date__c<=EndDatesMap.get(MonthKey) && Assignment.Deactivation_Date__c > StartDatesMap.get(MonthKey)) || (Assignment.Effective_Date__c == null && Assignment.Deactivation_Date__c > StartDatesMap.get(MonthKey)) || (Assignment.Deactivation_Date__c == null && Assignment.Effective_Date__c <= EndDatesMap.get(MonthKey)))*/
                   // {
                            if((DVLTerrMonthFreqAssignmentMap.get(Assignment.target__r.territory__c+'-'+MonthKey))!=null ){
                                Map<String,Set<Id>> FreqAssignmentMap = DVLTerrMonthFreqAssignmentMap.get(Assignment.target__r.territory__c+'-'+MonthKey);
                                Set<Id> AssignmentIdSet = new Set<Id>();
                                if(FreqAssignmentMap.get(FrequencyKey)!=null){
                                    AssignmentIdSet = FreqAssignmentMap.get(FrequencyKey);
                                }
                                AssignmentIdSet.add(Assignment.Id);
                                FreqAssignmentMap.put(FrequencyKey,AssignmentIdSet);
                                DVLTerrMonthFreqAssignmentMap.put(Assignment.target__r.territory__c+'-'+MonthKey,FreqAssignmentMap);    
                   
                            }
                   // }
                }              
            }