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
David Smith
NA
2k
0
rdlc field expression
Nov 19 2010 3:24 PM
Read the comments in red below.
= Max(Field!Code.Value)
Raw Table
Time TestName Status
1/01/10 Beer FAIL
1/01/10 Beer ""
1/01/10 Beer ""
1/01/10 Beer ""
2/20/10 Beer PASS
2/20/10 Beer ""
2/20/10 Beer ""
2/20/10 Beer ""
Output Im trying to Produce for a pivot or crosstab via rdlc file: Status By Time
Time TestName Status
1/01/10 Beer FAIL
2/20/10 Beer PASS
With this expression = Max(Field!Code.Status)
: Status By Time
this value is incorrect, it suppose to say FAIL if you look above in the raw table the value
is FAIL
I thinking because the testname has the same value and PASS is the max it included PASS for that test (1/01/10)
So how do write the expression to give me the max value by time via Status
Time TestName Status
1/01/10 Beer
PASS
2/20/10 Beer PASS
Reply
Answers (
0
)
connect Crystal report to two separate database servers
asp c# draging object