Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 22nd, 2004, 01:49 AM
Registered User
Join Date: Sep 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to suni_kutty
Default Crystal report, passing parameter

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#

Old September 22nd, 2004, 02:04 AM
Registered User
Join Date: Sep 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Alita


   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!

Old October 7th, 2004, 03:13 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik



Hovik Melkomian.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Passing Parameter in Crystal report 10 aarunlal ASP.NET 2.0 Professional 2 April 25th, 2007 05:57 AM
crystal report passing multiple parameter noppanit C# 0 March 20th, 2007 12:32 PM
Passing runtime parameter to Crystal Report renishl Crystal Reports 1 May 30th, 2006 12:38 AM
Passing a parameter from VB6 to Crystal Report pavel Pro VB Databases 2 February 2nd, 2005 11:28 PM
passing parameter to crystal report.net shamala Crystal Reports 2 August 19th, 2004 02:04 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.