Click here to Skip to main content
15,912,977 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questionhelp me Pin
Yar e Mehrban9-Jan-07 1:11
Yar e Mehrban9-Jan-07 1:11 
AnswerRe: help me Pin
rama charan9-Jan-07 2:16
rama charan9-Jan-07 2:16 
AnswerRe: help me Pin
Dave Kreskowiak9-Jan-07 4:22
mveDave Kreskowiak9-Jan-07 4:22 
Questionhow to get File's contents the txt and Doc files Using VB.Net Pin
somagunasekaran9-Jan-07 1:04
somagunasekaran9-Jan-07 1:04 
AnswerRe: how to get File's contents the txt and Doc files Using VB.Net Pin
Dave Kreskowiak9-Jan-07 6:25
mveDave Kreskowiak9-Jan-07 6:25 
GeneralRe: how to get File's contents the txt and Doc files Using VB.Net Pin
somagunasekaran9-Jan-07 18:24
somagunasekaran9-Jan-07 18:24 
GeneralRe: how to get File's contents the txt and Doc files Using VB.Net Pin
Dave Kreskowiak10-Jan-07 3:25
mveDave Kreskowiak10-Jan-07 3:25 
QuestionPassing Null Parameter to Crystal reports Pin
charchabil039-Jan-07 0:32
charchabil039-Jan-07 0:32 
Private Sub BPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BPrint.Click<br />
        Dim frm As New FrmPrintReport 'reports<br />
        Dim cr As New CRepResponsable<br />
        cr.SetParameterValue(0, Val(Me.TBAccountNumber.Text))'integer<br />
        cr.SetParameterValue(1, Me.TBAccountNumber.Text)'string<br />
        cr.SetParameterValue(2, vbNull) 'integer<br />
        cr.SetParameterValue(3, vbNull) 'string<br />
        <br />
        frm.CrystalReportViewer.ReportSource = cr<br />
        frm.MdiParent = Me.MdiParent<br />
        frm.Show()<br />
End Sub


i have the code above. i could not pass a null parameter, to the crystal reports. i will have an empty report Cry | :(( i tried vbnull.null and vbnull.empty same result.
but if I put
cr.SetParameterValue(2, Val(Me.TBSubAccount.Text))) 'integer 'not null<br />
cr.SetParameterValue(3, Me.TBSubAccount.Text) 'string 'not null

the report display the values.
here is the select expert formula (CR):
{CUSTOMERS.SUB_ACCOUNT_NUMBER} = {?SubAccount_String} and<br />
{ecole.serial} = {?AccountNumber} and<br />
{CUSTOMERS.ACCOUNT_NUMBER} = {?AccountNumber_String} and<br />
{ecole.sub_account} = {?SubAccount} 


How could i pass a null parameter?

Regards
Ramy

Question how to create setup for console applns which have report? Pin
rama charan9-Jan-07 0:31
rama charan9-Jan-07 0:31 
AnswerRe: how to create setup for console applns which have report? Pin
Dave Kreskowiak9-Jan-07 4:19
mveDave Kreskowiak9-Jan-07 4:19 
QuestionRich Text Box Pin
saymajum8-Jan-07 20:11
saymajum8-Jan-07 20:11 
AnswerRe: Rich Text Box Pin
Christian Graus8-Jan-07 20:29
protectorChristian Graus8-Jan-07 20:29 
GeneralRe: Rich Text Box Pin
saymajum8-Jan-07 21:57
saymajum8-Jan-07 21:57 
JokeRe: Rich Text Box Pin
CPallini8-Jan-07 22:06
mveCPallini8-Jan-07 22:06 
GeneralRe: Rich Text Box Pin
saymajum8-Jan-07 22:14
saymajum8-Jan-07 22:14 
GeneralRe: Rich Text Box Pin
CPallini8-Jan-07 22:19
mveCPallini8-Jan-07 22:19 
GeneralRe: Rich Text Box Pin
saymajum8-Jan-07 22:41
saymajum8-Jan-07 22:41 
GeneralRe: Rich Text Box Pin
CPallini8-Jan-07 22:44
mveCPallini8-Jan-07 22:44 
GeneralRe: Rich Text Box Pin
Christian Graus8-Jan-07 23:28
protectorChristian Graus8-Jan-07 23:28 
QuestionAssigning values to arrays. Pin
someone_blank8-Jan-07 19:50
someone_blank8-Jan-07 19:50 
AnswerRe: Assigning values to arrays. Pin
Christian Graus8-Jan-07 20:58
protectorChristian Graus8-Jan-07 20:58 
GeneralRe: Assigning values to arrays. Pin
someone_blank9-Jan-07 13:29
someone_blank9-Jan-07 13:29 
AnswerRe: Assigning values to arrays. Pin
CPallini8-Jan-07 22:02
mveCPallini8-Jan-07 22:02 
Questionunable to load .dsr(designer) files in vb6-Sp6. Pin
MissionSuccess8-Jan-07 19:01
MissionSuccess8-Jan-07 19:01 
AnswerRe: unable to load .dsr(designer) files in vb6-Sp6. Pin
Dave Kreskowiak9-Jan-07 4:16
mveDave Kreskowiak9-Jan-07 4:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.