how Can I solve this problem?

alharbi · Post by **alharbi** » Wed Jun 11, 2008 3:09 pm

how Can I solve this problem?
I Have Two Tables, the first table contain two fields :
1-TeacherID
2-TeacherName

the second table contain three Fields:
1-TeacherID
2-ArgumentDesc
3-ArgumentValue
(the second table contain More than five ArgumentDesc and values for each record in the first table)
I build A Chart Report .then I set The first Table as Master Table and set the second table as detail table .

the problem is :when I display the report, the chart repeated with every row in the detail sector .

any Idea please.

Stéphane · Post by **Stéphane** » Thu Jun 12, 2008 2:40 am

Hello,

it must work. You must have a relation between your two tables. Don't forget to set the DataRelation property of the second chart.
If it doesn't work, could you explain with more details how you place your charts : in two master/detail databands ? What are the values of the DataSource and DataRelation properties of your databands and charts ?

Cordially,
Kakone.

alharbi · Post by **alharbi** » Thu Jun 12, 2008 6:27 am

thank you very much .

it is working now , i am forget the DataRelation property of the chart.

thank you again .

mihiri · Post by **mihiri** » Sun Jun 15, 2008 5:07 am

would you please explain how you have done this? i am new to this software and need to do the same that you have done, how did you set the data sources and relations and have you put two charts on each band?
thanks in advance.
Mihiri

mihiri · Post by **mihiri** » Sun Jun 15, 2008 5:23 am

i have don the same, even set the relation but still for each row the graph is repeating.how have you set the argument and data values?

alharbi · Post by **alharbi** » Sun Jun 15, 2008 9:33 am

1- Insert new chart in the main data band.
2- use the chart wizard to specification the basic propertys (arguments ,values,chart type ..etc ).
3- close the chart wizard then go to the propertys tab of the chart (in the left side of designer).
4- go to Data sectour then specification the data source property and data relation by select your data and relation .
5- run your report .

i hope this help you .

mihiri · Post by **mihiri** » Sun Jun 15, 2008 11:49 pm

thank you very much.
but still i have some problems which i hope you would answer kindly.
do u mean we have to add the chart on master? what about the data relation then?the data source is the detail data source, is not it? i want to show in the chart for every master value the sum of costs in detail row . is this what you have done? have you used sum function then? but in data value columns sum function is not allowed, is it?

Post by **Edward** » Tue Jun 17, 2008 9:47 am

Hello, Mihiri.

It is not necessary to have two bands for this task. Please see the "Chart On Databand" report in 'Demo' sample application in the standard installation of Stimulsoft Reports.Net.

Thank you.

mihiri · Post by **mihiri** » Wed Jun 18, 2008 2:56 am

Thanks a lot to u both . That was helpful.