?
Solved

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

Posted on 2004-03-22
3
Medium Priority
?
440 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 feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
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…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

762 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