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.
Stacked Column Chart List Of Arguments and values
Re: Stacked Column Chart List Of Arguments and values
Hello.
Thank you.
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.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 ?
Thank you.
Re: Stacked Column Chart List Of Arguments and values
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 :
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.
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.
- Attachments
-
- CustomerActivity.mrt
- This is the report file i have.Please check the argument data column and valued data column properties for the series.
- (15.4 KiB) Downloaded 402 times
Re: Stacked Column Chart List Of Arguments and values
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
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.
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.