Sub Report Chart :(

[Sly600rr]

Hello again,

I hate to ask for help a second time, but it helped out so much last time its hard not to. I have been able to do pretty much everything I have tried to so far, but I've hit another road block that I just keep banging my head against.
I have a "Search Form" that I'm using unbound and combo text boxes for user inputs to filter out results from my query into a sub form.
I have a Print button that uses the same filter as the sub form to create a report.

Here's where I'm getting lost..

In this report I have 2 sub charts that I want to pull information from the filtered results used in the report.
I guess my question is.. How do I pull information from a report to populate my charts?

I'm pretty sure the source is my problem.

Row source Type... Query/Table
Row Source.. SELECT (Format([Date],"DDDDD")),Sum([Order]) AS [Total Orders],Sum([NC]) AS [NC Orders] FROM [qrydata] GROUP BY (Int([Date])),(Format([Date],"DDDDD"));

But I dont know how to make it get the information from my report instead of the query..

I've tried chaning the source to List or Feild and changing the source to things like...
SELECT (Format([Date],"DDDDD")),Sum([Order]) AS [Total Orders],Sum([NC]) AS [NC Orders] FROM [rptdata] GROUP BY (Int([Date])),(Format([Date],"DDDDD"));
or
Format([Date],"DDDDD")),Sum([Order]) AS [Total Orders],Sum([NC]) AS [NC Orders] GROUP BY (Int([Date])),(Format([Date],"DDDDD"));

but they are both just shots in the dark, because I can't find anything on how to do this..

I've attached my Database, if anyone wants to take a look and see if they can help me out. I feel when I am done this it will be a nice way of doing what I want to do. Feel free to use anything you want from it, as most of it is just modified examples from other people.

Any help would be much appreceiated.

In the example go to Search, Click the print button, and the charts are on the second page of the report, right now they are pulling information from the query, I want to pull information from the report only.

Thanks,
Steve

 

[Sly600rr]

I still haven't been able to get my graphs to work the way I want them..
I cant even figure out how to apply my filter to them by them selves..

I do have some pretty Icons now though..

 

[jal]

I have no experience with charts and reports, but here's my two cents, concerning the the original problem mentioned. It sounds to me like you want to base the charts on the results of the search query. If so, maybe you can have some VBA code that outputs the those search results into a SearchResults table. Then base the charts on the SearchResults table.

 

[Sly600rr]

Is what I'm tryng to do a bad way of doing it?
It sure would be nice if I could make it work, and it seems to make since to me..

But then again.. I have no idea what I'm doing..