For Programmers: Free Programming Magazines  


Home > Archive > Visual Basic Crystal Reports > May 2005 > Different Date Value for different client time zone









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Different Date Value for different client time zone
Guzman

2005-05-24, 8:58 pm

Hi, i'm working with crystal in a client server architecture, and i'm having
this problem:

The Date Value is different for the client machines that have a different
time zone,
and i want all the clients reports to show the same date value that the
server has.
Does someone know how to solve this problem?

Regards,
Guzman.
Briscobar

2005-05-24, 8:58 pm

In news:CAA8622F-D70C-4D0A-A2A3-42C86AD73F19@microsoft.com,
Guzman <Guzman@discussions.microsoft.com> rambled:
> Hi, i'm working with crystal in a client server architecture, and i'm
> having this problem:
>
> The Date Value is different for the client machines that have a
> different time zone,
> and i want all the clients reports to show the same date value that
> the server has.
> Does someone know how to solve this problem?
>
> Regards,
> Guzman.


Build your report off a stored procedure that grabs the time from the server
and stores it as data?

I dont' know how possible that is in your situation, but that's how I'd do
it.

--

KB - MCNGP "silent thug" #26

Briscobar AT gmail DOT com

Please to be www.mcngp.com visits!


Rob Diamant

2005-05-25, 4:00 pm

Instead of using a stored procedure, you can also use a SQL Expression.

Rob

"Briscobar" <youcant@sendmespam.com> wrote in message
news:%23XqBYEKYFHA.2508@TK2MSFTNGP15.phx.gbl...
> In news:CAA8622F-D70C-4D0A-A2A3-42C86AD73F19@microsoft.com,
> Guzman <Guzman@discussions.microsoft.com> rambled:
>
> Build your report off a stored procedure that grabs the time from the
> server
> and stores it as data?
>
> I dont' know how possible that is in your situation, but that's how I'd do
> it.
>
> --
>
> KB - MCNGP "silent thug" #26
>
> Briscobar AT gmail DOT com
>
> Please to be www.mcngp.com visits!
>
>



Briscobar

2005-05-25, 4:00 pm

In news:On4365SYFHA.1384@TK2MSFTNGP09.phx.gbl,
Rob Diamant <rob@usi.com> rambled:
> Instead of using a stored procedure, you can also use a SQL
> Expression.


Why do you have to make everything so easy?

--

KB - MCNGP "silent thug" #26

Briscobar AT gmail DOT com

www.mcngp.com is real.


Rob Diamant

2005-05-25, 4:00 pm

Because if I didn't, I would really have to work.

"Briscobar" <youcant@sendmespam.com> wrote in message
news:uniO%23%23SYFHA.2128@TK2MSFTNGP15.phx.gbl...
> In news:On4365SYFHA.1384@TK2MSFTNGP09.phx.gbl,
> Rob Diamant <rob@usi.com> rambled:
>
> Why do you have to make everything so easy?
>
> --
>
> KB - MCNGP "silent thug" #26
>
> Briscobar AT gmail DOT com
>
> www.mcngp.com is real.
>
>



Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com