?
Solved

Generating Data Reports based on a criteria

Posted on 2003-03-15
6
Medium Priority
?
198 Views
Last Modified: 2010-04-29
I hv created a VB application from which i want to generate Datareports.
I was successful in displaying all the records present in the Database Access, but when trying to display a particular record with criteria, say a data present in textbox, i get blank in the data report.

i used the following SQL:

select no,name,dob from <tablename> where name='"&text2.text&"' in the dataenvironment.

pl adv
0
Comment
Question by:vivvek29
[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
6 Comments
 
LVL 1

Expert Comment

by:Piter
ID: 8141905
HI vivvek29,
 i think in Datareport you cant pass  any parameter.
 You will get All records from database but if you want records related to any particuler id or name .. it is not possible in datareport.
 For that You have to use Crystal report only. there u can pass perticuler parameter to get details of it.

Piter
0
 

Expert Comment

by:AbhijitCPatil
ID: 8142428
Hi Vivek29

Data report has many restrictions
you can use Crystal Reports with this tool
you can generate any kind of report
along with graphs also

you can also pass criteria to restrict that fileds



0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 200 total points
ID: 8142600
0
 

Expert Comment

by:CleanupPing
ID: 9447126
vivvek29:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 9447310
points to emoreau
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Make the most of your online learning experience.
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
Simple Linear Regression
Six Sigma Control Plans
Suggested Courses
Course of the Month8 days, 10 hours left to enroll

764 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