p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

crystal_reports thread: Re: CR Error Msg


Message #1 by "Trung Than Chieu Le" <chieutrung@h...> on Wed, 05 Dec 2001 18:30:46 +0700
Hi Michel,



You can use the Format() function in SELECT statement with a numbering field 

as follow:

  SELECT Format(CustomerID,"00#") As CusID, CustomerName

  FROM Customers

The CR8 doesn't support Format() function.



Good Luck



Trung





>From: "Preethi" <preethi@s...>

>Reply-To: "crystal_reports" <crystal_reports@p...>

>To: "crystal_reports" <crystal_reports@p...>

>Subject: [crystal_reports] Re: Error Msg

>Date: Wed, 5 Dec 2001 12:40:00 +0600

>

>1.    Please read the chain in crystal reports

>

>http://p2p.wrox.com/view.asp?list=crystal_reports&id=123488

>

>2.     Let me assume that you are planning to display a serial no 1, 2...

>etc in 0001, 0002 format.

>

>     First create a Formula with this code

>

>WhilePrintingRecords;

>NumberVar sNo;

>Stringvar sSerial;

>sNo := sNo+1;

>sSerial:=Right("0000"+ Trim(CStr(sNo,0)),4);

>

>This will display what you may want.

>

>Good Luck

>

>Preethi

>

>

>----- Original Message -----

>From: "Michel Medawar" <mmedawar@t...>

>To: "crystal_reports" <crystal_reports@p...>

>Sent: Wednesday, December 05, 2001 11:18 AM

>Subject: [crystal_reports] Re: Error Msg

>

>

> > Hi Preethi

> >

> > Yes my database is access, but where can i find the datafiles(0) 

>property

> > and how can i use it.

> >

> > I have another question please, let's suppose that i have a customer 

>name

> > 1 or 2 and i want it to be displayed 001 or 0001 in the report, how can 

>i

> > do it please???

> >

> > Thanks in advance

> >

> > Michel Medawar

> >

> >

> >

> > ----- Original Message -----

> > From: "Preethi" <preethi@s...>

> > To: "crystal_reports" <crystal_reports@p...>

> > Sent: Tuesday, December 04, 2001 4:38 AM

> > Subject: [crystal_reports] Re: Error Msg

> >

> >

> > > What is the database you are using?

> > > If access you can set the datafiles(0)  property

> > > if SQLServer/ Oracle set the connectionstring

> > > Preethi

> > >

> > > ----- Original Message -----

> > > From: <mmedawar@t...>

> > > To: "crystal_reports" <crystal_reports@p...>

> > > Sent: Monday, December 03, 2001 3:18 PM

> > > Subject: [crystal_reports] Error Msg

> > >

> > >

> > > > Hi

> > > >

> > > > When i reconnect to the database in desgin view, it works, but i 

>can't

> > do

> > > that for every report in every user's pc.

> > > >

> > > > pls reply

> > > >

> > > >



>preethi@s...


> > > $subst('Email.Unsub')

> > > >

> > > > Read the future with ebooks at B&N

> > > >

> > >

> >

>http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid

> > > =rn_ebooks

> > >

> > >



>mmedawar@t...


> > $subst('Email.Unsub')

> > >

> > >

> >

> >

> >




>$subst('Email.Unsub')

>

>




>$subst('Email.Unsub')

>





_________________________________________________________________

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp




  Return to Index