Hi,
I am having an annoying problem. I have 7 graphs on one page that basically show someone's grades for a given period of time by week (an average per week).. and each of the 7 graphs represents a different "area" they can receive grades in and one Average. So, the X axis are just dates (weeks) and their marks. So I added a couple of fields where the user can enter the date "range" before the report pops up. It "works" fine, but the x axis is autofilled with dates. So if I only want the last 3 weeks, instead of showing JUST those 3 weeks it auto-populates the X-axis with the days in between the 3 dates (weeks) as well, which of course there is no data for. So, it will show every other day starting from the 3rd last week to the last. So I'll have one bar showing the 3rd last week, then 3 or 4 dates where there is no data, then the 2nd last week, then 3 or 4 dates wehre there is no data again, then the last week... Does anyone have any idea how to fix this!?!? I want the x-axis to be JUST what comes back from the query (which is ONLY 3 dates if the user chose the past 3 weeks). Thanks a lot guys!
Tom
I am having an annoying problem. I have 7 graphs on one page that basically show someone's grades for a given period of time by week (an average per week).. and each of the 7 graphs represents a different "area" they can receive grades in and one Average. So, the X axis are just dates (weeks) and their marks. So I added a couple of fields where the user can enter the date "range" before the report pops up. It "works" fine, but the x axis is autofilled with dates. So if I only want the last 3 weeks, instead of showing JUST those 3 weeks it auto-populates the X-axis with the days in between the 3 dates (weeks) as well, which of course there is no data for. So, it will show every other day starting from the 3rd last week to the last. So I'll have one bar showing the 3rd last week, then 3 or 4 dates where there is no data, then the 2nd last week, then 3 or 4 dates wehre there is no data again, then the last week... Does anyone have any idea how to fix this!?!? I want the x-axis to be JUST what comes back from the query (which is ONLY 3 dates if the user chose the past 3 weeks). Thanks a lot guys!
Tom
