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

Posted on 2004-03-22
Medium Priority
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.

Question by:comsult
  • 2

Accepted Solution

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,

Author Comment

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.

Author Comment

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

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…

607 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