VFP Report : Century On / Off

Hello

I wrote 'set century off'. Then I executed a VFP report. I can see the dates properly. e.g. 19/05/04. But if I click on the report (preview mode) the date becomes 19/05/2004. This happens everytime

Any solutions
Thanks
Prashant

Anders
Wed May 19 07:32:26 CDT 2004

Is the report using a private datasession where SET CENTURY is ON?
-Anders

"Prashant" <prashantpsoft@rediffmail.com> wrote in message
news:45934624-8EC9-4997-9F37-6B991DAE1975@microsoft.com...
> Hello,
>
> I wrote 'set century off'. Then I executed a VFP report. I can see the
dates properly. e.g. 19/05/04. But if I click on the report (preview mode)
the date becomes 19/05/2004. This happens everytime.
>
> Any solutions ?
> Thanks.
> Prashant

Rick
Wed May 19 08:08:40 CDT 2004

What version and service pack level of VFP are you using? When you say =
"I executed a VFP report", are you saying when you print it, it prints =
correctly? Are you calling the report from a Form? Does the form or the =
reoprt use a private datasession?

Rick

"Prashant" <prashantpsoft@rediffmail.com> wrote in message =
news:45934624-8EC9-4997-9F37-6B991DAE1975@microsoft.com...
> Hello,
>=20
> I wrote 'set century off'. Then I executed a VFP report. I can see the =
dates properly. e.g. 19/05/04. But if I click on the report (preview =
mode) the date becomes 19/05/2004. This happens everytime.
>=20
> Any solutions ?
> Thanks.
> Prashant

anonymous
Wed May 19 08:31:04 CDT 2004

Hi Rick

It is VFP6
I do not know how to use a private datasession. Moreover on menu bar, in reports, private data session is not ticked
I am only previewing the report. If I click on the page previewed, or even if I click print preview toolbar the century turns on
Please reply
Prashant


----- Rick Bean wrote: ----
What version and service pack level of VFP are you using? When you say "I executed a VFP report", are you saying when you print it, it prints correctly? Are you calling the report from a Form? Does the form or the reoprt use a private datasession
Ric

prashantpsoft
Wed May 19 08:31:07 CDT 2004

Hi Anders,

I do not know how to use a private datasession. Moreover on menu bar, in reports, private data session is not ticked.
I am only previewing the report. If I click on the page previewed, or even if I click print preview toolbar the century turns on.

Please reply,
Prashant.


----- Anders Altberg wrote: -----

Is the report using a private datasession where SET CENTURY is ON?
-Anders

"Prashant" <prashantpsoft@rediffmail.com> wrote in message
news:45934624-8EC9-4997-9F37-6B991DAE1975@microsoft.com...
> Hello,
>> I wrote 'set century off'. Then I executed a VFP report. I can see the
dates properly. e.g. 19/05/04. But if I click on the report (preview mode)
the date becomes 19/05/2004. This happens everytime.
>> Any solutions ?
> Thanks.
> Prashant

Rick
Wed May 19 10:19:46 CDT 2004

If you are running with Service Pack 5, you should consider updating. =
SP3 added features and SP1 -> SP5 fixed a number of problems. You can =
get the SP by going to =
http://msdn.microsoft.com/vstudio/downloads/updates/sp/vs6/sp5/default.as=
px.

Rick

"Prashant" <anonymous@discussions.microsoft.com> wrote in message =
news:C9955C3C-5692-4C62-9C15-40B6BE15E914@microsoft.com...
> Hi Rick,
>=20
> It is VFP6.
> I do not know how to use a private datasession. Moreover on menu bar, =
in reports, private data session is not ticked.
> I am only previewing the report. If I click on the page previewed, or =
even if I click print preview toolbar the century turns on.
> Please reply,
> Prashant.
>=20
> =20
> ----- Rick Bean wrote: -----
> What version and service pack level of VFP are you using? When =
you say "I executed a VFP report", are you saying when you print it, it =
prints correctly? Are you calling the report from a Form? Does the form =
or the reoprt use a private datasession?
> Rick
>

Edhy
Wed May 19 22:09:08 CDT 2004

Hi Prashant,

Open the report and then open the Dataenvironment, double click anywhere in
the dataenvironment to go to the BeforeOpenTables method and type your
command there.

--
Edhy Rijo
Programming System Solutions www.progytech.com
Bronx NY


"Prashant" <prashantpsoft@rediffmail.com> wrote in message
news:45934624-8EC9-4997-9F37-6B991DAE1975@microsoft.com...
> Hello,
>
> I wrote 'set century off'. Then I executed a VFP report. I can see the
dates properly. e.g. 19/05/04. But if I click on the report (preview mode)
the date becomes 19/05/2004. This happens everytime.
>
> Any solutions ?
> Thanks.
> Prashant

