Hi guys. I'm at a loss...someone PUHLEESE throw me a frickin' bone, here.
OK so. I'm in Access 2002. I thought it would be easy to create ONE report containing nothing but ONE graph based on ONE query with 4 columns: Product Category [PC], Time, sum(LY Inventory), sum(TY Inventory).
AND if I created the report based on that query, I could make the PC a group header, and place the graph in the header section, and the report would [I*naturally*[/I] spit out 1 graph per PC and all would be right in the world.
<<<Everybody say it with me: AWW, YOU SILLY GIRL>>>
Okay, okay. When that didn't work, I searched various forums and not finding how to do this without coding (I am but a mere mortal), I seceded and went the advised route of doing a report/subreport thing. So I created 1 query and report for each PC (30+). Then I created one unbound report and threw each of the reports into the detail section as unrelated subreports.
...let's just say that at least with my first attempt, I could get a graph to show up on the print preview. I didn't think this would so difficult. Any help you can provide would be much appreciated.
Let the bone-throwing begin.
OK so. I'm in Access 2002. I thought it would be easy to create ONE report containing nothing but ONE graph based on ONE query with 4 columns: Product Category [PC], Time, sum(LY Inventory), sum(TY Inventory).
AND if I created the report based on that query, I could make the PC a group header, and place the graph in the header section, and the report would [I*naturally*[/I] spit out 1 graph per PC and all would be right in the world.
<<<Everybody say it with me: AWW, YOU SILLY GIRL>>>
Okay, okay. When that didn't work, I searched various forums and not finding how to do this without coding (I am but a mere mortal), I seceded and went the advised route of doing a report/subreport thing. So I created 1 query and report for each PC (30+). Then I created one unbound report and threw each of the reports into the detail section as unrelated subreports.
...let's just say that at least with my first attempt, I could get a graph to show up on the print preview. I didn't think this would so difficult. Any help you can provide would be much appreciated.
Let the bone-throwing begin.
