Finance | Project Operations, Human Resources, ...

An expression issue in SSRS report

(0) Share

Report

Posted on by waytod365

351

Hi all,

Below expression working fine, but there is no date in form level i want to empty

Format(CDate(First(Fields!ID_ValidToAr.Value, "LetterDS")),"yyyy/MM/dd")

issue : report level its show :- #Error

I'm expacting O/p if there no date in report i want to blank that date field

Thanks

I have the same question (0)

All responses (11)

Answers (0)

huijij 19,811 on at

Like (0)

Report

Hi waytod365,

Would you specify what is your factual intent? What does it mean by blanking the date field?

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report

Thanks for your replay judy,

As i mentioned expression its works fine, issue in report level there is no date its show : [tag:Error]

Now, i don't want show [tag:Error] i don't wanna show [tag:Error] if its date field no date.

Was this reply helpful? Yes No
Suggested answer

Suresh M. Parmar 340 on at

Like (1)

Report
Hi there,

Try below expression

=iif(isNothing(First(Fields!ID_ValidToAr.Value, "LetterDS")), ' ', Format(CDate(First(Fields!ID_ValidToAr.Value, "LetterDS")),"yyyy/MM/dd"))

Thanks,

Suresh Parmar

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report

Thanks for your replay sir,

I tried your expression but, after deploy getting error:

substring 'IsNothing' in expression. The parser reported error message: Syntax error. TSPReport

Was this reply helpful? Yes No
Suresh M. Parmar 340 on at

Like (1)

Report

Oh its syntax mistake try

=iif(isNothing(First(Fields!ID_ValidToAr.Value, "LetterDS")), ' ', Format(CDate(First(Fields!ID_ValidToAr.Value, "LetterDS")),"yyyy/MM/dd"))

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report

Sir as shown in the picture error how can i do that ? please let me know.

Was this reply helpful? Yes No
Suresh M. Parmar 340 on at

Like (1)

Report

Use a double quote instead of a single quote.

=iif(isNothing(First(Fields!ID_ValidToAr.Value, "LetterDS")), " ", Format(CDate(First(Fields!ID_ValidToAr.Value, "LetterDS")),"yyyy/MM/dd"))

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report

I tried double quote and deploy is succeed , Now two cases its show '[tag:Error]'

I did SSRS service restart no luck.

If its data in date field its also show '#error'.

What could be the causes and resolutions, please give me solution.

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report

Please let me know sir, still I'm facing issue.

Was this reply helpful? Yes No
Suggested answer

Suresh M. Parmar 340 on at

Like (0)

Report

Hi,

Please add the field in report after this date column without any formatting only add Fields!ID_ValidToAr.Value then share the result,

Getting error possible ways,

1. Data is not vaid - by the cDate method system not able to find the date formatted value.

NOTE : Don't use first in expression if you are showing records in table(transaction).

Thanks

Was this reply helpful? Yes No

Join the conversation

Community site session details

An expression issue in SSRS report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

An expression issue in SSRS report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates