displaying dates in the management studio but not in the report

sqlcurious
sqlcurious used Ask the Experts™
on
Hi I have a weird problem where I am able to display the dates in the management studio when I run the stored procedure but it doesnt display any dates in the BIDS when I run it.
Can you please let me know how to solve this?
Thanks!
shyamala
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Kevin CrossChief Technology Officer
Most Valuable Expert 2011

Commented:
What is the SQL to the stored procedure?  What are example calls in SSMS that work and resulting data as a sample.
Commented:
In BIDS, you can select the properties of the textbox then write the date format that you want for that field. Date Format in SSRS

Author

Commented:
thnks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial