469,267 Members | 1,089 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,267 developers. It's quick & easy.

passing null parameter

Expand|Select|Wrap|Line Numbers
  1. Private Sub BPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BPrint.Click
  2. Dim frm As New FrmPrintReport 'reports
  3. Dim cr As New CRepResponsable
  4. cr.SetParameterValue(0, Val(Me.TBAccountNumber.Text))'integer
  5. cr.SetParameterValue(1, Me.TBAccountNumber.Text)'string
  6. cr.SetParameterValue(2, vbNull) 'integer
  7. cr.SetParameterValue(3, vbNull) 'string
  9. frm.CrystalReportViewer.ReportSource = cr
  10. frm.MdiParent = Me.MdiParent
  11. frm.Show()
  12. End Sub
  14. i have the code above. i could not pass a null parameter, to the crystal reports. i will have an empty report  i tried vbnull.null and vbnull.empty same result.
  15. but if I put
  16. cr.SetParameterValue(2, Val(Me.TBSubAccount.Text))) 'integer 'not null
  17. cr.SetParameterValue(3, Me.TBSubAccount.Text) 'string 'not null
  18. the report display the values.
here is the select expert formula (CR):
Expand|Select|Wrap|Line Numbers
  1. {CUSTOMERS.SUB_ACCOUNT_NUMBER} = {?SubAccount_String} and
  2. {ecole.serial} = {?AccountNumber} and
  3. {CUSTOMERS.ACCOUNT_NUMBER} = {?AccountNumber_String} and
  4. {ecole.sub_account} = {?SubAccount} 
How could i pass a null parameter?
Jan 9 '07 #1
2 2002
121 100+
you can't just pass "" as an empty string instead of a null value?
Jan 9 '07 #2
4,871 Expert 4TB
Have you tried DBNull.Value?

Hope that this helps.
Jan 10 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Bucky Pollard | last post: by
6 posts views Thread by MSDNAndi | last post: by
12 posts views Thread by Andrew Bullock | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.