Anders
Fri May 21 15:27:55 CDT 2004

Have you tried running the program in the Debugger Trace up to the point
where REPORT FORM is called to see if there's anything that could change you
data setting. If there's northing, take a look in the methods of the reports
DataEnviron,ment - Any code hiding here?
Why is this as problem? 19/05/2004 looks like a very clear and unambiguous
date that shouldn't confuse anyone aboput the year at least. A date like
04/05/06 means different things in the US, the UK and Sweden or Japan.
-Anders


"Prashant" <prashantpsoft@rediffmail.com> wrote in message
news:DC57FEE7-CD39-40CA-90D9-0BCD2A56E8F2@microsoft.com...
> Hi Anders,
>
> I do not know how to use a private datasession. Moreover on menu bar, in
reports, private data session is not ticked.
> I am only previewing the report. If I click on the page previewed, or even
if I click print preview toolbar the century turns on.
>
> Please reply,
> Prashant.
>
>
> ----- Anders Altberg wrote: -----
>
> Is the report using a private datasession where SET CENTURY is ON?
> -Anders
>
> "Prashant" <prashantpsoft@rediffmail.com> wrote in message
> news:45934624-8EC9-4997-9F37-6B991DAE1975@microsoft.com...
> > Hello,
> >> I wrote 'set century off'. Then I executed a VFP report. I can see
the
> dates properly. e.g. 19/05/04. But if I click on the report (preview
mode)
> the date becomes 19/05/2004. This happens everytime.
> >> Any solutions ?
> > Thanks.
> > Prashant
>
>

prashantpsoft
Sun May 23 02:51:03 CDT 2004

Hi Edhy

Thanks a lot
You have a done a great job for me. But I still cannot figure out why the century turned on automatically. I had not written any commands in the data environment
Prashant

----- Edhy Rijo wrote: ----

Hi Prashant

Open the report and then open the Dataenvironment, double click anywhere i
the dataenvironment to go to the BeforeOpenTables method and type you
command there

--
Edhy Rij
Programming System Solutions www.progytech.co
Bronx N


"Prashant" <prashantpsoft@rediffmail.com> wrote in messag
news:45934624-8EC9-4997-9F37-6B991DAE1975@microsoft.com..
> Hello
>> I wrote 'set century off'. Then I executed a VFP report. I can see th
dates properly. e.g. 19/05/04. But if I click on the report (preview mode
the date becomes 19/05/2004. This happens everytime
>> Any solutions
> Thanks
> Prashan

Edhy
Sun May 23 13:28:32 CDT 2004

Hi Prashant,

I'm glad to help!

Reports and Forms in VFP may use Private or Default Datasession, the
commands that affect how to display the data like SET CENTURY, SET DELETED,
etc. are scope to the datasession currently active, so your report may have
inherit that setting.

For reports, I use a third party product VisualRep www.dfarber.com/vrep.html
but prior to that, I never use the data for the report in its
dataenvironment, what I have done is to create a cursor with the data the
way I want it, then call the report like this:

SELECT * FROM DCUSTOMERS WHERE CCITY = "NEW YORK" INTO CURSOR A_FOR_REPORT
IF _TALLY > 0
REPORT FORM MyReport NOCONSOLE PREVIEW
ELSE
MESSAGEBOX("No data for your report this time...")
ENDIF

The above code is just an example, of course more validations/setting may be
set prior to call the report. Using this technique, make sure you don't use
alias in your report fields and also do not use a Private Datassession.

--
Edhy Rijo
Programming System Solutions www.progytech.com
Bronx NY
ProMatrix MVP Life


"Prashant. (Thanks Edhy)" <prashantpsoft@rediffmail.com> wrote in message
news:A5D60676-3EE7-47BE-86AD-447C71BDD974@microsoft.com...
> Hi Edhy ,
>
> Thanks a lot.
> You have a done a great job for me. But I still cannot figure out why the
century turned on automatically. I had not written any commands in the data
environment ?
> Prashant.
>
> ----- Edhy Rijo wrote: -----
>
> Hi Prashant,
>
> Open the report and then open the Dataenvironment, double click
anywhere in
> the dataenvironment to go to the BeforeOpenTables method and type
your
> command there.
>
> --
> Edhy Rijo
> Programming System Solutions www.progytech.com
> Bronx NY
>
>
> "Prashant" <prashantpsoft@rediffmail.com> wrote in message
> news:45934624-8EC9-4997-9F37-6B991DAE1975@microsoft.com...
> > Hello,
> >> I wrote 'set century off'. Then I executed a VFP report. I can see
the
> dates properly. e.g. 19/05/04. But if I click on the report (preview
mode)
> the date becomes 19/05/2004. This happens everytime.
> >> Any solutions ?
> > Thanks.
> > Prashant
>
>
>