Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Components
|
VB Components Issues specific to components in VB.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Components 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 17th, 2004, 01:39 PM
Authorized User
 
Join Date: Sep 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Milan
Default How to pass a query value from vb to crystal repor

when i tried to use selectionformula using query
there shows some error

with crystalReport
.....
.....
.selection=""
.action
how to pass multiple values form to a table

 
Old September 28th, 2004, 01:15 AM
Friend of Wrox
 
Join Date: Sep 2004
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Anantsharma Send a message via Yahoo to Anantsharma
Default

HI,

Well U must be adding the CrystalReport component to your form.

If u want to pass a SQL Query to Crystal report, you can use the Property "SqlQuery".

CrystalReport1.SqlQuery = "Select ..........From..... Where ..."

Another way if u want to use "SelectionFormula", u must be very clear about the Syntax. Please refer MSDN for syntax. For ur idea , you must enclose the formula withing curly braces ....

SystalReport1.SelectionFormula = {"......... ..=....."}

Somting like that.

Hope this helps.

B. Anant
 
Old November 2nd, 2004, 09:50 AM
Authorized User
 
Join Date: Sep 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Milan
Default

hi all
if u need any doubt in Crystal Report just mail me

[email protected]








Similar Threads
Thread Thread Starter Forum Replies Last Post
Load of Report failed --vb.net 2003, Crystal repor avats Crystal Reports 0 October 23rd, 2005 01:19 PM
how to pass sql query to crystal through vb.net dranjithreddy Crystal Reports 0 June 7th, 2005 05:15 AM
How can I pass sql query through vb.net to crystal sachinbashetti Crystal Reports 0 May 14th, 2005 01:47 AM
How to adjust several SQL scripts in crystal repor juma Crystal Reports 0 July 10th, 2004 01:34 AM
Passing a parameter from VB6 code to Crystal Repor pavel VB How-To 0 July 17th, 2003 09:09 AM





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