• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 443
  • Last Modified:

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

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
comsult
Asked:
comsult
  • 2
1 Solution
 
dante469Commented:
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
 
comsultAuthor Commented:
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
 
comsultAuthor Commented:
Thanks for the help, I managed to work out the referencing. It works perfectly now.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now