954,551 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Parameters in crystal report + vb.net

hi friends

Iam developing my appliction in vs.net2003 & ms access.I am creating reports using crystal report.I want to filter the output of report.User has to select the option which data has to be display in reports.I used the parmeter wizard to sort data.But if I add new data in database it display blank report.What goes wrong I don't know.Plz help me

poonams
Newbie Poster
23 posts since Oct 2007
Reputation Points: 10
Solved Threads: 0
 

to filter u can use CrystalReportViewer.SelectionFormula;
For examaple To filter by a Customer_Id = 1
u can use
CrystalReportViewer.SelectionFormula ="Where Customer_Id = 1"

if u r using multiple selection formula u hav to use "and" or "or" to combine it

ArshadSalim
Newbie Poster
1 post since Nov 2007
Reputation Points: 10
Solved Threads: 1
 

i think Arshad already give the solution

CrystalReportViewer.SelectionFormula() = "{Student.id_student}='" & Trim(txtIdStudent.text) & "' "

Student is the table Name & id_student is parameter

Jx_Man
Nearly a Senior Poster
3,329 posts since Nov 2007
Reputation Points: 1,372
Solved Threads: 444
 

use selection formula field , If u dont know how to use it , check this link

http://vb.net-informations.com/crystal-report/vb.net_crystal_report_formula_fields.htm

brol

lukabrol
Newbie Poster
4 posts since Jul 2008
Reputation Points: 10
Solved Threads: 0
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You