TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
eaklor
NA
1
0
VB .NET Crystal Reports, month to date
Jan 19 2005 4:49 PM
I have built an application that uses SQL database and Crystal Reports that is embedded in Visual Studio 2002. The application is running well and the Reports are working well. I have a main report with sub-reports. I have a formula to calculate month to date and year to date. As soon as I added data to the database for 2005 I now get two rows of data for 2004 and 2005, although 2004 is showing 0's. Can anyone help me determine the proper formula to show only the current year. The following is the formula format for year to date: if {mytable.myDate} in Date(year({?Date}),1,1) to {?Date} then (x+y) ?Date = parameter mytable = table myDate = Current date Thank You Julie
Reply
Answers (
1
)
create reg_expand_sz key in registry
Read Hotmail with C#