vivvek29
asked on
Generating Data Reports based on a criteria
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
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
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
points to emoreau
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