Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS - DateTime parameter issue Expand / Collapse
Author
Message
Posted Friday, June 7, 2013 1:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 2:35 AM
Points: 19, Visits: 200
I have deployed a report which has DateTime parameter on sharepoint server. The server is located in india. When i try to run the report (from india), i clicked on Calender icon which is beside DateTime Parameter. In the calender today's date is highlited(i.e., 7th June 2013).
My client is in US, when he clicked on clender icon, 7th June 2013 date is highlited for him also. But he needs 6th June 2013 date to be lighted because for him current date will be 6th June.

Is there any way that for users from different countries, datatime parameter will highlight their system date in calender.
Post #1460988
Posted Sunday, June 9, 2013 3:56 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:47 AM
Points: 7,126, Visits: 12,727
Where is the database server you'll be selecting from? The date needs to be from the perspective of the data in that database. You could always change it to a string input, but then you would lose the date picker.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1461353
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse