I need regular expression in reporting to populate column value on report

(0) Share

Report

Posted on by Sandy Hello

340

I need regular expression in reporting to populate column value on report . If (solved on– created on ) is greater than number of hours represented by "state" field values 24 hrs or 72 hrs then populate “Yes” in columnA else populate blank. In this process in need convert 24 hrs string to integer and compare with date values difference.

*This post is locked for comments

All responses (4)

Answers (0)

a33ik 84,323 Most Valuable Professional on at

Like (0)

Report

RE: I need regular expression in reporting to populate column value on report

And other mentioned details? Query, field types? I don't have superpowers to get those details without your help.
Sandy Hello 340 on at

Like (0)

Report

RE: I need regular expression in reporting to populate column value on report

Hi Andrii thanks for your reply. Report type is FetchXml
Suggested answer

Gopalan Bhuvanesh 11,397 on at

Like (0)

Report

RE: I need regular expression in reporting to populate column value on report

Hi

Please use this regular expression to get the numbers at the beginning.

^[0-9]*
a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: I need regular expression in reporting to populate column value on report

I believe you don't need regular expression for that.

What you need is expressions for SSRS.

I'm afraid that it's a bit complicated to help you with exact formula without knowing details of your report - query, report type (SQL or FetchXml), e.t.c.