Chart on Grouped report
I only see one chart demo. It appears pretty easy but I can't get a chart to work in a report I have that has 2 groups. Here is a sample query I'm using:
select cast(u1.last_name || '', '' || '+
u1.goesby as varchar(50)) as Name, s1.*,
c1.Category
from schedule s1
join users u1 on u1.userid = s1.userid
join Categories c1 on c1.catid = s1.catid
where
s1.schDate >= '2004-06-01'
and s1.schDate < '2004-08-01'
Report groups are on Name and Category. I want a pie chart of the how much time (which is s1.duration) the user spent in each Category.
Delphi 6 Pro, FR 2.5, DBISAM 3.73
Thanks.
select cast(u1.last_name || '', '' || '+
u1.goesby as varchar(50)) as Name, s1.*,
c1.Category
from schedule s1
join users u1 on u1.userid = s1.userid
join Categories c1 on c1.catid = s1.catid
where
s1.schDate >= '2004-06-01'
and s1.schDate < '2004-08-01'
Report groups are on Name and Category. I want a pie chart of the how much time (which is s1.duration) the user spent in each Category.
Delphi 6 Pro, FR 2.5, DBISAM 3.73
Thanks.
Comments
first [Sum([var or dfldname],bandname of mdband, 1)] use of extended syntax.
2nd must be used in correct footer, ie in a group with 2 header footers
it will work fine in the inner footer, which is summing the values of the current group. to get a total on outer footer, create a var in outerheader obp event and initialize to 0
mytot :=0;
in obp of mdband
mytot :=[mytot] +[var or dfldname];
then use [mytot] in memo in outer footer.
You may have problems using the chart tied to a memo, as the num of points in a series is the num of times the memo repeats.
i mislead you a bit sorry
the sum function should be fine with extended syntax,
i was thinking of prob;ems with avg and count.
1. My labels in the legend have little square boxes on the end of them.
2. When I display the report for mutiple users I want a new graph for each user's set of data. Currently only one graph displays at the end showing totals for all users. What band do I put the graph in to get it to do separate ones for each user?
Thanks for your help.
What may be happening with stretched on, a cflf may have been inserted and that is what was showing. check memo's props and make sure wordwrap and stretched are off also.