Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > .NET 1.0 and Visual Studio.NET > BOOK: Professional Crystal Reports for VS.NET
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
BOOK: Professional Crystal Reports for VS.NET
This is the forum to discuss the Wrox book Professional Crystal Reports for Visual Studio .NET by David McAmis; ISBN: 9780764544033
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Crystal Reports for VS.NET section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 10th, 2005, 04:38 AM
Authorized User
 
Join Date: Sep 2005
Location: Hydrabad, AP, India.
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to vijaykumartaduri Send a message via Yahoo to vijaykumartaduri
Default How to pass parameter value to CR SQL Command

I have created reports using crystalreport9.0 and PULL method.

ex: "SELECT * FROM XYZ"

And also created parameter field for this above query like

{Command.ID}={?ID}.

While i accessing this above report, first it loading all the data into memory after that only it is filltering data using above parametervalue.

Pls let me tell how can i pass value into query at firat time itself.

Thankx



__________________
Thanks,
Vijay Kumar Taduri
Reply With Quote
  #2 (permalink)  
Old May 30th, 2006, 07:42 AM
Registered User
 
Join Date: May 2006
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi vijay,
  if you have given the above condition in record selection of the CR,than the CR fetches record by record and when the condition is true,it collects in the memory and finally displays it in the front end.hope you got where to giv the filter condition

thanx

rupi
Reply With Quote
  #3 (permalink)  
Old August 24th, 2006, 10:27 AM
Authorized User
 
Join Date: Aug 2006
Location: , , United Kingdom.
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,
I am New to ASP. Need your help please.
I am working with Oracle Database and ASP.

I am having problem to pass value from dropdown list to another ASP to SQL statement. Below are codes:

[u]First Page code:</u>
<html>
<head>
<title>test</title>
</head>
<body>
<form name="test" action="patients.asp" method="POST">
Select Ward:
<select name="wardlist">
<option value="Arnwood">Arnwood</option>
<option value="Beacon">Beacon</option>
</select>
<input type="submit" value="Submit">
<input type="Reset" name="Reset">
</form>
</body>
</html

[u]Main Page:</u>

<%
    Dim paraval
    paraval = Request.Form("wardlist")

    Set conn = Server.CreateObject("ADODB.Connection")
    conn.open "PIMSP_MHLD","REPORT","REPORT"
    Set Session("PIMSP_MHLD_conn") = conn

    Set rs = Server.CreateObject("ADODB.Recordset")
    rs.Open sql, conn,3,3

sql="SELECT spont.shortname..... WHERE spont.shortname = & paraval &"
%>
....
....

Thanks in Advance

Thamil

Reply With Quote
  #4 (permalink)  
Old July 31st, 2007, 12:13 AM
Registered User
 
Join Date: Jul 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to veluworld
Default

Quote:
quote:Originally posted by Thamil
 Hi,
I am New to ASP. Need your help please.
I am working with Oracle Database and ASP.

I am having problem to pass value from dropdown list to another ASP to SQL statement. Below are codes:

[u]First Page code:</u>
<html>
<head>
<title>test</title>
</head>
<body>
<form name="test" action="patients.asp" method="POST">
Select Ward:
<select name="wardlist">
<option value="Arnwood">Arnwood</option>
<option value="Beacon">Beacon</option>
</select>
<input type="submit" value="Submit">
<input type="Reset" name="Reset">
</form>
</body>
</html

[u]Main Page:</u>

<%
    Dim paraval
    paraval = Request.Form("wardlist")

    Set conn = Server.CreateObject("ADODB.Connection")
    conn.open "PIMSP_MHLD","REPORT","REPORT"
    Set Session("PIMSP_MHLD_conn") = conn

    Set rs = Server.CreateObject("ADODB.Recordset")

sql="SELECT spont.shortname..... WHERE spont.shortname = & paraval &"
    rs.Open sql, conn,3,3


%>
....
....

Thanks in Advance

Thamil

sql="SELECT spont.shortname... WHERE spont.shortname = '"&paraval &"'"
rs.Open sql, conn,3,3

U missed Quotes & Wrong placed rs.open
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server StoredProcedure Parameter pass erictamlam C# 2005 3 March 27th, 2007 01:31 AM
How to pass Table Name as a parameter in SQL query visualbrin Reporting Services 1 October 13th, 2006 04:08 PM
Pass Date parameter from jsp to CR ray5 Crystal Reports 0 September 6th, 2005 09:23 PM
Pass Crystal parameter to a SQL sp cphspain Crystal Reports 5 January 27th, 2005 07:03 AM
how to pass the data from dataset to CR? zouky Crystal Reports 0 November 8th, 2004 02:49 AM



All times are GMT -4. The time now is 02:43 AM.


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