In order for the trend reports to be able to aggregate the data in minutes it only uses RAW data (QOS data contained in the RN_ tables)
The RAW data availalble in the RN_ tables is controlled by the data_engine data retention settings and is described in
KB000033704 Thus is the data retention settings only keeps 30 days of raw data then you can only see that 30 days in the trend reports
PRD does not have the same limitation as it does not provide such small aggregation limits and can therefore use the HN_ and DN_ tables