Stimulsoft Business Intelligence System | Forum

I am trying to create a condition on my report (E2 Shoptech reporting) that shows the date in the history as highlighted if has been over a year since the last completion. I believe that it is a c# reporting system. I am attaching screen shots of the condition and the report data's location. I appreciate any help you can provide as our customer is requesting an inspection if this qualification is met and we have hundreds of part that we provide to them.

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more detail, which issue do you have?

Thank you.

I am trying to have a condition on our report to highlight the last date sold if it is over 1 year per the DisplayDateComplete data. I see it as: highlight the last date processed if the date is today minus 1 year.

Hello,

You can compare DisplayDateComplete with Today.AddYears(-1)

Thank you.

How do I create that comparison? Using an expression? I apologize, I am not very well versed in how to design components in a report.

Hello,

You can use the following expression:
DisplayDateComplete == Today.AddYears(-1)

Thank you.

Using that expression it comes up with an error that DisplayDateComplete does not exist in the current context. I don't even understand what that means.

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.