By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,669 Members | 2,203 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,669 IT Pros & Developers. It's quick & easy.

Sending parameters from VB.NET to crystal report

P: n/a
Hi, pls clarify these 2 questions.

1. How can I send some values of globla variables from VB.NET to
crystal report.
I want to show these values on report.

2. I have added an SQL query in my crystal report through "Add
Command" .

My query is as follows...

select b.btdnumber as btdnumber,
b.btdtrfno as bbtdtrfno,
a.btdtrfno as btdtrfnohidden,
a.BtdAcno as BtdAcno,
a.BtdCertNo as BtdCertNo,
a.BtdShare as BtdShare
from shrbatchdetail a
right outer join shrbatchdetail b
on a.btdrecid = b.btdrecid
and a.btdsellbuy = 'S'
and b.btdnumber = 123

In the above query b.btdnumber value is not static. I want to send
this values dynamically from VB.NET (in the event of showing the
report).
If I use parameter field , System is prompting for the value at run
time.
How can I set this automatically?

-Omav
Jul 21 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.