how to do column chart in ssrs report??

(0) Share

Report

Posted on by Community Member

I took case Id as parameter and I want to display quantity,price,Discount in x axis.Vendour Id in y axis using rdp class

I wrote this code in dp class give me suggestion to get report.

public void ProcessReport()

{
ITTI_purchcontract1 contract = this.parmDataContract() as ITTI_purchcontract1;
CaseId = contract.parmPurchRFQCaseId();
delete_from ITTI_purchtemp1;
if(!CaseId ==0)
while select PurchRFQCaseTable where PurchRFQCaseTable.RFQCaseId==CaseId
join PurchRFQCaseLine where PurchRFQCaseLine.RFQCaseId==PurchRFQCaseTable.RFQCaseId
join PurchRFQVendLink where PurchRFQVendLink.RFQCaseId==PurchRFQCaseTable.RFQCaseId

{

/*
ITTI_purchtemp1.PurchQty =PurchRFQCaseLine.PurchQty;
ITTI_purchtemp1.Price =PurchRFQCaseLine.PurchPrice;
ITTI_purchtemp1.Discount =PurchRFQCaseLine.LinePercent;
ITTI_purchtemp1.VendAccount =PurchRFQVendLink.vendAccount;
ITTI_purchtemp1.insert();*/

if(i==1)
{
i++;
ITTI_purchtemp1.LabelDescription ="Qty";
ITTI_purchtemp1.PurchQty =PurchRFQCaseLine.PurchQty;
ITTI_purchtemp1.VendAccount =PurchRFQVendLink.vendAccount;
ITTI_purchtemp1.doInsert();
}
if(i==2)
{
i++;
ITTI_purchtemp1.LabelDescription ="Unit price";
ITTI_purchtemp1.Price =PurchRFQCaseLine.PurchPrice;
ITTI_purchtemp1.VendAccount =PurchRFQVendLink.vendAccount;
ITTI_purchtemp1.doInsert();
}
if(i==3)
{
i++;
ITTI_purchtemp1.LabelDescription ="Disscount";
ITTI_purchtemp1.Discount =PurchRFQCaseLine.LinePercent;
ITTI_purchtemp1.VendAccount =PurchRFQVendLink.vendAccount;
ITTI_purchtemp1.doInsert();

}
}
}

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Sohaib Cheema 49,528 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

In SSRS there is something called MATRIX, that is typically used for such reports. Have you tried that?

msdn.microsoft.com/.../dd207149.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

No

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (1)

Report
Copy link

Link copied!

Refer into this link for column chart control community.dynamics.com/.../ax-2012-create-ssrs-column-chart-report

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I took another string field(labels) and added qty,price and discount.In category field I choose labels field

Was this reply helpful? Yes No
Sohaib Cheema 49,528 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

So give a try :)

Find below some sample examples of designing

ssrstutorials.blogspot.com/.../lesson-15-ssrs-matrix-reports.html

sqljason.com/.../ssrs-charts-with-data-tables-excel-style.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I did this way but in this I can get vendour id in x axis but actuallly I want to display vendour id in Y axis?

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report
Copy link

Link copied!

Add a new tablix control and create a group for vendor id and delete the detail line and create columns for other fields qty, price etc. use the expression like sum(qty).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

@sohaib

In matrix we can get values but I want labels(qty,price,disc.) also

Was this reply helpful? Yes No
Sohaib Cheema 49,528 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi Sachin,

it does not matter what you to display. The process is almost same as for displaying data.

Have a look at 2nd url given by me previously.

you can use chart control by dragging it from toolbox

Was this reply helpful? Yes No