p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

crystal_reports thread: CR question


Message #1 by "Enzo Zaragoza" <enzaux@g...> on Wed, 20 Nov 2002 09:54:24 +0800

	I'm using VB6 and Crystal Report 8.5.  I'm still currently exploring CR and I have these questions:

1.) How can I set my number field from 1 to 0001 or NO-0001? some one told me to use ToText but I dont't 
    know where to put this?  It tried to look at the format options but I can't where to put the formatting
2.) When using the crystal report application on VB form and I try to open a report having a dbase passworded,
    why is it that I have to add chr(0) and then the password again?  If I haven't see the code I've downloaded
    from planetsource code i wouldn't know that it would be enter like this.
    for ex:
     With CrystalReport1
      .DataFiles(0) = app.path & "\MyDB.mdb"
      .ReportFileName = App.Path & "\Reports\rptBalances.rpt"
      .SelectionFormula = "{qryPaymentsNBalances.AgentType} = 'LOCAL'"
      .UserName = "Admin"
      .Password = "enzo" & Chr(10) & "enzo"
      .Action = 1
     End With 	
		

Thanks,


Enzo c",)
YahooID: yackydidakdak

Message #2 by Zulfazli <Zulfazli@l...> on Wed, 20 Nov 2002 10:22:23 +0700
Sorry I don't know the answer about your question no 2, but for no 1 :
You just make a formula field and then put this code below in the box code
of that formula and then put the formula field into your report.

Code :
  "NO-" & totext({yourtable.yourfield},"0000")

Hth
Zulfazli

-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...] 
Sent: Wednesday, November 20, 2002 8:54 AM
To: crystal_reports
Subject: [crystal_reports] CR question




	I'm using VB6 and Crystal Report 8.5.  I'm still currently exploring
CR and I have these questions:

1.) How can I set my number field from 1 to 0001 or NO-0001? some one told
me to use ToText but I dont't 
    know where to put this?  It tried to look at the format options but I
can't where to put the formatting
2.) When using the crystal report application on VB form and I try to open a
report having a dbase passworded,
    why is it that I have to add chr(0) and then the password again?  If I
haven't see the code I've downloaded
    from planetsource code i wouldn't know that it would be enter like this.
    for ex:
     With CrystalReport1
      .DataFiles(0) = app.path & "\MyDB.mdb"
      .ReportFileName = App.Path & "\Reports\rptBalances.rpt"
      .SelectionFormula = "{qryPaymentsNBalances.AgentType} = 'LOCAL'"
      .UserName = "Admin"
      .Password = "enzo" & Chr(10) & "enzo"
      .Action = 1
     End With 	
		

Thanks,


Enzo c",)
YahooID: yackydidakdak


Message #3 by "Enzo Zaragoza" <enzaux@g...> on Wed, 20 Nov 2002 11:53:44 +0800
	Thanks Zulfazli!!!!

Thanks,

enzo c",)

-----Original Message-----
From: Zulfazli [mailto:Zulfazli@l...]
Sent: Wednesday, November 20, 2002 11:22 AM
To: crystal_reports
Subject: [crystal_reports] RE: CR question


Sorry I don't know the answer about your question no 2, but for no 1 :
You just make a formula field and then put this code below in the box code
of that formula and then put the formula field into your report.

Code :
  "NO-" & totext({yourtable.yourfield},"0000")

Hth
Zulfazli

-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...] 
Sent: Wednesday, November 20, 2002 8:54 AM
To: crystal_reports
Subject: [crystal_reports] CR question




	I'm using VB6 and Crystal Report 8.5.  I'm still currently exploring
CR and I have these questions:

1.) How can I set my number field from 1 to 0001 or NO-0001? some one told
me to use ToText but I dont't 
    know where to put this?  It tried to look at the format options but I
can't where to put the formatting
2.) When using the crystal report application on VB form and I try to open a
report having a dbase passworded,
    why is it that I have to add chr(0) and then the password again?  If I
haven't see the code I've downloaded
    from planetsource code i wouldn't know that it would be enter like this.
    for ex:
     With CrystalReport1
      .DataFiles(0) = app.path & "\MyDB.mdb"
      .ReportFileName = App.Path & "\Reports\rptBalances.rpt"
      .SelectionFormula = "{qryPaymentsNBalances.AgentType} = 'LOCAL'"
      .UserName = "Admin"
      .Password = "enzo" & Chr(10) & "enzo"
      .Action = 1
     End With 	
		

Thanks,


Enzo c",)
YahooID: yackydidakdak






Message #4 by "Enzo Zaragoza" <enzaux@g...> on Wed, 20 Nov 2002 12:15:14 +0800
	One more thing :p I hope it's ok with you :D  how could I change the data of
a particular text box in the report?  for example:  I want to change the text box
having data qry1.Field with qry2.Field1

Thanks,

enzo c",)

-----Original Message-----
From: Zulfazli [mailto:Zulfazli@l...]
Sent: Wednesday, November 20, 2002 11:22 AM
To: crystal_reports
Subject: [crystal_reports] RE: CR question


Sorry I don't know the answer about your question no 2, but for no 1 :
You just make a formula field and then put this code below in the box code
of that formula and then put the formula field into your report.

Code :
  "NO-" & totext({yourtable.yourfield},"0000")

Hth
Zulfazli

-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...] 
Sent: Wednesday, November 20, 2002 8:54 AM
To: crystal_reports
Subject: [crystal_reports] CR question




	I'm using VB6 and Crystal Report 8.5.  I'm still currently exploring
CR and I have these questions:

1.) How can I set my number field from 1 to 0001 or NO-0001? some one told
me to use ToText but I dont't 
    know where to put this?  It tried to look at the format options but I
can't where to put the formatting
2.) When using the crystal report application on VB form and I try to open a
report having a dbase passworded,
    why is it that I have to add chr(0) and then the password again?  If I
haven't see the code I've downloaded
    from planetsource code i wouldn't know that it would be enter like this.
    for ex:
     With CrystalReport1
      .DataFiles(0) = app.path & "\MyDB.mdb"
      .ReportFileName = App.Path & "\Reports\rptBalances.rpt"
      .SelectionFormula = "{qryPaymentsNBalances.AgentType} = 'LOCAL'"
      .UserName = "Admin"
      .Password = "enzo" & Chr(10) & "enzo"
      .Action = 1
     End With 	
		

Thanks,


Enzo c",)
YahooID: yackydidakdak







  Return to Index