Solved

VB.Net Using dropdownlist value on WebForm to populate Crystal Report

Posted on 2004-03-22
3
437 Views
Last Modified: 2012-06-27
I have a small VB.Net Web Application with two Web Forms. I have a populated DDL on the first form. Using server.transfer I can pass the DDL.selecteditemvalue to the second web form and display it in a label, text box etc. with no problems.

I also have a Crystal Report on the second web form, with a viewer. How do I use the value I have passed from the DDL in the SQL statement on the Crystal Report. For example select a from b where c = ddl.selecteditemvalue.

Any help would be appreciated.

0
Comment
Question by:comsult
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
dante469 earned 500 total points
ID: 10650129
Easiest solution is to place the passed value in a textbox on the destination form (maybe even set .visibility to false) and reference as normal from Crystal...

Have Fun,
Dante
0
 

Author Comment

by:comsult
ID: 10650211
Sorry for such a daft question (quite new to this !). I am used to adding my database fields to Crystal in .Net but how do I reference a textbox ?

Thanks for the help.
0
 

Author Comment

by:comsult
ID: 10653919
Thanks for the help, I managed to work out the referencing. It works perfectly now.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question