hi all,
plz help me i m new to crystal report....i m using stored procedure but i m not getting how to paas the parameter & how to write SQl query for that.....i m using C#
thanx....:)

suni_kutty

   Hey...

   First off, you need an instance of your report .rpt file in your solution, so that u can modify it in run time, and pass info to the report. Keep in mind that the examples i may give are all in VB, but its similar enough. So, u need to add a component to your solution (viewer form), the component u need is the ReportDocument.

     Once that is created, and linked to the report file your working on (instance name myNiceRep), u then can use that instance to pass info to your report, like this:

     Dim paramValue as String = "Hello!"
     myNiceRep.SetParameterValue("ParamName", paramValue)

     And thats it! (If i understood your question well of course... ;) )

      Oh!.. and for the SQL query.. well, i use the Selection Assistant... its not quite like SQL, but u can comfortably write what you´d write in the WHERE clause of an Sql query right there.

                    Hope it helps!



::Alita::

http://p2p.wrox.com/topic.asp?TOPIC_ID=6389

HTH.

Always:),
Hovik Melkomian.