Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Generating Data Reports based on a criteria

Posted on 2003-03-15
6
Medium Priority
?
199 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
5 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Introduction to Processes

572 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