A Chart for Each Client

I'm trying to create a chart for each client.
In a DataSet, they are returned in a sorted order like this:
ClientName Month Sales
-- -- --
Client 1 1 500
Client 1 2 100
...
Client 1 10 900
Client 2 1 100
Client 2 2 200
...
Client 2 10 800
I'd like to have two charts, Client 1 and Client 2 showing their own
trend.
However, so far I get only ONE chart, either a sum, or the first client
group if it's not sum.
I don't think it will take one query per client.
Thanks.I think I got it by browsing some QA here, simply by putting it in a
group's header or footer in a table.|||Yes, that is correct. If you place a chart in a table detail section, every
chart will just get one detail data row (i.e. essentially just one
datapoint) and this is not what you want. Placing the chart however in the
group's header or footer will generate a chart from all the detail rows that
are contained in the current group.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<hifchan@.yahoo.com> wrote in message
news:1108483860.264648.286130@.c13g2000cwb.googlegroups.com...
>I think I got it by browsing some QA here, simply by putting it in a
> group's header or footer in a table.
>sql

4 chart per page

I am using sql reporting and need to place 4 chart per page : in 2
column and 2 rows.
I have one datasource for this report to show on chart.
Any help?On Jan 10, 8:12 pm, arkgroup <arkgr...@.hotmail.com> wrote:
> I am using sql reporting and need to place 4 chart per page : in 2
> column and 2 rows.
> I have one datasource for this report to show on chart.
> Any help?
If I'm understanding you correctly, you can place the 4 charts into 2
rectangle controls (either vertically or horizontally) and then set
the report to 2 columns (via: the Layout view >> Report drop-down >>
Report Properties... >> Layout tab >> Columns and possibly adjust the
Spacing and Margins). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant