| | |
Crystal Report Selection Formula....
Please support our VB.NET advertiser: Programming Forums - DaniWeb Sister Site
Thread Solved |
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....
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....
![]() |
Similar Threads
- Issue about passing parameter to Crystal Report 11.. (Visual Basic 4 / 5 / 6)
- How to launch a Crystal 11 report from VB6 (Visual Basic 4 / 5 / 6)
- Parameters in crystal report + vb.net (VB.NET)
- Pass Criteria to Crystal Report 8 Using Visual Basic 6 (Visual Basic 4 / 5 / 6)
- crystal report related.........simple one......Please take 2 min to read this... (VB.NET)
- Crystal Report8.5.... (VB.NET)
- selction formula (Visual Basic 4 / 5 / 6)
- How can I pass values to Crystal 9 “Formulas� and “Selection Formula� with VB6 (Visual Basic 4 / 5 / 6)
Other Threads in the VB.NET Forum
- Previous Thread: mouse and keys
- Next Thread: nid help in encrypt password
Views: 4746 | Replies: 1
| Thread Tools | Search this Thread |
Tag cloud for VB.NET
"crystal .net .net2005 2008 access add application array assignment basic box button buttons center class click code combo convert cpu data database datagrid datagridview design designer dissertation dissertations dissertationthesis dosconsolevb.net editvb.net employees error excel exists firewall function image images isnumericfuntioncall listview login map math memory mobile module msaccess mssqlbackend mysql navigate net opacity page pan picturebox port print printing printpreview problem record refresh regex reports" reuse right-to-left save savedialog search serial socket sorting sql sqldatbase storedprocedure string structures studio temp textbox timer txttoxmlconverter upload useraccounts usercontol usercontrol vb vb.net vb.nettoolboxvisualbasic2008sidebar vb2008 vbnet vista visual visualbasic visualbasic.net visualstudio2008 web wpf xml





