Solved: Multiple Add Commands (Crystal Report ) and Report...

Former Member · ‎07-24-2013

Hi,

I am using crystal sap reports for Visual Studio 2010 . My problem is that I want to develop a report with complete graphical chart and data,

Can you please tell me how to add multiple add commands for Example .. !

Command 1 for details data.

select column1, column2 from table1 where column1 = "ABCD" or column2="DEFG"

Command 2 for Graphical chart.

select column4, column5, count(column6), sum(column7) from table2 where column4 = "blah blah" group by column4, column5

Similarly Command 3 for Graphical chart.

select column3, column5, count(column9), sum(column1) from table3 where column4 = "blah blah" group by column3, column5

Another poblem is that

I want to Set Report DataSource and pass linQ query from visual studio for fetching data then please tell me how to pass above 3 commands query from Visual Studio to show report.

Thanks & Regards

Syed Adeel Ali

former_member183750 · ‎07-24-2013

Ensure that you are using SAP Crystal Reports, developer version for Microsoft Visual Studio, Service Pack 6.

Next, be aware that the functionality of Crystal Reports SDK in Visual Studio .NET is limited to the appearance of the chart in the viewer such as height and width. The ability to Add, Remove or modify a chart uses Report Application Server (RAS)report creation API. RAS Developer Help Files:

Report Application Server .NET SDK Developer Guide

Report Application Server .NET API Guide

Next have a read of the following:

ChartOject Members

ChartObject Properties

Finally, to get you started, see the attached txt file that demos code on inserting a chart into a report.