find delay date if I have only 1 date column in query based report(ssrs) and i column of issue date
if product is ship so the "column of issue date =0" and when procut is received so the "column of issue date =1"
how to differ date(of delay time)
I'm sorry, but I don't understand what you're saying. Can you give us a concrete example, please?
I have 1 column status when status 0 so its means product is ship
and when status 1 so its means product is received
and I have one column of date
for eg:
status =>0 (product shiped) and date 14-01-2021
status =>1(product received) and date 19-01-2021
I want to find out delay time(date) in ssrs query based report (visual studio)
What is the delay time and what do you mean by finding it in a report?
how to find? in above eg delay time is 5 days but how to calculate difference
can someone help me
Unfortunately it's still not clear what you need from us.
Are you asking how to subtract two dates? If so, simply use the minus (-) operator in X++ or DateDiff() function in SSRS.
Or are you asking how to get the dates? Unfortunately we can't answer that, because we don't know which tables you're using and how.
I have 2 columns
1 is product issue and
2 is transdate
if product is "ship" to so product issue is "0"
and
if product is "received" to so product issue is "1"
and I have 1 column of transdate when product is ship transdate create and when product is received transdate is created find out duration of ship to received product
but the problem is that ship is row
and received is another two different rows how to find out difference?
Okay, it seems that you want to want two related rows. But I know nothing about your table and the business process, therefore I can't tell you how the rows are related. It's something you should tell us.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 783
André Arnaud de Cal... 715 Super User 2025 Season 2
Sohaib Cheema 519 User Group Leader
