Page 1 of 1
Stacked Column Chart List Of Arguments and values
Posted: Wed Jul 25, 2012 1:52 pm
by Zarif
Hi ,
I want to use the stacked column chart in my report.So when i add the "List of arguments" and "List of values" manually in the report i got the chart correctly.But when i give them a datatable as the source,the chart is appearing empty.Knowing that i am sending the arguments and values separated by ";" as required.So is there any solution ?
Regards,
Mohamad Zarif.
Re: Stacked Column Chart List Of Arguments and values
Posted: Wed Jul 25, 2012 2:34 pm
by HighAley
Hello.
Zarif wrote:I want to use the stacked column chart in my report.So when i add the "List of arguments" and "List of values" manually in the report i got the chart correctly.But when i give them a datatable as the source,the chart is appearing empty.Knowing that i am sending the arguments and values separated by ";" as required.So is there any solution ?
You couldn't use data columns in the
List of arguments and
List of values properties. You should set the
Value Data Column and
Argument Data Column properties.
Thank you.
Re: Stacked Column Chart List Of Arguments and values
Posted: Thu Jul 26, 2012 5:48 am
by Zarif
Hi Alex ,
I tried your solution but still did not work for me,so i will put my code here so you can check it please.
I have 3 series in my chart : "CardTransaction","Funds","Inquiries".
I have 3 datatables("dttCardTransactions","dttFunds","dttInquiries") that are found inside the dataset("dtsCustomerActivity") where i have in each datatable a column named "MonthAndDay" that is used as the Argument Data Column for each series and a column named "ActivityCount" that is used as Value Data Column for each series.
Here is my code :
Code: Select all
For i As Integer = 1 To 2
dtrCardTransactionsActivity = dtsCustomerActivity.dttCardTransactions.NewRow
dtrCardTransactionsActivity.ActivityCount = (20)
dtrCardTransactionsActivity.SeriesName = "Card Transactions"
dtrCardTransactionsActivity.MonthAndDay = "Apr"
dtsCustomerActivity.dttCardTransactions.Rows.Add(dtrCardTransactionsActivity)
dtsCustomerActivity.dttCardTransactions.AcceptChanges()
Next
For i As Integer = 1 To 2
dtrFundsActivity = dtsCustomerActivity.dttFunds.NewRow
dtrFundsActivity.ActivityCount = (12)
dtrFundsActivity.SeriesName = "Funds Transfers Transactions"
dtrFundsActivity.MonthAndDay = "Apr"
dtsCustomerActivity.dttFunds.Rows.Add(dtrFundsActivity)
dtsCustomerActivity.dttFunds.AcceptChanges()
Next
For i As Integer = 1 To 2
dtrInquiriesActivity = dtsCustomerActivity.dttInquiries.NewRow
dtrInquiriesActivity.ActivityCount = (6)
dtrInquiriesActivity.SeriesName = "Inquiries"
dtrInquiriesActivity.MonthAndDay = "Apr"
dtsCustomerActivity.dttInquiries.Rows.Add(dtrInquiriesActivity)
dtsCustomerActivity.dttInquiries.AcceptChanges()
Next
Dim objReport As New Reports.CustomerActivitiesReports
objReport.RegData(dtsCustomerActivity.Copy())
Notes:
- I have attached my report where i have a chart and i set the argument data column and value data column for each series in the chart.
-The pdf file is being generated but the chart is always empty and showing no data.
Thank you.
Re: Stacked Column Chart List Of Arguments and values
Posted: Thu Jul 26, 2012 6:33 am
by Zarif
I also tried this solution but it did not work :
Code: Select all
Dim objARguments As New Stimulsoft.Report.Components.StiListOfArgumentsExpression
objARguments.Value = "June;July"
Dim objValues As New Stimulsoft.Report.Components.StiListOfValuesExpression
objValues.Value = "1;2"
objReport.Chart.Series(0).ListOfArguments = objARguments
objReport.Chart.Series(0).ListOfValues = objValues
objReport.Chart.Series(1).ListOfArguments = objARguments
objReport.Chart.Series(1).ListOfValues = objValues
objReport.Chart.Series(2).ListOfArguments = objARguments
objReport.Chart.Series(2).ListOfValues = objValues
Re: Stacked Column Chart List Of Arguments and values
Posted: Thu Jul 26, 2012 2:35 pm
by HighAley
Hello.
We couldn't reproduce the issue. We need a working project.
Please, send us a working project with a sample data for analysis.
Thank you.