TeeChart and Crosstab

rbuser

Hi all,
I have a Report and want to create a Chart using a CrossTab.
Using TDBChart I get an error saying that TDBCrossTabSource can not be
created.
If I use a TChart i can see the Query I want for my crosstab from my form
and after configuring it I can see the chart with data etc.
But if I simply switch to preview and back the datasource of my series is
switched back to Manual. Idem iif I save the correct chart and reopen it at
runtime for printing. It always appera blank.
I'm using ReportBuilder 10 and teechart 7.06

Thanks in advance
Alex

nicocizik

Hi Alessandro,

The TppDPChart is only designed to connect to a datapipeline in
ReportBuilder. One option is to create the chart in its entirety on the
form and then show it inside the report as an image inside a TppImage
component. Something like the following...

var
lMetaFile: TMetaFile;
lRect: TRect;
begin

lRect.Left := 0;
lRect.Top := 0;
lRect.Right := ppImage1.spWidth;
lRect.Bottom := ppImage1.spHeight;

lMetaFile := Chart1.TeeCreateMetafile(True, lRect);
ppImage1.Picture.Metafile.Assign(lMetaFile);


--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks for your answer.
I think I understand what you mean, but my real problem other than that is
that I have to show a Chart inside a Group of the report
So other than have a Crosspost, the data should change in relation to the
group filter.

Can you or someone else post a solution?

Thanks in advance
Alessandro

nicocizik

In this case you will need to manually update the chart on the form as the
report generates. Take a look at using the group events to keep the chart
properly updated.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks for the tip. I will try and see what I can do.
Anyway I found quite disappointing to have to do e lot of work to print a
chart that I make with 4 click on my form and have to remove the ability for
the customer to customize the report at runtime. But I understand that you
did not make the chart libraries.
I hope for a better integration with two very good products.

Thanks,
Alessandro

rbuser

> I hope for a better integration with two very good products.

I create quite a few charts, some on live prints, some are one print
per-report. I never put a chart in a report--I always have them on my form.
This way I only have to configure the chart once. (I have fairly
comoplicated charts that it can require hours to make them look like I
want).

I always use a TppImage or a TppDBImage. In the later, I pregenerate the
images I will need prior to printing and use a TppJITPipeline to populate
the images in the report.

HTH,

Ed Dressel
Team DM