Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2004-03-22
3
Medium Priority
?
441 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
dante469 earned 1500 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

618 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