Crystal Report Selection Formula....

Please support our VB.NET advertiser: Programming Forums - DaniWeb Sister Site
Thread Solved

Join Date: Jan 2008
Posts: 178
Reputation: sbv is an unknown quantity at this point 
Solved Threads: 8
sbv's Avatar
sbv sbv is offline Offline
Junior Poster

Crystal Report Selection Formula....

 
0
  #1
Feb 14th, 2008
hello friends,
i am sending selection formula from code.
something like ...
CrystalReportViewer.selectionFormula = {MyViewForReport.Q_code}=" & cboQ.Item(i).value

my req. is i want to send multiple values with " and " , "or"

what i did is -

"{VoterRegDetail_Qry.QualificationCode} = 1 and {VoterRegDetail_Qry.CasteCode} = 19 Or {VoterRegDetail_Qry.CasteCode} = 20"

But its not wht i needed.

the req is as select the records having
QualificationCode = 1 and CasteCode = 19 or 20

some thing like need to write IN query. (which gives result)

but how to do that here....
can any one know....
plz help....
Reply With Quote Quick reply to this message  
Join Date: Jan 2008
Posts: 178
Reputation: sbv is an unknown quantity at this point 
Solved Threads: 8
sbv's Avatar
sbv sbv is offline Offline
Junior Poster

Re: Crystal Report Selection Formula....

 
0
  #2
Feb 15th, 2008
Hey, its solved. I used this type of solution.

"{VoterRegDetail_Qry.QualificationCode} = 1 and ({VoterRegDetail_Qry.CasteCode} = 19 Or {VoterRegDetail_Qry.CasteCode} = 20)"
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:




Views: 4746 | Replies: 1
Thread Tools Search this Thread



Tag cloud for VB.NET
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC