Team, I have a customer request to build a report that supports a trend graph. The difficult part is that they want a 3 month comparison chart, based on daily input. So if we are in August and input data August 9th, we will then have 3 trend lines; Line 1 is from the input date back 30 days; the next trend line 2 starts with day 31 to 60, then line 3 is day 61 to 90. This could be by month as well, but I am trying to allow for selection of a day to drive the report. I have 2 reports that provide the details of the data correctly by days. The 1st report uses DATE, the second allows to select a DATE, but the line items are "Days" to calculate the values by 3 seperat buckets. Issue is in the creation of the line graphs. Using the Days as line items graphs the wrong trend, bc it uses the line items. The original report graphs correctly, but then each request of the graph would need to be published as dates change. I want it to be dynamic, but cannot seem to find a manner to allow for Day selection driving the graph. My question is, can we select the parameters of the graph for the x or y axis, or is it fixed so that the "line items" are always the data points that end up in the legend?? I would like to swap the axis to graph on a LIST not just Line items. Thanks in advance. petar
