Stacked Column Chart List Of Arguments and values

Stimulsoft Reports.NET discussion
Post Reply
Zarif
Posts: 6
Joined: Thu Mar 29, 2012 6:37 am
Location: Lebanon

Stacked Column Chart List Of Arguments and values

Post 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.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Stacked Column Chart List Of Arguments and values

Post 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.
Zarif
Posts: 6
Joined: Thu Mar 29, 2012 6:37 am
Location: Lebanon

Re: Stacked Column Chart List Of Arguments and values

Post 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.
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
Zarif
Posts: 6
Joined: Thu Mar 29, 2012 6:37 am
Location: Lebanon

Re: Stacked Column Chart List Of Arguments and values

Post 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
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Stacked Column Chart List Of Arguments and values

Post 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.
Post Reply