Part I SubReport:
I have a subreport that I am using on a "Mid Level" summary and an "Overall" summary report. On the mid level, it needs to show data for 3 years and display numbers with 2 decimals (percentage format). The summary level only needs to show 2 years and display numbers with 1 decimal point (percentage format). Short of copying the existing subreport and modifying it to display properly for the second report, does anyone know of some code that can allow me to use this one subreport in both places and have it display as described?
Sample of how subreport displays on report 1
-----------------
2008 50.25%
2007 38.92%
2006 49.00%
Sample of how subreport should display on report 2
-----------------
2008 50.3%
2007 38.9%
Part II Chart:
Built a multi-line line chart. User has requested that an arrow be added to point to each line's current position on the graph. So if there are 25 plot points on the line and we are at plot point 18, the arrow will point to the line where it ends at this point. Each plot point represents one week's data. Each week, the arrow needs to move to the "current" plot point, so if last week is at point 18, then this week, the arrow needs to point to 19. I'm hoping this can be accomplished without me having to manually go in and add the new plot point to the chart's data table so that it can be seen in design view in order to properly position the arrow.
I have a subreport that I am using on a "Mid Level" summary and an "Overall" summary report. On the mid level, it needs to show data for 3 years and display numbers with 2 decimals (percentage format). The summary level only needs to show 2 years and display numbers with 1 decimal point (percentage format). Short of copying the existing subreport and modifying it to display properly for the second report, does anyone know of some code that can allow me to use this one subreport in both places and have it display as described?
Sample of how subreport displays on report 1
-----------------
2008 50.25%
2007 38.92%
2006 49.00%
Sample of how subreport should display on report 2
-----------------
2008 50.3%
2007 38.9%
Part II Chart:
Built a multi-line line chart. User has requested that an arrow be added to point to each line's current position on the graph. So if there are 25 plot points on the line and we are at plot point 18, the arrow will point to the line where it ends at this point. Each plot point represents one week's data. Each week, the arrow needs to move to the "current" plot point, so if last week is at point 18, then this week, the arrow needs to point to 19. I'm hoping this can be accomplished without me having to manually go in and add the new plot point to the chart's data table so that it can be seen in design view in order to properly position the arrow.
