VB SQL
-
Monday, August 13, 2012 8:10 AM
cleard
- Moved by Mark Liu-lxf Tuesday, August 14, 2012 5:28 AM (From:Visual Basic General)
- Edited by newbieinVB Tuesday, August 14, 2012 5:34 PM solved
All Replies
-
Monday, August 13, 2012 1:17 PManyone?
-
Monday, August 13, 2012 1:24 PM
Newbie,
Maybe it gives some answers if you give your question a good header.
Calling something a Report Viewer question while it is completely SQL transact code does seldom gives an answer.
Moreover, report questions are replied by very few persons, it takes always a lot of time to test them.
Be aware that a DateTime contains also nanoseconds so a dateTime is seldom complete equal to a date.ToDate
Therefore often >= will do a better job
Or the SQL Select code
Date Between X and Y
Success
Cor- Edited by Cor LigthertMVP Monday, August 13, 2012 1:25 PM
-
Monday, August 13, 2012 1:52 PM
hi there, i tried >= before.
it does not return anything in report viewer.
or maybe can u high light to me is my query wrong?
-
Tuesday, August 14, 2012 5:28 AM
Hi newbieinVB,
Thanks for you post.
As I read your post, it seems that the issue has more relationship with report. Microsoft provides a special forum to deal with report issue. For better support, I will move this thread to Visual Studio Report Controls forum. It will cost a little time to involve the members in this forum. I appreciate your patience.
By the way, provide the code about loading the data into report View will be much more helpful.
Sorry for any inconvenience and have a nice day.
Mark Liu-lxf [MSFT]
MSDN Community Support | Feedback to us
